KINGEXCEL.INFO

Showing posts with label New free Course 100 Video - Excel PRO TIPS for Power Users. Show all posts

OUTLINE & TABULAR PIVOT LAYOUTS

January 30, 2020

OUTLINE & TABULAR PIVOT LAYOUTS There are a few things in this world that will forever be shrouded in mystery: Stoneheng...

ANALYZING DATA WITH HISTOGRAMS

January 28, 2020

ANALYZING DATA WITH HISTOGRAMS Histograms are absolutely essential tools for visualizing the distribution of values, base...

CHART PROPERTIES (MOVE & SIZE)

January 25, 2020

CHART PROPERTIES (MOVE & SIZE) By default, Excel charts are tied to the underlying grid, meaning that they move and st...

CHARTING DATE RANGES

January 23, 2020

CHARTING DATE RANGES One of my favorite things about data viz in Excel is that you can mash together all sorts of chart types...

CUSTOM CHART TEMPLATES

January 22, 2020

CUSTOM CHART TEMPLATES There are two things in this world that drive me nuts: ice cubes that unpredictably dislodge in the mi...

CUSTOMIZING CHARTS TO TELL STORIES

January 22, 2020

CUSTOMIZING CHARTS TO TELL STORIES Most people don’t think of Excel as a “ data viz ” platform, but then again most people ...

VISUALIZATION WITH SPARKLINES

January 21, 2020

VISUALIZATION WITH SPARKLINES Every time I think about sparklines, Shakespeare comes to mind: “ though she be but little, she ...

INTERACTIVE FORM CONTROLS

January 20, 2020

INTERACTIVE FORM CONTROLS Looking to develop pro-quality Excel models, while impressing your friends at the same time? Read ...

HIDDEN CHART SOURCE DATA

January 19, 2020

HIDDEN CHART SOURCE DATA When building reports or dashboards in Excel, you may choose to hide the actual source data from vie...

HEAT MAPS WITH COLOR SCALES

January 19, 2020

HEAT MAPS WITH COLOR SCALES Would you believe me if I told you that one of my all-time favorite visuals in Excel doesn’t i...

GOAL PACING WITH GAUGE

January 18, 2020

GOAL PACING WITH GAUGE CHARTS One of the key principles of analytics is that numbers should always be presented in con...

FILLED MAP VISUALS

January 18, 2020

FILLED MAP VISUALS For those of you working with the latest versions of Excel, visualizing geospatial data just got a wh...

Subscribe to: Posts ( Atom )

OUTLINE & TABULAR PIVOT LAYOUTS

ANALYZING DATA WITH HISTOGRAMS

CHART PROPERTIES (MOVE & SIZE)

CHARTING DATE RANGES

CUSTOM CHART TEMPLATES

CUSTOMIZING CHARTS TO TELL STORIES

VISUALIZATION WITH SPARKLINES

INTERACTIVE FORM CONTROLS

HIDDEN CHART SOURCE DATA

HEAT MAPS WITH COLOR SCALES

GOAL PACING WITH GAUGE

FILLED MAP VISUALS

Trang

Pages

Trang

Top Post

Random Posts

Recent Comments

Popular Posts

Search This Blog

About Me

Total Pageviews

Translate

About me

Popular Posts

Popular Posts

Bài đăng phổ biến

Recent Posts

Bài đăng phổ biến

Random Posts

Bài đăng phổ biến

Popular Posts