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
At Mersa Comptech Center, we are invariably striving to give our students the best computer training ever and have in the process, been able to earn a positive reputation from Most Employers-reason enough to train with us.
What we offer
We are currently offering various computer packages we which consider most crucial for both basic understanding of computer and later a deep dive into more advanced training.The computer packages being offered at the moment include:
- Introduction to computers
- Microsoft Word
- Microsoft Excel
- Microsoft Access
- Microsoft Powerpoint
- Desktop Publishing
- Introduction to the internet
- Databases
- Spreadsheets
- Keyboarding
- Graphic Editing
- Web Design
Why you should train with Us
If you are looking for a more personal than the usually tedious and devastating training you would get in school, then Mersa Comptech Center should be your first and probably only option. We will guide you every step of your training seeing to it that you grasp every important detail of the training.We have the best tutors you can find anywhere else with long term experience in the computer field.
They are always on the alert, guiding you step by step until you complete your training.
Our resources are also the best. We have every single material that we consider vital to design a computer guru out of a complete beginner. Both soft copies and hard copies.
Are Our certificates valid?
In case you didn't know, Mersa Comptech Center is a registered enterprise and have been in operation for the past 7 years. People who trained with us in the past have gone a long way to curve themselves luxurious IT niches and are comfortably making a decent living.Our main goal is to give the best computer training ever and also ensure that you get your certificate when you are fully baked and ready to face the job market. WE DO NOT TOLERATE HALF BAKING!!
Well now you know that Mersa Comptech Center is the place to go for top-notch computer training and you also already know that our certificates are among those being looked for by most employers.
So what? You Start now and get your certificate within the shortest time possible.
For More information kindly reach us through the following contacts;
Mobile-0702774400
-0715999977
-0700190063
-0711152204
-020-2347130
Welcome and experience the best computer training ever!!
Recent Comments