Logical Imagination offers Microsoft Excel training via our live, instructor-led online classes or as onsite classes at your location.

Microsoft Excel is a powerful spreadsheet application that features calculation, graphing tools, pivot tables and other data analysis tools. The first thing you’ll see when you open the newest version of Excel is a brand new look. It’s cleaner, but it’s also designed to help you get professional-looking results quickly. You’ll find many new features that let you get away from walls of numbers and draw more persuasive pictures of your data, guiding you to better, more informed decisions.*

*Product details provided by Microsoft. Check out more product details at Microsoft.com.

  • Excel 2013 / 2016 - Introduction

    Excel 2013 / 2016 - Introduction Logo
    This course will familiarize students with spreadsheet terminology and the fundamental concepts of Microsoft Excel, including identifying Excel window components, navigating worksheets, and downloading templates. In addition, students will learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats. They will learn how to move and copy data and formulas, how. . .

    Excel 2013 / 2016 - Introduction

    • Getting started
      • Spreadsheet terminology
      • The Excel environment
      • Navigating a worksheet
      • Using a template
    • Entering and editing data
      • Entering and editing text and values
      • Entering and editing formulas
      • Saving and updating workbooks
    • Modifying a worksheet
      • Moving and copying data
      • Moving, copying, and viewing formulas
      • Absolute and relative references
      • Inserting and deleting ranges, rows, and columns
    • Functions
      • Entering functions
      • AutoSum
      • Other common functions
    • Formatting
      • Text formatting
      • Row and column formatting
      • Number formatting
      • Conditional formatting
      • Additional formatting options
    • Charts
      • Chart basics
      • Formatting charts
    • Graphics
      • Working with pictures
      • Conditional formatting with graphics
      • SmartArt graphics
    • Printing
      • Preparing to print
      • Page Setup options
      • Printing worksheets
  • Excel 2013 / 2016 - Intermediate

    Excel 2013 / 2016 - Intermediate Logo
    This course will teach students how to work with large worksheets in Microsoft Excel, and use multiple worksheets and workbooks efficiently. It will introduce them to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, students will learn how to create outlines and subtotals, and how to create and apply cell names. They will sort. . .

    Excel 2013 / 2016 - Intermediate

    • Managing workbooks and worksheets
      • Viewing large worksheets
      • Printing large worksheets
      • Working with multiple worksheets
      • Linking worksheets with 3-D formulas
      • Using multiple workbooks
      • Linking workbooks
    • Advanced formatting
      • Using special number formats
      • Working with themes
      • Other advanced formatting
    • Outlining and subtotals
      • Outlining and consolidating data
      • Creating subtotals
    • Cell and range names
      • Creating and using names
      • Managing names
    • Data structure and tables
      • Sorting and filtering data
      • Working with tables
    • Web and sharing features
      • Saving workbooks as Web pages
      • Using hyperlinks
    • Documenting and auditing
      • Auditing features
      • Comments in cells and workbooks
      • Protection
      • Workgroup collaboration
    • Application settings and templates
      • Application settings
      • Working with templates
  • Excel 2013 / 2016 - Advanced

    Excel 2013 / 2016 - Advanced Logo
    In this course, students will further build on the skills acquired in the Microsoft Excel Introduction 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. . .

    Excel 2013 / 2016 - Advanced

    • Advanced functions and formulas
      • Logical functions
      • Conditional functions
      • Financial functions
      • Text functions
      • Date and time functions
      • Array formulas
      • Calculation options
    • Lookups and data tables
      • Using lookup functions
      • Creating data tables
    • Advanced data management
      • Validating cell entries
      • Advanced filtering
    • Advanced charting
      • Chart formatting options
      • Combination charts
      • Graphical objects
    • PivotTables and PivotCharts
      • Working with PivotTables
      • Modifying PivotTable data
      • Formatting PivotTables
      • Using PivotCharts
      • PowerPivot
    • Exporting and importing data
      • Exporting and importing text files
    • Analytical tools
      • Goal Seek
      • Scenarios
      • Instant data analysis
    • Macros and Visual Basic
      • Running and recording a macro
      • Working with VBA code
    • Accessibility and language features
      • Accessibility considerations
      • Internationalization