The Complete Excel Productivity Bundle
Course
Online
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
Start date
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.
Reviews
This centre's achievements
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
The Complete Excel Productivity Bundle