Introduction
Exercise
01_Introduction to Excel functions
02_Working with SUM()
03_Working with MIN() and MAX()
04_Working with AVERAGE()
05_AutoSum and AutoFill
06_Working with COUNT()
Practice Challenge Excel Functions
Introduction
01_Formatting Numbers
02_Font Formatting
03_Formatting Rows and Columns
04_Cell Alignment
05_Using Format Painter
06_Applying and Creating Cell Styles
07_Inserting Images and Excel Shapes
08_ Worksheet Layout and Formatting _SmartArt
Introduction
01_Working with Multiple Worksheets
02_Insert, Delete and Manage Columns and Rows
03_Find and Replace
04_Filtering Data
05_Sorting Data
06_Conditional Formatting
Practice Challenge : Working with Data
Introduction
01_Understanding Excel’s Charts
02_Creating and Inserting Charts
03_Formatting Excel Charts
04_Moving Charts to Separate Worksheets
Introduction
01_Understanding Page Layout and Print Preview Mode
02_Insert, Move or Delete Page Breaks
03_Printing Worksheets or Specific Cells
Practice Challenge Chap 4 & 5
