Log On/Register  

855.838.5028

Excel 2010

Duration: 3 Days, 6 Modules
Module Price: $130
Try Our Excel 2010 E-Learning Video Description

Day 1:

The first day of Excel is designed to create a strong foundation for using the world’s most popular business software as a place to organize and analyze information.  Participants in this course will start by establishing fundamental skills and best practices essential for using Excel, and will leave with a working knowledge of basic formulas and functions, as well as key tools to organize, format, and manage data in a spreadsheet.  This course is designed for Individuals, Career Changers, Skill enhancement.

 

MODULE 1: Excel Essentials & Intro to Formulas and Functions

  • Introduction to the Excel 2010 Interface (The Ribbon, The Backstage View& The Quick Access Toolbar)
  • Zooming in and out of a worksheet
  • Navigating and selecting cells
  • Keyboard Shortcuts
  • Entering and editing data
  • Deleting/replacing cell data
  • Performing simple calculations
  • Saving the workbook file
  • Checking compatibility with older versions of Excel
  • Overview of the Formulas Ribbon
  • Building basic Formulas
  • Using simple Functions
  • Copying formulas/functions with the AutoFill command
  • Using Relative and Absolute cell references in calculations

 

MODULE 2: Formatting, Spreadsheet Design, Page Setup & Printing

  • Inserting rows & columns
  • Moving, copying and pasting data
  • Using AutoFill to complete a series of values
  • Introduction to worksheet Themes
  • Formatting worksheet data/using Cell Styles
  • Using Excel templates/creating custom templates
  • Managing worksheets: inserting, deleting, renaming, move/copy
  • Grouping worksheets
  • Freezing or splitting panes
  • Grouping and Hiding Rows/Columns
  • Creating custom views
  • Spell checking your worksheets
  • Setting print options through Page Setup
  • Using the Page Layout view
  • Printing your worksheet

 

Day 2:

Intermediate Excel focuses on how to import, organize, explore, and control the information you have in Excel.  Participants will master data management tools like sorting & filtering, as well as powerful data exploration tools like charts & pivot tables.  In addition, you will discover new ways to control your information and avoid error, including how to create dropdown menus or lock a cell for editing.  This course is designed for everyone looking to work with large sets of data in the most efficient and impactful way possible.

 

MODULE 3: List/Table Essentials & Charting

  • Overview of List design
  • Formatting lists as Tables
  • Single and Multi-level Sorting
  • Removing duplicates from a list or table
  • Filtering records in a list or table
  • Search by Filter
  • Inserting automatic subtotals in a list
  • Inserting data charts
  • Formatting and editing chart elements
  • Adding/removing data from a chart
  • Creating custom chart templates
  • Printing charts
  • Changing table and chart formatting through Themes
  • Inserting Sparkline

 

MODULE 4: Importing Data, Pivot Tables, Protecting & Linking Data

  • Importing data from other sources
  • Overview of exporting options
  • Creating a database query
  • Creating Pivot Tables from lists or tables
  • Filtering Pivot Tables
  • Using the Slicer tool within a Pivot Table
  • Working with Pivot charts
  • Applying Data Validation rules
  • Applying built in Conditional Formatting
  • Creating custom conditional formats
  • Inserting & editing Comments
  • Linking Data
  • Cell, sheet, and file protection

 

Day 3:

Many of the most powerful functions in Excel are not designed intuitively, and there are many hidden data analysis tools capable of discovering the key values that change bottom lines.  Through this course, participants will master how and when to use all of them.  The final module focuses on macros, or customized multi-step automation, a tool that regularly turns hours long tasks into a single click of the mouse. Participants should already be using Excel regularly, but want to realize the full potential of the world’s most extensive business application.

 

MODULE 5: Creating Advanced Functions

  • Creating and applying Names in a worksheet
  • Using the IF function
  • Introduction to nesting functions
  • Using the formula auditing tools
  • Using the LOOKUP functions
  • Using SUMIF(S), COUNTIF(S), AVERAGEIF(S) functions
  • Using the IFERROR function
  • Other useful functions (Database, Text and Date functions – time permitting)

 

MODULE 6: Using the "What If" Analysis Tools & Recording Macros

  • Using the Consolidate Data commands
  • Using the Goal Seek and Solver tools
  • Creating Data Tables
  • Using the Scenario Manager
  • Adding the Developer Tab to the Ribbon
  • Recording and running macros
  • Editing macros with the Visual Basic Editor
  • Creating buttons to run macros (Quick Access Toolbar & worksheet buttons)
  • Microsoft OneDrive Overview
  • Customizing the Ribbon

Day 1:

The first day of Excel is designed to create a strong foundation for using the world’s most popular business software as a place to organize and analyze information.  Participants in this course will start by establishing fundamental skills and best practices essential for using Excel, and will leave with a working knowledge of basic formulas and functions, as well as key tools to organize, format, and manage data in a spreadsheet.  This course is designed for Individuals, Career Changers, Skill enhancement.

 

MODULE 1: Excel Essentials & Intro to Formulas and Functions

  • Introduction to the Excel 2010 Interface (The Ribbon, The Backstage View& The Quick Access Toolbar)
  • Zooming in and out of a worksheet
  • Navigating and selecting cells
  • Keyboard Shortcuts
  • Entering and editing data
  • Deleting/replacing cell data
  • Performing simple calculations
  • Saving the workbook file
  • Checking compatibility with older versions of Excel
  • Overview of the Formulas Ribbon
  • Building basic Formulas
  • Using simple Functions
  • Copying formulas/functions with the AutoFill command
  • Using Relative and Absolute cell references in calculations

 

MODULE 2: Formatting, Spreadsheet Design, Page Setup & Printing

  • Inserting rows & columns
  • Moving, copying and pasting data
  • Using AutoFill to complete a series of values
  • Introduction to worksheet Themes
  • Formatting worksheet data/using Cell Styles
  • Using Excel templates/creating custom templates
  • Managing worksheets: inserting, deleting, renaming, move/copy
  • Grouping worksheets
  • Freezing or splitting panes
  • Grouping and Hiding Rows/Columns
  • Creating custom views
  • Spell checking your worksheets
  • Setting print options through Page Setup
  • Using the Page Layout view
  • Printing your worksheet

 

Day 2:

Intermediate Excel focuses on how to import, organize, explore, and control the information you have in Excel.  Participants will master data management tools like sorting & filtering, as well as powerful data exploration tools like charts & pivot tables.  In addition, you will discover new ways to control your information and avoid error, including how to create dropdown menus or lock a cell for editing.  This course is designed for everyone looking to work with large sets of data in the most efficient and impactful way possible.

 

MODULE 3: List/Table Essentials & Charting

  • Overview of List design
  • Formatting lists as Tables
  • Single and Multi-level Sorting
  • Removing duplicates from a list or table
  • Filtering records in a list or table
  • Search by Filter
  • Inserting automatic subtotals in a list
  • Inserting data charts
  • Formatting and editing chart elements
  • Adding/removing data from a chart
  • Creating custom chart templates
  • Printing charts
  • Changing table and chart formatting through Themes
  • Inserting Sparkline

 

MODULE 4: Importing Data, Pivot Tables, Protecting & Linking Data

  • Importing data from other sources
  • Overview of exporting options
  • Creating a database query
  • Creating Pivot Tables from lists or tables
  • Filtering Pivot Tables
  • Using the Slicer tool within a Pivot Table
  • Working with Pivot charts
  • Applying Data Validation rules
  • Applying built in Conditional Formatting
  • Creating custom conditional formats
  • Inserting & editing Comments
  • Linking Data
  • Cell, sheet, and file protection

 

Day 3:

Many of the most powerful functions in Excel are not designed intuitively, and there are many hidden data analysis tools capable of discovering the key values that change bottom lines.  Through this course, participants will master how and when to use all of them.  The final module focuses on macros, or customized multi-step automation, a tool that regularly turns hours long tasks into a single click of the mouse. Participants should already be using Excel regularly, but want to realize the full potential of the world’s most extensive business application.

 

MODULE 5: Creating Advanced Functions

  • Creating and applying Names in a worksheet
  • Using the IF function
  • Introduction to nesting functions
  • Using the formula auditing tools
  • Using the LOOKUP functions
  • Using SUMIF(S), COUNTIF(S), AVERAGEIF(S) functions
  • Using the IFERROR function
  • Other useful functions (Database, Text and Date functions – time permitting)

 

MODULE 6: Using the "What If" Analysis Tools & Recording Macros

  • Using the Consolidate Data commands
  • Using the Goal Seek and Solver tools
  • Creating Data Tables
  • Using the Scenario Manager
  • Adding the Developer Tab to the Ribbon
  • Recording and running macros
  • Editing macros with the Visual Basic Editor
  • Creating buttons to run macros (Quick Access Toolbar & worksheet buttons)
  • Microsoft OneDrive Overview
  • Customizing the Ribbon

Prerequisites: No prerequisites for this course

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):