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
Learning Microsoft word is inevitably crucial if you are looking to improve your computer skills tremendously.
Microsoft word is basically a word processing software package
that enables you to type and print documents such as letters, reports and so on.
Ok, so you have decided to learn computer? Well you like it
or you don’t, Microsoft word is one of
the of the first packages you will have
to learn if you are a complete beginner which in this case I presume you are
Where to learn
You could learn from anywhere, anytime and anyhow you want. Other people would prefer to teach themselves using readily available resources like text books or simply go online and look for innumerable resources which, trust me could be overwhelming and disappointingly confusing. Crazy huh?
So what is the best way to learn Microsoft Word? It is as
simple as you would have guessed- find a tutor.
That is exactly what we do at Mersa Comptech centre. We will show you the easiest and fun way to
learn Ms Word within the shortest time possible.
What you will learn
At MersaComptech Centre you will be exposed to a wide
variety of lessons on Ms Word. We will break them down so as to make your
learning struggle free and also to enhance understanding in a unique way.
Basically to grasp the concept of Ms Word, you will learn the
following;
Lesson one
1. Introduction to Microsoft word
Under introduction we will majorly focus on familiarizing you
with the whole idea of Ms Word, what it is, its features, why you should learn it
and its application in the real world.
2. Introduction to the Ms word title bar
3. Microsoft word tool bars
4. The ruler
5. Document view
6. Text area
7. Exiting Ms Word
Lesson two
In lesson two, we get to introduce you to the basics
concepts that you need to know in order to get started with Ms word. This lesson will cover:
·
Clicking
·
Options
·
Highlighting
text
·
Highlighting
menu items
·
Placing
the cursor
·
Menu
commands using the alt Key
·
Shortcut
notations
·
Starting a
new paragraph
·
Exiting
Microsoft word
Lesson three
After the first two lessons you will now be ready to create
a real Word document. Under this lesson you will learn the following :
·
Typing and
using the backspace key
·
Using the
delete key
·
Inserting text
·
Overtyping
·
Boding,
underlining and italicizing
·
Saving
your document
Lesson four
In lesson four we will introduce you to the basic features
you will need to work more efficiently and probably make your documents look more
attractive. You will learn how to do the
following:
·
Open file
·
Cut and
paste
·
Auto text
·
Spell
check
·
Find and
replace text
·
Font
sizing
·
Fonts
·
Save file
Lesson five
In this lesson, we will take a step further and show you how
to work with paragraphs. That is formatting paragraphs. You will come across the following basics:
·
Line
spacing
·
First line
indent
·
Indentation
·
Alignment
·
Hanging
Indent
Lesson six
This lesson will be mainly crucial
to get you started with such basics as numbering your document , that is if you
are working with lists. So you will get to know the following:
·
The tab
Key
·
Bullets
and numbering
·
Undo and
redo
·
Saving
file
·
Closing
file
·
Opening a new file
·
Printing
Lesson seven
Now you are ready to start working
with tables and that is exactly what you will encounter in this lesson. Tables
will help you organize your data into rows and columns. So you will learn the following:
·
Creating a
table
·
Moving
around a table
·
Entering
text into a table
·
Selecting
a row and bolding text in a table
·
Right
aligning text in a table
·
Adding a
new row at the end of the table or within the table
·
Resizing
the columns
·
Adding new
columns
·
Sorting a
table
·
Deleting
columns or rows
·
Working with
the sum function
·
Recalculating
·
Merging
Cells
·
Inserting
table headings
·
Converting
text to a table
·
Splitting
a table
·
Table auto
format
Yeah I know this may seem like
whole lot of information to learn, but trust me, they are not. If you are ready
to get learning, you will be done with these lessons before you know. So don’t worry
we will make the learning process as easy as possible for you.
Visit as today and let’s get you
learning Microsoft Word.
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