Excel Training – The Basics of Microsoft Excel
How to add, subtract, multiply, divide, calculate percentages and calculate averages in Excel.
When you open Excel you’ll see a list of templates that are already designed with certain functionalities such as budgets, invoicing, planners, journals, and lists.
If you click on the header on the top you can choose from even more templates under categories for business, personal, finance, lists, and more. You can perform a search for a specific type of template and find even more templates from which you can choose.
These templates are very useful and you may find one that will accomplish your goals with little editing or formula creation of your own.
We’ll use some of these templates in later courses but in order to learn Excel in depth it may be better to start from scratch by creating a blank workbook and then enter the formulas and headings ourselves. Let’s click on the Blank Workbook to create a new Excel file.
The blank Excel document will have columns at the top starting with A and ending in XFD for a total of 16,384 columns if you are using Excel 2007 or later. Earlier versions such as Excel 2003 started with A and ended with IV for a total of 256 columns. The document will also have rows starting with 1 and ending with 1,048,476 if you are using Excel 2007 or newer or they will start with 1 and end with 65,536 if you are using Excel 2003.
Each of those columns and rows has cells which can contain numbers, text, formulas, references to other cells, or other data.
If you click your mouse button in the first cell in the worksheet you’ll see the cell name in the name box near the top right of the Excel. The first cell in the first column and the first row will be called A1 as columns are named alphabetically starting with the first letter of the alphabet, then the second, etc… and the rows are numbered numerically starting with one, then two, etc… The second cell in the second column will be named B2.
Lets start with some simple maths to learn how to enter data a formulas into cells.
**All formulas in Excel begin with the = sign
Conditional Formatting Dates in Excel A tutorial on applying conditional formatting to Excel based upon a date in the past, future or present. Applying conditional formatting on a date within Excel can make it easy to highlight payments that are past their due date or to highlight upcoming events with colors changing as the event … Continue reading Conditional Formatting Based on a Date
A Tutorial on How to Apply Conditional Formatting in Excel Conditional Formatting is one of the most useful features for making data of a certain criteria really stand out in large spreadsheets. The formatting can be based on the values in a cell – such as a number above or below a certain range – … Continue reading How to Apply Conditional Formatting in Excel
Excel Training – The Basics of Microsoft Excel How to add, subtract, multiply, divide, calculate percentages and calculate averages in Excel. When you open Excel you’ll see a list of templates that are already designed with certain functionalities such as budgets, invoicing, planners, journals, and lists. If you click on the header on the top … Continue reading Microsoft Excel Training Part 2 – The Basics of Excel
Microsoft Excel Training Part 1 – Introduction to Excel Microsoft Excel is one of the most used software programs in the world with over 750 million installations worldwide and knowledge of Excel is considered a required skill for many jobs. It is now considered the industry standard for creating spreadsheets and has desktop (PC and … Continue reading Microsoft Excel Training Part 1 – Introduction to Excel
A Tutorial on Formatting Cells in Excel How to use Cell Styles, Number Format, Font Settings and keyboard shortcuts to format cells in Excel. Cells in a Microsoft Excel spreadsheet can be formatted using tools similar to word processors with bold, italics, strikethroughs, etc, but with additional options for formatting as currency, percentages, dates, … Continue reading Formatting Cells in Excel
A tutorial on how to Calculate Percentages in Excel Calculating percentages in Excel is also easy but it requires the use of formatting options. We start with performing calculations to work out the divisions of numbers and then format the cell with the resultant figure as a percentage. The formatting of the cells is accomplished either by first … Continue reading How to Calculate Percentages in Excel
A short tutorial on how to divide in Excel. Division in Excel can be performed by clicking on a cell and typing the = sign followed by the first number or cell you wish to divide, followed by the / sign and the second number or cell you wish to divide.
A Short Tutorial on How to Multiply in Excel Multiplication in Excel can be performed by typing a formula containing the numbers you wish to multiply or by multiplying the numbers contained within cells in your spreadsheet. For the first method you can just click on any cell within a spreadsheet and type an = sign … Continue reading How to Multiply in Excel
A short tutorial on how to subtract in Microsoft Excel How to Subtract in Excel Subtractions in Excel can by accomplished by typing the = sign followed by a number or cell reference and a – sign.
How to add in Excel A Tutorial on how to add in Microsoft Excel. Numbers in Excel can be added in several ways including: Typing in the numbers and formula all at once for simple additions Adding together numbers in existing cells by typing a formula Adding numbers in cells by clicking the Insert Function (fx) button … Continue reading How to add in Excel