See your data in new, intuitive ways!
excel 2013 advanced
view/download course outline
audience
For any Microsoft Windows or Microsoft Office user with a solid understanding of how to work in Excel and have a solid understanding of the most used functions and features in Excel.

  PREREQUISITES
A solid understanding of basic and intermediate level work in Excel, including functions and formulas, tables, formatting and are looking for more advanced functions and features available in Excel.
objectives
In this course, students will further build on the skills acquired in the Microsoft Excel 2013 Basic and Intermediate courses. They will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation, and will use advanced data filtering. They will apply advanced chart formatting options, and create more complex charts. They will work with PivotTables and PivotCharts, export and import data, and query external databases. Students will learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, they will run and record macros, and explore VBA code.
outline
This course will cover the following topics...
1: Advanced Functions and Formulas
1: Advanced Functions and Formulas
  • This module will explore utilizing advanced functions in Excel.

    • Logical functions
    • Conditional functions
    • Financial functions
    • Text functions
    • Date functions
    • Array formulas
2: Lookups and Data Tables
2: Lookups and Data Tables
  • This module will cover the advanced lookup features and functions in Excel.

    • Using lookup functions
    • Using MATCH and INDEX
    • Creating data tables
3: Advanced Data Management
3: Advanced Data Management
  • This module will cover data validation and advanced filtering options.

    • Validating cell entries
    • Advanced filtering
4: Advanced Charting
4: Advanced Charting
  • This module will focus on Advanced charting options and the use of graphical objects.

    • Chart formatting options
    • Combination charts
    • Graphical objects
5: PivotTables and PivotCharts
5: PivotTables and PivotCharts
  • This module will cover some of the most powerful features available within Excel to analyze, filter and manipulate all of your data, using a single or multiple data sources.

    • Working with Pivot Tables
    • Rearranging PivotTables
    • Formatting PivotTables
    • PivotCharts
6: Exporting and Importing Data
6: Exporting and Importing Data
  • This module will explore different options to export and import data into Excel, from different sources.

    • Exporting and importing data
    • Exporting and importing text files
    • Getting external data
7: Analytical Tools
7: Analytical Tools
  • Learn how to leverage the goal seek and scenario functions in Excel.

    • Goal seek
    • Scenarios
8: Macros and Visual Basic
8: Macros and Visual Basic
  • This module will demonstrate how to create basic macros and to work within the Visual Basic environment.

    • Running and recording a macro
    • Working with VBA code
  JOIN OUR EMAIL LIST
Receive information on courses, special deals, and upcoming course dates, as well as quick registration for courses!
We will never sell, rent, or trade your information and you can change your email preferences at any time.
  2 LOCATIONS