01 - Basics Education

(Session 1) Excel Data Analyst Course Welcome

(Session 2) Excel File Exploration, Text & Number Formatting, and Data Analysis & Visualization, particularly in the File, Home, and Insert tabs,

(Session 3) Workbook Formatting & Visualization, Data Functions & Formulas, Data Extraction & Manipulation, Data Review & Protection, and Workbook Viewing, particularly in the Page Layout, Formulas, Data, Review, and View tabs,

(Session 4) Understanding Excel Basics, and
 

The basics education of this course literally baby step you from using arrows in navigation to making Pivot Tables and VLOOKUPs from scratch. The basics must be reviewed multiple times a day to ensure retention. These sessions are the most important sessions in the Excel Data Analyst Course because the exercises and finals work each step listed in the basics.


Robert


Session 1

Session 2

Session 3

Session 4