Microsoft Office Mastery Bundle

4712 Enrolled

7 Courses & 207 Hours

$49.00$453.00

You save 89%

What's Included

$69.00 Value

Microsoft Excel Course

Skillsology

38 Lessons (100h)

12 months

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

SkillsologyThis 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

$69.00 Value

Advanced Microsoft Excel Course

Skillsology

20 Lessons (27h)

12 months

$69.00 Value

Microsoft PowerPoint Course

Skillsology

23 Lessons (20h)

12 months

$69.00 Value

Microsoft Word Course

Skillsology

26 Lessons (20h)

12 months

$69.00 Value

Effective Outlook Course

Skillsology

21 Lessons (15h)

12 months

$39.00 Value

PivotTable Course

Skillsology

12 Lessons (10h)

12 months

$69.00 Value

SharePoint Course

Skillsology

23 Lessons (15h)

12 months

Terms

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

Your Cart

Your cart is empty. Continue Shopping!

Processing order...