Excel has become the most widely used spreadsheet on the market that offers users a power-house of organization, computation and analysis tools.
It can be used to organize data into rows and columns, as well as performing mathematical calculations.
In the preface of Simon Benninga book: "The Principles of Finance with Excel," it was stated that Excel is the premier business computation tool.
And this claim can be backed with the fact that, as of 2010, Excel has become the most widely used spreadsheet on the market that offers users a power-house of organization, computation and analysis tools.
In our today’s tutorial, we shall concern ourselves with the basic functions of Microsoft Excel. And these basic functions will be taught in such a way that every computer novice that is willing to know will find it easy and interesting to understand.
So without further ado, here are three Microsoft Excel tutorials filled with over thirty-seven interesting lessons.
One of the major strength of Excel is that you can perform mathematical calculations and format your data. And that is who will get to learn in this tutorial.
In addition to that, the basics of Microsoft Excel will be explained in detail. Excel window will be introduced as well as it is what you need to interact with Excel.
And in other to have a skillful understanding of the electronic spread sheet, other lessons will be taught in addition to Excel windows.
Here are the following fifteen lessons that will be taught in this tutorial.
The Microsoft Excel Window
The Microsoft Office Button
The Quick Access Toolbar
The Title Bar
The Formula Bar
The Status Bar
Move Around a Worksheet
Go To Cells Quickly
Edit a Cell
Delete a Cell Entry
Save a File
One of the most interesting things about Excel is that when you enter formulas into your Excel worksheet, the formulas can calculate automatically.
In this tutorial, you will learn how to perform basic mathematical calculations. And in addition to performing basic mathematical calculations, you will be taught how to format text and numerical data.
As a matter of fact, this tutorial can be said to be one of the most important tutorials on Microsoft Excel.
Below are the following lessons that will be taught in this tutorial:
Set the Enter Key Direction
Perform Mathematical Calculations
Perform Automatic Calculations
Align Cell Entries
Perform Advanced Mathematical Calculations
Copy, Cut, Paste, and Cell Addressing
Insert and Delete Columns and Rows
Merge and Center
Add Background Color
Change the Font, Font Size, and Font Color
Move to a New Worksheet
Bold, Italicize and Underline
Work with Long Text
Change a Column's Width
With the help of functions, many useful calculations can be quickly made with ease. Finding an average, the highest number, the lowest number, and a count of the number of items in a list are included in such calculations.
In this tutorial, you will learn not only how to create and use Excel function, you will also be taught how to fill cells and print as well.
Below are lessons that will help you get a proper understanding of this tutorial.
Using Reference Operators
Fill Cells Automatically
Create Headers and Footers
Set Print Options
ALSO READ: Best tutorials for beginners and experts