Ultimate All-Level Excel Bootcamp

5819 Enrolled

69 Hours

$35.00$249.00

You save 85%

87 Lessons (69h)

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
Advanced Excel Course Section 1: Design and Risk
Unit 1.1 - Templates
Unit 1.2 - Efficiency and Risk
Unit 1.3 - Data Validation
Section 2: Advanced Techniques
Unit 2.1 - Functions and Superpowers
Unit 2.2 - Array Formulae
Unit 2.3 - Tables
Unit 2.4 - Advanced Range Names
Unit 2.5 - What If?
Unit 2.6 - Problem Solving
Section 3: Excel Interactivity
Unit 3.1 - Form Controls
Unit 3.2 - Visual Basic and Macros
Section 4: Spreadsheet Impact
Unit 4.1 - Practical Interactivity with VBA
Unit 4.2 - Conditional Formatting
Unit 4.3 - Charts that Inspire
Unit 4.4 - Sparklines
Unit 4.5 - Graphics Tricks and Techniques
Unit 4.6 - Working with External Data
Section 5: Turning Data into Decisions
Unit 5.1 - Advanced Uses of PivotTables
Unit 5.2 - PowerPivot
Unit 5.3 - Reporting with PowerPivot
Business Analysis Section 1: Introduction
Unit 1.1 - Turning Numbers into Better Business Decisions
Section 2: The Business Analyst's Excel Toolbox
Unit 2.1 - Essential Excel for Business Analysis
Unit 2.2 - Professional Tools for Business Analysts
Section 3: Collecting and Managing Business Data
Unit 3.1 - Importing and Exporting Data
Unit 3.2 - Power Functions for Managing Business Data
Section 4: Communicating Your Message
Unit 4.1 - Your Stakeholders and Their Needs
Unit 4.2 - Data Presentation Formats That Work
Section 5: Winning Charts for Business Communication
Unit 5.1 - Professional Charting
Unit 5.2 - Dynamic Charts
Unit 5.3 - Some Special Charts for Business Analysis
Section 6: Looking Inside your Data (Analysis)
Unit 6.1 - Analysing Data With Pivot Tables
Unit 6.2 - Managing Pivot Tables Output
Section 7: Comparing Business Scenarios
Unit 7.1 - Decision Making With Compared Scenarios
Unit 7.2 - The Scenario Manager
Section 8: Looking Outside Your Data (Forecasting)
Unit 8.1 - Time Series and Forecasting
Unit 8.2 - Working With Moving Averages
Unit 8.3 - Introduction to Regression -Section 9: Ending
Unit 9.1 - Ending
PivotTable Course Section 1: PivotTables
Unit 1.1 - Introduction - Finding the Best or the Worst
Unit 1.2 - Filter and Group to Compare and Contrast
Unit 1.3 - Presentation - Clarity and Impact
Unit 1.4 - Calculations - Adding Value to Values
Unit 1.5 - Your Data Your Way - Flexible Reporting
Unit 1.6 - Power to the User - Interactivity
Section 2: PivotTables for Data Analysis
Unit 2.1 - Dominate Your Data
Unit 2.2 - PowerPivot and Big Data
Unit 2.3 - Make Your Data Work Harder
Unit 2.4 - From Data to Decisions
Unit 2.5 - Present Data Analysis with Impact

DescriptionInstructorImportant DetailsRelated Products

Manipulate Data like a Pro with 4 Courses (69 Hours of Content!) for the Business-Minded

SkillsologyWith over 500,000 users throughout the world, Skillsology has developed courses with an emphasis on high-quality training for business or pleasure, with courses in Excel, Project Management, Web-Design, Accounting and Bookkeeping, and various languages. Users work through a combination of videos, text, and practice exercises to become experts in different areas. Online tests begin and end courses to allow users to measure their proficiency, and course diagnostics are used in business courses to pinpoint areas for improvement.

For more details on Standard Microsoft Excel Course, click here.
For more details on Advanced Microsoft Excel Course, click here.
For more details on Business Analysis Course, click here.
For more details on Pivot Table Course, click here.

Description

Even the most basic understanding of Excel can make you a more efficient worker, but an advanced understanding can be your ticket to success. Learn to create, dissect, and augment data with no sweat, so you can make better-informed, smarter business decisions. With access to video tutorials and practice spreadsheets, you’ll find yourself impressing potential employers and colleagues with each pivot table and Vlookup.

Course 1: Microsoft Excel Course
- Learn about 38 core Excel units w/ instruction completable in as little as 12 hours
- Use key functions ranging from sorting & filtering to configuring graphs & charts
Course 2: Advanced Microsoft Excel Course
- Dive into advanced Excel concepts w/ 160 video tutorials, completable in 27 hours average
- Learn powerful techniques such as using complex graphs, automating spreadsheets, etc.
- Tease insights from raw data w/ the PivotTable & PowerPivot tools
Course 3: Business Analysis
- Learn business analysis techniques w/ instruction completable in 20 hours average
- Apply 60 professional spreadsheet models (included) to your business's purposes
- Collect, analyze & forecast data to generate valuable insights for your data and effectively present it to clients & stakeholders
Course 4: Pivot Table Course
- Make sense of large data sets w/ instruction completable in 10 hours average
- Filter, sort & group PivotTable data to maximize its usefulness
- Clearly present your findings w/ PivotCharts & Conditional Formatting

Specs

Details & Requirements

Length of time users can access this course: 12 months after activation
Access options: web streaming & mobile streaming
Certification of completion included (accredited by CPD UK)
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: beginner to advanced

Compatibility

Internet required
Microsoft Excel required (versions covered per course as follows):
- Microsoft Excel Course: Excel 2003 or newer (PC), Excel 2011 (Mac)
- Advanced Excel Course: Excel 2007 or newer (PC)
- Business Analysis Course: Excel 2007 or newer (PC)
- Pivot Table Course: Excel 2007 or newer (PC)

Terms

Instant digital redemption

Your Cart

Your cart is empty. Continue Shopping!

Processing order...