Course Code:
sephoraexcelbasic
Duration:
3 hours
Course Outline:
Lesson 1 • Introduction to the Quick Access Toolbar • Freezing Panes • Functions & Formulae • SUM, AVERAGE, IF, Vlook up & SUM IF
Lesson 2 • Printing to PDF or XPS • Protect the Sheets & Workbooks • Auditing Worksheet & Error Checking • Data validation • Text & Numbers • Value List
Lesson 3 • Conditional formatting • Creating charts • Enhancing the chart with the drawing tools, titles and Values • Changing the source of the data • Creating a 3D chart • Working with the Axes • Filters & sorting