DON'T GET MAD...GET SKILLS!

LEARN HOW TO MAKE YOUR REPORTS PRETTY

Thursday, 04 November 2021
08:45 AM PDT

Class opens at 8:45 AM - Class starts at 9:00 AM - Class ends at 10:30 AM

Days

12

Hours

21

Minutes

30

Seconds

53

 LET'S CONTINUE LAYING A SOLID EXCEL SKILLS FOUNDATION.
LEARN HOW TO MAKE YOUR REPORTS PRETTY

Here is what you will learn in this session:

Step 4 - FORMATTING -Make It Pretty For The End User. Make It easy To Understand
  • Why Format Your Data? Plus A Handy Way To Select Your Data Range - Ctrl+A 
  • Let's Get Into Some Formatting - Make It Pretty! - Pus Some Formatting Shortcuts 
  • Formatting Money - Should You Pick The Currency Method Or The Accounting Method? 
  • Alignment- Customize The Orientation Of Your Values- Use Preset Formats (Styles) 
  • The Format_Painter 
Step 5 - REPORTING - Garbage In...Garbage Out - What About Charts?
  • 7 Habits Of Efective Lists -Learn The Right Way To Set Up Your Data Effectivelly 
  • Organize And Display Data - Sort It Out- But Avoid Merged Cells 
  • Continue Sorting - Right Click To Sort - A To Z Sorting And Keeping It Together 
  • The BIG Sort Buton 
  • Sometimes You Do Not Want To Show All The Data - Hide Rows And Columns With Ease
  •  The Filter That Lives A Healthy Lifestyle - Auto Filter
  •  Want To See What Your Numbers Are Saying? How About A Graphical Representation?
  •  Visualize Your Data With Charts - Insert Charts And See What Your Numbers Say
  •  Different Charts For Different Reasons - Change Chart Types - Make Them Pretty
  •  Sparklines - Miniature Charts Inside Of Your Cells - They Make People Say Wow!
Here Is What You Will Learn In The Next Class...

In the next class you will learn the 7 Steps To Excel Success, and we will cover Step 6 and Step 7.