Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Being a pro in Microsoft Excel for Beginners using the S.I.M.P.L.E system
Welcome and Introductions
Introductions (4:16)
Day 1: Introductions and Getting Started. The basics; getting around Excel like taking a stroll in the park
1. Opening, loading, saving and closing Microsoft Excel. (7:12)
Getting Started: What all those buttons mean.....
Getting Started: Basic Excel interface, printing, saving, loading ,,,,,
Recapping Week1
Day 2: Basic formula and functions made easy so that you can start producing results
Entering basic formula and text
Types of inputs; dates. text, numbers
Formatting: making it look pretty and neat
Basic functions to edit your works; cutting and pasting
Cool tricks: Short cuts to increase your working speed
Recapping Week 2
Day 3: The fun stuff, working with more advance formulas and cool tricks to increase your productivity 10x
Referencing data with ease: The Lookups (your best friend)
More cool stuff: If functions, Sum, Sumif
Goal Seeking: Letting Excel solve your questions
Advance Formatting
Recapping week 3
Day 4: Manipulating and understanding data so you don't get overwhelm by information overload
Filters: The easiest way to sift through your data
Pivot Table: Your ultimate tool in making data easier to read
Tools to clean your dirty data and other useful functions
Recapping Week 4
Day 5: The pretty stuff; creating graphs, charts and images to supercharge your presentations
The basic charts and graphs 1
The basic charts and graphs 2
Being an artist in excel; shapes and icons
The ultimate graph challenge: Creating a waterfall chart made easy
Recapping Week 5
Day 6: Very very basic Macros (the robot within Excel)
The possibilities of Macros (VBA): What macro can do
How to create your own basic macro in 20 seconds
Recapping Week 6
Day 7: Recapping and What's next?
Other courses for advance Macro VBA that you can sign up
Pivot Table: Your ultimate tool in making data easier to read
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock