Hanging up sheets on the clothesline is a frightening experience, especially when the high thread count gangs up on you, 1000 to one. Sort out spreadsheet concerns with today’s Groupon:

The Deal

$19 for Basic or Advanced Excel training for one person (Don’t pay $199)

$29 for Basic and Advanced Excel training for one person (Don’t pay $299)

$160 for Basic or Advanced Excel training for ten people (Don’t pay $1,990)

$260 for Basic and Advanced Excel training for ten people (Don’t pay $2,990)

Crawl out from under the computer desk and face the fear of the unknown with an online course for beginners or advanced users. Newbies absorb 20 video tutorials, exercise files, games and quizzes in the Basic course designed to teach the skills needed to use Excel comfortably for work or study.

The Advanced course extends on the basic tools of the trade with modules on formula auditing and data analysis. Both courses take place online and aim to personalise training to suit individual needs while providing cheat sheets to jog the memory after each module. Those looking for an entire Excel rundown can opt for both the Basic and Advanced courses, designed to be completed within four hours. Groupies can buy for themselves, or choose the 10 people option to brush-up the skills of an entire team or business. Students receive an accredited certificate upon completion.

Syllabuses

Basic Excel

• The Ribbon
• The Excel Work Surface
• Navigating the Excel Interface
• Creating your first Excel file
• Formatting Basics
• Basic Math and Formulas
• Math Functions
• Cell Referencing
• Basic Statistics
• Logic Functions
• Text Functions
• Conditional Math
• External Links
• Sorting
• Filtering
• Contiguous Data
• Cell Formatting
• Building Column Charts
• Building Pie Charts
• Comments

Advanced Excel

• Understanding Dates
• Understanding Time
• Formula Auditing
• Temporal Functions
• VLOOKUP with Approximate Match
• VLOOKUP with Exact Match
• Other Lookup Methods
• Naming Ranges
• Excel Tables
• Recording Macros
• Creating PivotTables
• Formatting PivotTables
• Calculated Fields in PivotTables
• What-If Analysis
• Outlining
• Custom Number Formats
• Conditional Formats with Built-In Rules
• Conditional Formats with Custom Rules
• Data Validation
• Styles
• Custom Views
• Page Setup Options
• Security Considerations