Microsoft Office Mastery Bundle

Deal Price$39.00

Suggested Price$349.00

You save 88%

What's Included

$50.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

SkillsologySkillsology offers comprehensive online training for beginners, intermediate and advanced users across a variety of subjects. We carefully select the areas we teach and search the globe to find the most knowledgeable subject matter experts to be our the authors. All courses are hosted on our custom built and mobile responsive learning platform.

All Skillsology courses are certified, most are CPD (UK) accredited and many can be personalized to your learning needs using Filter technology. This Filter is a diagnostic that creates a tailor-made learning experience so your course is as unique as you are. For more details on this course and instructor, click here.

Description

Microsoft Excel is the most popular spreadsheeting software on planet Earth, used by businesses in all types of industries to crunch numbers, organize data, and much more. No matter your skill level with Excel, this massive course will help you reinforce your knowledge, and expand it to new heights.

Access 38 lectures & 100 hours of content 24/7
Learn essential Excel functions (doesn't waste your time w/ useless functions)
Understand basic terminology & setup
Explore data analysis basics w/ PivotTables & more
Dive into in-depth data handling: sorting, filtering, lookup & more
Discover 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

23 Lessons (20h)

12 months

Terms

Instant digital redemption

Your Cart

Your cart is empty. Continue Shopping!

Processing order...