A tutorial on using Conditional Formatting Formulas in Excel.
There are significant limitations with the preconfigured options for Conditional Formatting. They typically only apply so a single cell without consideration for multiple factors. For example, in a previous tutorial I showed how to highlight a cell for an overdue payment based upon the date that it was due and the date that you specify for comparison. That formatting remains even after the payment has been made.
In order to correct that problem we need to use statements to examine the contents of other cells.
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.
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 Mac), mobile and cloud versions of the program.
Excel is used for everything from personal and company financial data, stock market analysis, storage of names and addresses and student grades, to advanced statistics and scientific work.
Within my own office I use Excel primarily for budgets and for calculating the landed cost of goods and final sales prices after mark-ups.
Some of my clients use Excel as their primary accounting system in lieu of software programs such as Intuit QuickBooks.
During this course we’ll go through all of the basics including formatting, formulas, charts and graphs, and then move onto more advanced topics such as macro programming and Pivot Tables in later lessons.
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, times, zip codes, phones numbers and more.
All formatting options are easily found on the Home tab of Excel or by right-clicking a cell and choosing the Format Cells option.
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 clicking on the cell you wish to format with your left mouse button then clicking on the % icon found on the Number Format group of the Home tab of Excel or by clicking on the cell with your right mouse button and choosing the Format Cells option and clicking percentage.
If you enter the formula =9/5 and hit the enter key you’ll get 1.8 and if you format 1.8 as a percentage it becomes 180%.
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.
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 followed by a number you wish to multiply followed by an * sign and then hit the enter key on your keyboard or click the check mark √ on the formula bar.