Advance Excel (Business) Course - Australia

Introduction

1. What is a spreadsheet?
2. Rows and columns
3. Raw data and information

Introduction to Excel

1. Text formatting
2. Cell structure in the spreadsheet
3. Using the fill handle
4. Numeric representation
5. General editing techniques
6. Printing adjustment
7. Cell type setup

Basic Spreadsheet Operations

1. Using the AutoSum function
2. Auto Fill Quick Tip
3. Finding data in spreadsheet
4. Sorting and filtering
5. Formatting the data
6. Format Painter Quick Tip
7. Table creation and formatting
8. Charting and Analysis
9. Views in excel

Data Analysis in Excel

1. advance data sorting
2. General formulas for data analysis
3. Text-to-Columns function
4. Data cleanup
5. advance referencing techniques
6. Auditing techniques

Advance Formulas and Functions

1. Using the IF function
2. Complex IF scenarios
3. Combining SUM and IF
4. Introduction to COUNT and IFS
5. Nested IF and special functions
6. Naming cells and cross-referencing

Advance Data Auditing

1. Introduction to formula audit
2. Trace Precedents and Dependents
3. What is a watch window?
4. advance data formatting techniques

Advance Data Analysis Techniques

1. Using data validation
2. Introduction to PivotTables
3. advance PivotTables functions
4. Using PivotCharts
5. Commenting and tracking change

Security and Data Protection

1. Sheet protection and locking
2. Workbook protection and locking
3. Sharing workbook