Excel 2010 - en

Excel 2010 – en

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