Advanced Excel Online Training Syllabus:
- Create worksheets and workbooks
- Prepare workbooks for collaboration
- Navigate in worksheets and workbooks
- Format worksheets and workbooks
- Customize options and views for worksheets and workbooks
- Format cells and ranges
- Insert data in cells and ranges
- Fill cells based on existing data
- Apply advanced conditional formatting and filtering
- Summarize and organize data
- Format and validate data
- Create and manage tables
- Manage table styles and options
- Filter and sort a table
- Summarize data by using functions
- Perform data analysis
- Perform conditional operations by using functions
- Format and modify text by using functions
- Perform logical operations in formulas
- Look up data by using functions
- Use advanced date and time functions
- Troubleshoot formulas
- Create and modify advanced charts
- Create and modify PivotTables
- Create and modify PivotCharts
- Create and modify simple macros
