Skip to content

Microsoft Excel Bundle - The Leading Global Excel Training Platform

Skillsology

Summary

Price
£176 inc VAT
Or £58.67/mo. for 3 months...
Study method
Online
Duration
12 months · Self-paced
Qualification
No formal qualification
CPD
67 CPD hours / points
CPD What's this?

Overview

Microsoft Excel is an essential part of modern business. Unlock it's secrets and become master of the spreadsheet with the Ultimate Excel Bundle.

This bundle covers nearly everything you will need to know in Excel. It's perfect for beginners all the way through to data and financial analysts interested in solving complex business problems.

The Ultimate Excel Bundle includes all Skillsology Microsoft Excel courses. Get to grips with the basics of Excel before moving to more complex formulas, Macros and super functions. Learn data analysis, forecasting and modelling techniques through the Business Analysis and Pivot Table courses.

About us:

Skillsology 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 personalised 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.

CPD

67 CPD hours / points
Accredited by The CPD Certification Service

Course media

Description

Microsoft Excel:

Cut Excel down to size with our personalised online course. Whether you are a beginner or have been using Excel for years you can take your spreadsheeting skills to the next level with Skillsology.

Our syllabus is uniquely refined using Filtered technology. According to your preferences, we distil the syllabus, ensuring that you learn only the most useful elements of Excel. With hours of material available, you can work on functions, graphs, PivotTables, macros and many more subjects.

In this course you will learn:

  • Unlock the secrets of Excel and learn:
  • How Excel works, how to navigate and design a spreadsheet.
  • The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF.
  • To use PivotTables, Pivot Charts and basic Macros.
  • To create beautiful looking graphs and charts.
  • Formatting, including; conditional, cell and number formatting.
  • How to print what you actually want.

Advanced Excel:

Unlock Excel's most advanced features. Ever wanted to use Macros or VBA to speed up monotonous tasks? Or analyse huge datasets straight from a database through PowerPivots? With 160 videos and loads of practice exercises you will be able to use the most hard to grasp Excel functions in no time.

In this course you will learn:

  • To use advanced graphs and presentation techniques
  • How macros and VBA automate your spreadsheets and increase interactivity
  • How superpower functions can solve complex problems
  • To use PivotTables and PowerPivots to turn raw data into clear information that supports key decisions

Business Analysis:

Learn to collect, analyse and forecast business and financial data to generate valuable insights from business data. The course will also teach you how to report on business data and present information and analysis to clients and stakeholders.

In this course you will learn:

  • How to turn buckets of data into sound business decisions
  • Financial modelling theory
  • Essential Excel analysis techniques such as Dynamic Ranges, PivotTables and Advanced Charts
  • How to effectively and clearly present your findings to relevant stakeholders
  • Different forecasting techniques, including Moving Averages and Regression

PivotTable Course:

One the most powerful aspects of Microsoft Excel is its ability to analyse and present data quickly and easily using PivotTables. Your data analysis will never be the same after unlocking the full power of PivotTables.

In this course you will learn:

  • The primary uses of PivotTables
  • How to identify the best and worst data sets
  • To filter, sort and group PivotTable data to maximise it's usefulness
  • How to present your data clearly using PivotCharts and Conditional Formatting
  • To create great looking management reports using a PivotTable

Who is this course for?

Beginner to Advanced levels of Excel User

Requirements

Microsoft Excel (PC: 2007, 2010 and 2013)

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Online courses