Ebooks Amazon Free

FREE ALL EBOOKS ON AMAZON AND COURSES ON UDEMY- What books and courses do you need? We have them FREE for you...

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

30 January, 2020

OUTLINE & TABULAR PIVOT LAYOUTS

OUTLINE & TABULAR PIVOT LAYOUTS

There are a few things in this world that will forever be shrouded in mystery: Stonehenge, the Egyptian pyramids, and the fact that Excel PivotTables default to “Compact Form. For those of you who haven’t ventured beyond the default PivotTable layouts, prepare to be ROCKED.
In this tip, I’ll discuss why I absolutely despise Compact Form, and share some great use cases for working with Outline or Tabular layouts instead.

COMMON USE CASES:

  • Using Outline Form to sort and filter multiple fields individually
  • Using Tabular Form with repeating item labels to create new source data tables
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

28 January, 2020

ANALYZING DATA WITH HISTOGRAMS


ANALYZING DATA WITH HISTOGRAMS

Histograms are absolutely essential tools for visualizing the distribution of values, based on the frequency of observations falling within specific ranges or “bins“.
In this demo we’ll look at the heights and weights of 2,000 olympic athletes, and analyze how those values are distributed across the sample as a whole, as well as by gender and sport.

COMMON USE CASES:

  • Visualizing population demographics (height, weight, income, age, etc.)
  • Identifying the most (or least) common values in a sample

#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

25 January, 2020

CHART PROPERTIES (MOVE & SIZE)

CHART PROPERTIES (MOVE & SIZE)

By default, Excel charts are tied to the underlying grid, meaning that they move and stretch as the underlying rows and columns are modified. But what if you want to fix the exact position of your visuals, and prevent them from distorting as you make changes to the rest of the worksheet?
In this tip, we’ll adjust the chart properties to essentially “disconnect” them from the grid.

COMMON USE CASES:

  • Locking in chart positions while designing user-facing reports or dashboards
  • Allowing charts to move (but not stretch) when rows are filtered or sorted
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

23 January, 2020

CHARTING DATE RANGES

CHARTING DATE RANGES

One of my favorite things about data viz in Excel is that you can mash together all sorts of chart types to create Frankenstein-style visuals. Generally this sort of experimentation will lead to ugly, confusing, or just plain ridiculous results, but with a bit of practice you’ll begin to discover some truly interesting and powerful combinations.
In this tip, we’ll practice combining a line chart with a 100% stacked column to draw attention to specific time periods within our sample sales data.

COMMON USE CASES:

  • Highlighting sales or promotional periods to add context to charts
  • Drawing attention to seasonal patterns or trends (i.e. peak vs. off-peak, weekends vs. weekdays)
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

22 January, 2020

CUSTOM CHART TEMPLATES

CUSTOM CHART TEMPLATES

There are two things in this world that drive me nuts: ice cubes that unpredictably dislodge in the middle of a sip, and people who don’t customize their Excel visuals.
In this tip, I’ll demonstrate how easy it is to personalize a basic chart, save it as your own custom template, and apply it to other visuals with the click of a button.

COMMON USE CASES:

  • Saving specific formats for future use in other workbooks
  • Ensuring consistent formatting across all visuals in a report
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

CUSTOMIZING CHARTS TO TELL STORIES

CUSTOMIZING CHARTS TO TELL STORIES

Most people don’t think of Excel as a “data viz” platform, but then again most people have never ventured beyond basic, default templates. The fact is, Excel offers an insane amount of creative freedom — if you know what you’re doing.
In this tip, I’ll show you how a few basic adjustments to colorslabels and titles can help bring your visuals to life.

COMMON USE CASES:

  • Preparing visuals for use in presentations, where comprehension is key
  • Reducing the risk of users misinterpreting the story that a chart is designed to communicate
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

21 January, 2020

VISUALIZATION WITH SPARKLINES

VISUALIZATION WITH SPARKLINES
Every time I think about sparklines, Shakespeare comes to mind: “though she be but little, she is fierce“. That’s because even though sparklines are so tiny that they live within the confines of a single cell, they can be incredibly effective tools for visualizing patterns and trends.
In this tip, we’ll use sparklines to quickly compare how five individual sales reps performed against monthly goals.

COMMON USE CASES:

  • Embedding a simple line or column sparkline to show trends at a glance
  • Creating KPI cells to show key metrics with sparklines in the background

#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

20 January, 2020

INTERACTIVE FORM CONTROLS

INTERACTIVE FORM CONTROLS

Looking to develop pro-quality Excel models, while impressing your friends at the same time? Read on. This tip is all about designing dynamic and interactive tools using something called form controls.
In this demo we’ll visualize average wine ratings and prices by country, and add a list box form control to allow users to filter the chart down based on specific wine varieties.

COMMON USE CASES:

  • Integrating user controls into a dynamic report or dashboard
  • Consolidating multiple visuals into a single chart template
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

19 January, 2020

HIDDEN CHART SOURCE DATA

HIDDEN CHART SOURCE DATA

When building reports or dashboards in Excel, you may choose to hide the actual source data from view. However, in some cases this will cause the actual chart itself to disappear as well.
In this tip, I’ll show you how to adjust your chart settings to persist even when underlying source data is hidden.

COMMON USE CASES:

  • Designing reports with the source data and visuals on the same tab
  • Preventing users from accessing or modifying a chart’s raw source data
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

HEAT MAPS WITH COLOR SCALES


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 involve a single chart, object, or number? I hope so, because that would be a very strange thing to lie about.
This tip is all about using conditional color scales and custom number formats to create an incredibly simple — yet highly effective — heat map visual in Excel.

COMMON USE CASES:

  • Quickly identifying patterns or trends using common color scales
  • Highlighting “hot spots” or outliers based on the colors alone
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

18 January, 2020

GOAL PACING WITH GAUGE

GOAL PACING WITH GAUGE CHARTS


One of the key principles of analytics is that numbers should always be presented in context. In other words, that fact that you sold 50 widgets this week means nothing — is that more or less than you sold last week? How does that compare against benchmarks?
In this tip, we’ll discuss the importance of creating context using clear and measurable goals, and practice building custom gauge charts to visualize pacing in Excel.

COMMON USE CASES:

  • Tracking performance against benchmarks or goals
  • Designing executive scorecards to visualize key metrics at a glance
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

FILLED MAP VISUALS

FILLED MAP VISUALS

For those of you working with the latest versions of Excel, visualizing geospatial data just got a whole lot easier.
In this tip, we’ll practice plotting state-level population and income data using Excel’s new Filled Map visual, and discuss some important considerations to keep in mind along the way.

COMMON USE CASES:

  • Quickly visualizing regional patterns or trends
  • Comparing census information like population, GDP, income, or birth rates across areas
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1