Crash Courses for Excel

Laser focused learning for your spreadsheets. Ninety minute sessions for your favorite features.

Course List

WHAT AN EXCELLENT WAY TO START  |  APRIL 12, 10 AM

Learn how to get going inside of Excel and build your foundations

  • Navigate the Excel User Interface
    • Explore the Ribbon, Customize the Quick Access Toolbar
  • Use Excel Commands
    • Navigation tools, selection tools
  • Create and Save a Basic Workbook
    • Save As options
  • Excel Online
    • Comparing online versus desktop versions
  • Enter Cell Data
    • Data entry tools, using the Fill Handle, Duplicate, Copy Above
  • Use Excel Help
    • Search bar, Help, What’s New
LET’S DO SUM THING – CREATING CALCULATIONS   |  MAY 10, 10 AM

Learn to go-to formulas for Excel

  • Create Worksheet Formulas
    • Basic Formulas, Absolute References, Show/Hide Formulas
  • Insert Functions
    • Sum, Average, Max, Min, Count, Counta, Today, Now
  • Reuse Formulas and Functions
    • Quick Calculator, Fill formulas
  • Use Specialized Functions
    • Countif, Sumif, Averageif, Maxif, Minif
WELL DRESSED WORKSHEETS  |  JULY 19, 10 AM

Learn the best tools to dress up your spreadsheets

  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Colors, Borders, and Styles
  • Apply Basic Conditional Formatting
  • Create and Use Templates
FUNCTION AT THE HIGHEST LEVEL  |  MAY 24, 10 AM

Learn the advanced formulas you need to master your data

  • Work with Ranges
    • Absolute References, Named Ranges, Apply Names, Create from Selection
  • Work with Logical Functions
    • Comparison Operators, If, And, Or, Not, Nested formulas
  • Work with Date and Time Functions
    • Today, Now, Date, Networkdays, Weekday, Workday, Isoweeknum
  • Work with Text Functions
    • Left, Right, Mid, Find, Text to Columns, Concat, Upper, Lower, Proper
YOUR DATA YOUR WAY – SORT AND FILTER  |  AUGUST 16, 10 AM

See what you want to see with the power of Sorts, Subtotals, Filters, and Slicers

  • Sort Data
    • Quick Sort, Multi-level Sorts, Custom Sorting
  • Outline and Subtotal Data
    • Subtotal, Format Subtotals
  • Filter Data
    • AutoFilter, Text and Number Filters, Custom Filters
  • Filter with Slicers
    • Format as Table, Total Row, Slicers
  • Query Data with Database Functions
    • DAverage, DSum
CONDITIONAL LOVE FOR ANALYZING DATA  |  AUGUST 2, 10 AM

Learn the power of Table Formats and Conditional Formatting to help you analyze your data

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
VISUALIZE THIS! – CREATING KILLER CHARTS   |  JULY 6, 10 AM

Take your charts to the next level with advanced features

  • Create Charts
    • Quick charts, Recommended charts, chart types
  • Modify and Format Charts
    • Data source, elements, layouts, styles
  • Use Advanced Chart Features
    • Change scale, dual axis charts, trendlines, templates
MAKING DATA DYNAMIC – USING PIVOTTABLES AND PIVOTCHARTS   |  JUNE 7, 10 AM

Learn how to pivot and slice your data to make better decisions with your data

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers
ONE BUTTON WONDERS – AUTOMATING WORKBOOK FUNCTIONALITY   |  JUNE 21, 10 AM

Learn how to reduce errors and do repetitive tasks with one click

  • Apply Data Validation
    • Settings, Input Messages, Error Messages
    • Lists, dynamic lists
  • Search for Invalid Data and Formulas with Errors
    • Circle invalid data, Go To Special
  • Work with Macros
    • Record macro, view macro, VBA basics
Find it Faster – Using Lookup Functions and Formula Auditing   |  AUGUST 30, 10 AM

Learn the power of lookup functions and eradicate your errors

  • Use Lookup Functions
    • Vlookup, Hlookup, Index and Match, Xlookup
  • Trace Cells
    • Trace Precedents, Trace Dependents
  • Watch and Evaluate Formulas
    • Watch Window, Freeze Panes, Split Screen, New Window and Arrange All
    • Error Checking, Evaluate Formula, Iferror
TIPS AND TRICKS TO HELP YOU EXCEL  |  APRIL 26, 10 AM

Work smarter, faster and easier with the shortcuts and tools you didn’t know you needed

  • Work Smarter
    • Customize the Quick Access Toolbar, Formatting tools, Formula tricks, Named Ranges
  • Work Faster
    • Shortcut keys, Fill Features, Flash Fill, Quick Charts, Save As
  • Work Easier
    • Paste options, screenshots, working with worksheets
  • Work Error-Free
    • Ignore errors, hide zeroes, autocorrect, iferror

 

 

 

 

 

Pricing

$125 per Session

$950 - 10 Sessions purchased for a single individual

$2,150 - 20 Sessions to be used by anyone in the organization

To purchase a course, click the course title

For more info, email us at: 
info@newhorizonsdm.com