Ultimate All-Level Excel Bootcamp
Ultimate All-Level Excel Bootcamp
Ultimate All-Level Excel Bootcamp
Ultimate All-Level Excel Bootcamp
Ultimate All-Level Excel Bootcamp
Ultimate All-Level Excel Bootcamp, item 1 of 5
Ultimate All-Level Excel Bootcamp, item 2 of 5
Ultimate All-Level Excel Bootcamp, item 3 of 5
Ultimate All-Level Excel Bootcamp, item 4 of 5
Ultimate All-Level Excel Bootcamp, item 5 of 5

Ultimate All-Level Excel Bootcamp

5819 Enrolled
69 Hours
Deal Price$35.00
Suggested Price
$249.00
You save 85%
🔥 5,000+ Sold! Selling Fast
Ultimate All-Level Excel Bootcamp
$35.00$249.0085% OFF
Ultimate Excel Bundle
Ultimate Excel Bundle
Ultimate Excel Bundle
Ultimate Excel Bundle
Ultimate Excel Bundle
Ultimate Excel Bundle, item 1 of 5
Ultimate Excel Bundle, item 2 of 5
Ultimate Excel Bundle, item 3 of 5
Ultimate Excel Bundle, item 4 of 5
Ultimate Excel Bundle, item 5 of 5

87 Lessons (69h)

  • Unit 1.1 - Excel Introduction
    Unit 1.2 - The Excel Interface
    Unit 1.3 - Basic Navigation and Editing
    Unit 1.4 - Getting Going
  • 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
  • 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
  • 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
  • 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
  • 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
  • Unit 1.1 - Templates
    Unit 1.2 - Efficiency and Risk
    Unit 1.3 - Data Validation
  • 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
  • Unit 3.1 - Form Controls
    Unit 3.2 - Visual Basic and Macros
  • 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
  • Unit 5.1 - Advanced Uses of PivotTables
    Unit 5.2 - PowerPivot
    Unit 5.3 - Reporting with PowerPivot
  • Unit 1.1 - Turning Numbers into Better Business Decisions
  • Unit 2.1 - Essential Excel for Business Analysis
    Unit 2.2 - Professional Tools for Business Analysts
  • Unit 3.1 - Importing and Exporting Data
    Unit 3.2 - Power Functions for Managing Business Data
  • Unit 4.1 - Your Stakeholders and Their Needs
    Unit 4.2 - Data Presentation Formats That Work
  • Unit 5.1 - Professional Charting
    Unit 5.2 - Dynamic Charts
    Unit 5.3 - Some Special Charts for Business Analysis
  • Unit 6.1 - Analysing Data With Pivot Tables
    Unit 6.2 - Managing Pivot Tables Output
  • Unit 7.1 - Decision Making With Compared Scenarios
    Unit 7.2 - The Scenario Manager
  • 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
  • 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
  • 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
Ultimate All-Level Excel Bootcamp
$35.00$249.0085% OFF
View similar items

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

S
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
Processing order...