Let’s get started with Excel
- What you can do with Excel
- The Excel Interface
- Basic Navigation and viewing
- Editing and formatting text
- Formatting cells
- Merging cells
- Justify text
- Spreadsheets
- Understanding Cell References
Getting inside
- Understanding Formulas and Functions
- Auto functions
- 3D formulas
- Exploring basic functions (SUM, AVERAGE, COUNT, MAX, MIN)
- Absolute references and relative references
- Converting from different measures
- The ROUND functions
- The MOD function
- The INDIRECT function
- The OFFSET function
- AND and OR functions
- Using shortcuts
Working with text
- Custom formatting
- Working with dates
- Date functions
- An unknown function: the DATEDIF function
- Useful text function
- Other text functions
- The Convert feature
- The Find and Replace feature
- SUBSTITUTE and REPLACE functions
Managing a document
- Building a serie
- Freezing pane
- Creating and managing Header and Footer
- Print a document
- Using Styles
- Using Conditional Formatting
- Avoid errors with the AGGREGATE function
- The Subtotal feature and the SUBTOTAL function
- Grouping a dataset
Working with large amount of data
- Working with tables
- Assigning a name to a dataset
- Filtering a list
- Suppress double entries
- Consolidating data in a single spreadsheet
- Data validation
- Creating a connected list
Logical functions
- The IF function
- SUMIF, AVERAGEIF, COUNTIF functions
- Nested functions
- The IFS functions
- The DATABASE functions
- The IFERROR function
Look Up functions
- VLOOK UP and HLOOK UP functions
- Nested Look Up functions
- The INDEX function
- The EQUIV function
PIVOT Tables
- Understanding the difference between Table and Pivot Table
- Creating a Pivot Table
- Using Field to sort data
- Managing a Pivot Table
- Pivot Filtering
- Pivot Chart
Charts
- Using charts: When and How
- Creating a Sparkline
- Creating a Chart
- Modifying Chart
- Switching data
- Formatting a Chart using Labels
Advanced features
- Some financial function
- Data Table and arrays functions
- What-if Analysis tool
- Goal Seek tool
- Activating the Solver tool and the Analysis Toolpack
- What is a Macro
- Creating a Macro