Getting Started with Excel
  • What is Excel used for?
  • Excel Toolbars and shortcut menues
  • Workbooks and Worksheets
  • How to look for Help on Excel - Using Excel Help
  • Chapter Quiz
Entering Data
  • Data entry, Editing and AutoFill
  • Entering Dates and Time
Formulas and Functions
  • Working with Simple formulas
  • Using the SUM() function
  • Using the MIN() and MAX() functions
  • Using the AVERAGE() finction
Charts
  • How to Create Charts in Excel
  • Chart Types
  • Exploring Excel Ideas
PivotTables in Excel
  • Introduction
  • Create your first PivotTable
  • Configure your PivotTable
  • Create a PivotTable from external data source
  • Manage PivotTables
Summarizing PivotTable Data
  • Subtotals and Grand Totals
  • Operations of the Data field summary
  • Adding more than one data field
  • Managing Dates in PivotTables
  • Creating Calculated Fields
  • Drilling down the data
  • Sorting the data
  • Filtering the data
  • Filter by rules
  • Filtering with search
  • Filtering using Slicers
  • Formatting the slicers
  • More on filtering your data
  • Clearing and re-applying filters
  • Filtering the PivotTable with a Timeline
  • Changing the style of the PivotTable
  • Changing the Layout of the PivotTable
  • Formatting the numbers in the PivotTable
Conditional formatting for PivotTables
  • Highlighting cells by applying a rule
  • Highlight the top values in a PivotTable
  • Formatting cells using data bars
  • Formatting cells using colour scale
  • Formatting cells using icon sets
  • Edit a conditional formatting rule
  • Multiple formatting
Creating and Formating PivotChart
  • Create a PivotChart
  • Pivot a PivotChart
  • Filter a PivotChart
  • Format a PivotChart
  • Change a PivotChart type/Layout
  • Add a trendline to a PivotChart
Advanced Formulas and Functions
  • Display and highlight formulas
  • Auditing tools
  • Use entire row/column reference
  • Change formulas to values and update values with formulas
  • Debugging formulas with the F9 key
  • Improve readability with cells and range names
  • IF logical test and the use of relational operators
  • Nested IF statement
  • Compound logical tests with AND, OR
  • Use IFS for multiple conditions
  • COUNTIF, AVERAGEIF, SUMIF
  • COUNTSIFS, AVERAGEIFS, SUMIFS
  • MAXIFS, MINIFS
  • Subtotal function
  • Date and Time overview
  • Use Date and Time functions
  • TODAY and NOW functions
  • WEEKDAY function
  • Count working days and completion dates (NETWORKDAYS and WORKDAY)
  • Calculate dates with EDATE and EOMONTH functions