Microsoft excel is a software developed by Microsoft
corporation which allow users to
organize, format and calculate data with formulas using a spreadsheet system
made up of rows and columns.
The following is a breakdown of the major excel lessons you
will cover when taking our excel course.
Do not let the lists scare you. The chapter
sections are actually shorter than you possibly can imagine and you will be through
with them in no time.
If you are a complete beginner, then this course is the perfect one
to start with. Remember that we are
trying to make it as easier and enjoyable as we can for you. We don’t want you
to go through the tedious process of learning
a ton of excel theory. The lesson will be almost entirely a practical
one to enhance a swift a easier
understanding of this course.
CHAPTER ONE – Introduction to excel
1.
Introduction to excel 2007 and 2010
2.
Excel rows and columns
3.
Entering text and number in a cell
4.
How to edit text in a cell
5.
How to center text and numbers
6.
Font formatting in excel 200/2010
7.
How to change the color of a cell
8.
Saving your work in excel
9.
Currency symbols in excel 200/2010
10.
How to merge cells
CHAPTER TWO- Complex spreadsheets
1.
Introduction
2.
How to use auto fill in excel 200/2010
3.
Entering simple addition formula
4.
The SUM function in excel
5.
Copy and paste
6.
How o use Paste Special
7.
How to multiply in Excel 2007/2010
8.
How to add comment to a cell
CHAPTER THREE- Excel 2007/2010 Charts
1.
How to sort data in excel
2.
Create an excel chart
3.
Move and resize your chart C\
4.
Chart styles and layouts
5.
Chart t titles and series titles
6.
Chart layout panel in excel 2007/2010
7.
The Format Chart Panel
8.
Create a pie chart in Excel
9.
Add
Labels to a Pie Chart
10.
Format Pie Chart Segments
11.
Create a 2D Line Chart in Excel
12.
Format
your Axis Titles
13.
Predict
the future with a Trendline Chart
14.
Sparkline
Charts
CHAPTER FOUR - Formulas in Excel 2007/2010
1.
The SUM
Function
2.
How to
Multiply in Excel
3.
Subtract and Divide
4.
Combining
the Arithmetic Operators
5.
A Budget
Spreadsheet
CHAPTER FIVE -
Functions in Excel 2007/2010
1.
The
Average Function
2.
The Date
Function
3.
Time
Functions in Excel
4.
A
TimeTable Project
5.
Financial
Functions
6.
The
Student Averages Project
CHAPTER SIX- Conditional Logic in Excel
1.
The IF
Function
2.
Conditional Formatting in Excel 2007/2010
3.
CountIF
4.
SumIF
CHAPTER SEVEN- Processing
Data in Excel
1.
Data
Tables in Excel 2007/2010
2.
A Second
Data Table
3.
Excel
Scenarios
4.
Goal Seek
5.
Absolute Cell References
6.
Named
Ranges in Excel 2007/2010
7.
Create a
Custom Name in Excel
8.
Excel
Pivot Tables
9.
Pivot Tables, Part Two
10.
Reference
other Worksheets
11.
The LOOKUP Function
12.
The
VLOOKUP Function in Excel
13.
Create a
Business Invoice, Part One
14.
Excel Business Invoice, Part Two
15.
Business
Invoice, Part Three
CHAPTER EIGHT- Advanced Excel 2007/2010
1.
How to Create an Excel Template
2.
Data
Forms in Excel 2007/2010
3.
Drop Down
Lists in Excel
4.
Add your
own Error Messages
5.
Excel and
Web Integration
6.
Hyperlinks in Excel
7.
Object
Linking and Embedding
8.
Insert
Drawing Objects
For more information about this course or
any other courses we may be offering, kindly visit our contact page and shoot
as an email or call.
Welcome all
Recent Comments