Microsoft Office Mastery Bundle

4712 Enrolled
7 Courses & 207 Hours
$49.00$453.00
You save 89% -

What's Included

Microsoft Excel Course
Microsoft Excel Course
Microsoft Excel Course
Microsoft Excel Course
Microsoft Excel Course
Microsoft Excel Course
  • Certification included
  • Experience level required: All levels
  • Access 38 lectures & 100 hours of content 24/7
  • Length of time users can access this course: 12 months

Course Curriculum

38 Lessons (100h)

  • Microsoft Excel Course Section 1: Foundation
    Unit 1.1 - Excel Introduction
    Unit 1.2 - The Excel Interface
    Unit 1.3 - Basic Navigation and Editing
    Unit 1.4 - Getting Going
  • Section 2: Orientation & efficiency
    Unit 2.1 - Editing
    Unit 2.2 - Viewing
    Unit 2.3 - Spreadsheet Structure
    Unit 2.4 - Cell References
    Unit 2.5 - Named Ranges
    Unit 2.6 - Basic Macros
    Unit 2.7 - Design
  • Section 3: Administration
    Unit 3.1 - Customising Excel
    Unit 3.2 - Housekeeping
    Unit 3.3 - Connecting Workbooks
    Unit 3.4 - Documentation
    Unit 3.5 - Protecting and Sharing
    Unit 3.6 - Google Docs
    Unit 3.7 - Excel Troubleshooting
  • Section 4: Data Handling
    Unit 4.1 - Sorting and Filtering
    Unit 4.2 - Controlling User Input
    Unit 4.3 - Working with Dates & Times
    Unit 4.4 - Working with Text
    Unit 4.5 - Lookup and Reference
    Unit 4.6 - Logical Functions
  • Section 5: Data Analysis
    Unit 5.1 - Working with Numbers
    Unit 5.2 - Summarising Data
    Unit 5.3 - PivotTables 1 - Simple Summaries
    Unit 5.4 - PivotTables 2 - Manipulating Data
    Unit 5.5 - PivotTables 3 - Interpreting Data
    Unit 5.6 - PowerPivot: Handling Big Data
    Unit 5.7 - Formula Auditing
    Unit 5.8 - Advanced Macros and VBA
    Unit 5.9 - Modelling
  • Section 6: Presentation
    Unit 6.1 - Cell Formatting
    Unit 6.2 - Number Formatting
    Unit 6.3 - Conditional Formatting
    Unit 6.4 - Graphs and Charts
    Unit 6.5 - Page and print setup

Microsoft Excel Course

S
Skillsology

This course is brought to you by the expert team at Skillsology. For more details on this course and instructor, click here.

Description

  • Over 100 hours of learning material
  • Essential Excel functions (doesn't waste your time w/ useless functions)
  • Basic terminology & setup
  • Data analysis basics w/ PivotTables & more
  • In-depth data handling: sorting, filtering, lookup & more
  • Formatting options & training

Specs

Details & Requirements

  • Length of time users can access this course: 12 months
  • Access options: web streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all level

Compatibility

  • Internet required
  • All main versions of Excel:
    • PC: 2003, 2007, 2010, & 2013
    • Mac: 2011

Terms

  • Instant digital redemption
  • Redemption is for 12-month access once activated