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
Tools to clean your dirty data and other useful functions
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock