Shortest Microsoft Excel Training
Tutorial Video's EVER!
COURSE DESCRIPTION
This
course has the shortest and
simplest tutorial video’s you will ever see! Clear, concise and to the
point.
I’ll teach you:
·Opening and Closing Excel
·Navigation
·Building your first table
·Formula's, Functions and
Calculations
·Formula Auditing
·Autosum Functions
·Count Functions
·Sheets
·Freeze Paning
COMING SOON!!!
·Inserting Your Line Graph
·Inserting Your Pie Graph
·Printing
·Emailing
·The Quick Access Toolbar
·Adding New Windows
·If Functions
·Using Images
·Table Cleansing and
Presentation'
·Conditional Formattinhg
·Table Import/Export to
other Microsoft Suite Products
·Workbook Protection
Methods
·SmartArt
·Number and Cell Formatting
·Format Painter (Cool Tips
and Tricks)
·Absolute Referencing
·Sort and Filter Techniques
·Vlookup, Hlookup
·Indexing
·Pivot Tables
·Productivity Secrets, Tips
and Tricks
·Template/Calculator
Building Techniques
·Form Design
·Macro Basics
·File Sharing
·PowerPivot
·Data Mapping and Cleansing
·Matrices
·
What
are the requirements?
o Paper
and pen to take notes
o Microsoft
Excel 2007 or later
o Access
to a computer
o Access
to the internet
o No
prior Excel knowledge required
·
What
am I going to get from this course?
o Over
67 lectures and 2 hours of content!
o Opening
and Closing Excel
o Navigation
o Building
your first table
o Formula's,
Functions and Calculations
o Formula
Auditing
o Autosum
Functions
o Count
Functions
o Sheets
o Freeze
Paning
o COMING
SOON!!!
o Inserting
Your Line Graph
o Inserting
Your Pie Graph
o Printing
o Emailing
o The
Quick Access Toolbar
o Adding
New Windows
o If
Functions
o Using
Images
o Table
Cleansing and Presentation'
o Conditional
Formatting
o Table
Import/Export to other Microsoft Suite Products
o Workbook
Protection Methods
o SmartArt
o Number
and Cell Formatting
o Format
Painter (Cool Tips and Tricks)
o Absolute
Referencing
o Sort
and Filter Techniques
o Vlookup,
Hlookup
o Indexing
o Pivot
Tables
o Productivity
Secrets, Tips and Tricks
o Template/Calculator
Building Techniques
o Form
Design
o Macro
Basics
o File
Sharing
o PowerPivot
o Data
Mapping and Cleansing
o Matrices
·
What
is the target audience?
o This
course has been designed for the absolute beginner. Never touched Microsoft
Excel before? Then you’ve found the right place.
o If
you’re intermediate or expert and want to freshen up on the fundamentals, no
problem, come on in!!
o People
from any country
o People
of all ages
o If
you're only going to take a small part of the course, then this is not for you.
To experience the full effect, you must take the full course
·
SECTION 1:
Introduction
·
1
Microsoft Excel - Demonstration
02:21
Here's a quick demonstration of what Microsoft Excel can do. Now
again this is a very basic demonstration as the things you can do with Excel
are basically limitless! This is simply to get your feet wet!
·
2
Course Structure Introduction
01:03
I designed this course to be EXTREMELY to the point. Each video
tutorial teaches one thing at a time and does it in 2 minutes or less. No more
lengthy explanations or unnecessary chatter!!
·
3
All My Courses!
Text
·
SECTION 2:
Opening Excel for the first time
·
4
How to open Excel
00:42
·
5
How to save Excel
01:06
·
6
How to close Excel
01:07
·
7
How to open file from within Excel
01:01
·
SECTION 3:
Navigation
·
8
Scrolling - Left/right and Up/down
01:10
·
9
Zooming
01:31
·
10
Window Resizing
02:02
·
SECTION 4:
Building your first table
·
11
Data Input
01:34
·
12
Random Number Creation - Randbetween()
02:39
·
13
Your First Arithmetic Formula
(Introduction)
01:55
·
14
Deleting Cell Contents
01:02
·
15
Fill Handle
02:36
·
16
Copying and Pasting Values
02:06
·
17
Font Type and Size
01:56
·
18
For each review your helping another
student!
Text
·
19
Borders
01:15
·
20
Centre Alignment
01:17
·
21
Applying Bold, Italic and Underline
Formatting
01:55
·
22
Applying a Cell Colour
01:42
·
23
Applying a Text Colour
01:10
·
24
Merged Cells
02:00
·
25
Wrap Text
02:05
·
26
Cut, Copy and Paste (In detail)
02:18
·
27
Inserting Rows and Columns
02:05
·
28
Deleting Rows and Columns
01:20
·
SECTION 5:
Formula's, Functions and
Calculations
·
29
Manual Calculations
02:03
·
30
Addition
02:34
·
31
Subtraction
01:17
·
32
Multiplication and Division
02:18
·
33
Setting Decimal Places
01:48
·
34
Nested Formula's
01:49
·
35
Does This Cell Equal To That Cell
(TRUE/FALSE)
02:18
·
36
Linking Cells
02:08
·
SECTION 6:
Formula Auditing
·
37
Tracing Formula's
02:43
·
38
Show Formula's
02:49
·
SECTION 7:
Autosum Functions
·
39
Autosum Functions Explained
01:37
·
40
Autosum - SUM()
02:14
·
41
Autosum - AVERAGE()
01:59
·
42
Autosum - COUNT()
01:33
·
43
Autosum - MAX() and MIN()
01:50
·
44
Using the Function Library
02:22
·
SECTION 8:
Count Functions
·
45
Count
01:41
·
46
CountA
01:22
·
47
CountBlank
00:57
·
48
CountIf
01:43
·
49
CountIfs
02:06
·
50
Want to Learn EVEN MORE????
Text
·
SECTION 9:
Using Sheets
·
51
What Are Sheets
01:58
·
52
Adding a New Sheet
01:48
·
53
Deleting A sheet
01:33
·
54
Renaming A sheet
01:31
·
55
Changing the tab colour
02:20
·
56
Reordering sheets
02:18
·
57
Copying a sheet
03:23
·
58
Hiding and Unhiding a sheet Explained
02:09
·
59
Hiding and Unhiding a sheet
01:33
·
SECTION 10:
Freeze Panes
·
60
Freeze Panes Explained
01:49
·
61
Slider divider to freeze panes
02:36
·
62
Freezing the top row
01:05
·
63
Freezing the First Column
01:04
·
64
Horizontal Freeze Pane
01:17
·
65
Vertical Freeze Pane
01:24
·
66
Horizontal and Vertical
02:04
·
SECTION 11:
Even More Lectures to Come!!!!!
·
67
MORE LECTURES TO COME!!!!!
