The Complete Excel Productivity Bundle

Course

Online

Price on request

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Microsoft Excel is the industry standard in spreadsheet tools – part of the Microsoft Office Suite, it’s used by top analysts and professionals across a wide range of industries. Whether you want to work on Windows, macOS, Android or iOS, Excel will allow you to develop valuable insights by storing, organizing, and manipulating your data with ease.

With The Complete Excel Productivity Bundle, you’ll transform Excel from a basic spreadsheet app into a dynamic and powerful analytics tool. From mastering the application’s most useful and powerful functions to conducting sophisticated analyses, you’ll be able to increase your productivity and save yourself time and effort.

You’ll learn through a hands-on, project-based approach – working with real datasets that will help to cement your knowledge.

 

You will master:

Excel’s basic features
Working with large quantities of data
Basic to advanced mathematical operations
Logic, formulas, and functions
Statistical analyses
Visualizing data on charts and tables

 

Curriculum

Level 1: Intro to Excel

Menus & shortcuts
Sorting & filtering
Basic formulas
Spreadsheet organization

Level 2: Productivity Basics

Conditional formatting
Referencing cell data
Looking up & indexing data
Matching data

Level 3: Data Management

Validation & error handling
Flash fill
Statistical formulas
Advanced text functions

Level 4: Data Visualization

Charts & trends
Interactive visualizations
Table styling
Formulas & slicers

Level 5: Pivot Tables

Aggregating data
Data summarizing
Custom fields

 

100% Beginner-Friendly

This curriculum gives you all the knowledge needed to work with Excel – featuring introductory modules for those who have never used Excel before, to intermediate and advanced courses that will allow more experienced Excel users to further develop their existing skills, this bundle will provide you with everything you need to manage and report your data like a pro.

 

Why Learn Excel?
y...

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

b
Why should I learn programming?
b
What will I achieve by taking these courses?
b
Technology changes quickly. What happens if the content becomes outdated?
b
I’m an absolute beginner who’s never coded before. Can I still do these courses?
b
What time commitment is needed?
b
Will these courses help me to change my career?
b
Can I watch the videos offline?

This curriculum is suitable for complete beginners with no prior Excel experience.
You must have Microsoft Excel installed on your computer.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 2 years

Subjects

  • Excel
  • Spreadsheet
  • Logic
  • MS Excel

Course programme

Course #1

Intro to Excel


Course #2

Manage Large Excel Spreadsheets


Course #3

Discover Excel Formulas


Course #4

Excel Logic Functions for Beginners


Course #5

Explore Conditional Excel Formatting


Course #6

Lookup Functions for Excel


Course #7

Intro to Excel Data Tools and Data Management


Course #8

Statistical Formulas for Excel Data Analysis


Course #9

Working with Excel Text Functions


Course #10

Visualize Data with Excel Charts


Course #11

Excel Tables for Beginners


Course #12

Craft Excel Pivot Tables for Data Reporting


Additional information

On-demand, 24/7 access 11 hours of video Certificate of completion Source code and PDF notes Closed captions

The Complete Excel Productivity Bundle

Price on request