Complete Excel Megacourse: Beginner to Expert
Learn how to use Microsoft Excel like a pro with this step-by-step course!
What you will learn
How to use Microsoft Excel and its basic functions
How to create worksheets
Everything about using and formatting cells
How to use autofill
The principles and use of formulas
How to manipulate data through different functions
How to use and master Excel’s most famous functions: AVERAGE, SUM, PRODUCT, COUNT, COUNTA, IF, COUNTIF
Simple graphs and charts
How to create a budgetary system
All the new functions in Excel 365
Description
Learn Microsoft Excel!
Have you ever wanted to be able to use Microsoft Excel - the largest spreadsheets program, like a pro? From managing your accounts to running your business’ finances, modelling chaos to simulating airports, recording your progress to planning your time; spreadsheets are an invaluable tool to learn and understand. Whether you’re looking to record your home incomings and outgoings, or want to explore Excel for its mathematical opportunities, investigate the statistical tools, and its data analysis wizards, this course is for you.
In this course, you’re going to learn everything you need to know to get started with Excel. You will explore what cells and worksheets are, how to enter formulae, manipulate data through functions and present the data in an effective fashion. You’ll even learn how to use Excel to develop diverse and interesting solutions to problems, as well as learn the individual techniques and how to apply them to a solution.
Our instructor has many years of experience teaching Excel to a wide range of audiences - from very young children through to professionals, and the expertly-crafted syllabus is designed to be easy to follow and thorough. We’ve also included plenty of practical examples explained and done on-screen for you to study. That’s why this is the only Microsoft Excel course you’ll ever need to master this software!
Start using Excel today!
Screenshots




Content
Introduction
Getting to know the Interface
Using Formulae in Excel
Protecting Cells and Worksheets
Data, Formatting and the First Function
Basic Functions in Excel
Shapes and Images
Importing Data into Excel
Averages in Excel
Using Lookups in Excel
More Functions in Excel
Functions and Conditions
Working with Dates and Text
Simple Graphs and Charts
Handling Text and Importing WWW Data
Generating Test Data
Creating a Budgetary System
Revision Exercise: Astronomical Modelling
New Functions in Excel 365
More Basic Features of Excel
Reviews
Coupons
Submit by | Date | Coupon Code | Discount | Emitted/Used | Status |
---|---|---|---|---|---|
Angelcrc Seven | 2/22/2022 | 03FFFC7360E5E70178B5 | 100% OFF | 1000/931 | expired |
Angelcrc Seven | 2/27/2022 | 5003CEAEBB41B4DCE5AF | 100% OFF | 1000/902 | expired |
- | 3/6/2022 | E11C16B6DE012C02D6A8 | 100% OFF | 1000/911 | expired |
Mauricio | 3/23/2022 | 8A1EC093822B31807191 | 100% OFF | 1000/903 | expired |
Angelcrc Seven | 4/7/2022 | A2C3B71DE90ED8DE6EA5 | 100% OFF | 1000/638 | expired |
- | 4/23/2022 | 6ED55BA063F03AD3997F | 100% OFF | 1000/956 | expired |
- | 5/12/2022 | 64DDC08EA4D5FA08A29E | 100% OFF | 1000/842 | expired |