access
12 Months
content
69 Hours
enrolled
5,819
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
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.
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
Course Outline
- 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
access
12 Months
content
69 Hours
enrolled
5,819