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

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

S
Skillsology

With 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