Category Archives: Basic Excel Tutorials

Tutorials on the basics of Microsoft Excel

Conditional Formatting Based on a Date

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 approaches.

Conditional Formatting Based on a Date
Conditional Formatting Based on a Date

Continue reading Conditional Formatting Based on a Date

How to Apply Conditional Formatting in Excel

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.

Conditional Formatting in Excel
Conditional Formatting in Excel

The formatting can be based on the values in a cell – such as a number above or below a certain range – or you can use conditional formatting based on another cell.

Conditional formatting can also be used to highlight dates, text or duplicate values.

To use conditional formatting just select the cells you wish to apply the formatting to and select the Conditional Formatting options from the Styles group on the Home tab of Excel.

Conditional Formatting in Styles Group
Conditional Formatting in Styles Group

Continue reading How to Apply Conditional Formatting in Excel

Microsoft Excel Training Part 2 – The Basics of 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 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.

Excel 2013 start screen with templates.
Excel 2013 start screen with templates.

Continue reading Microsoft Excel Training Part 2 – The Basics of Excel

Microsoft Excel Training Part 1 – Introduction to 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 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.

Continue reading Microsoft Excel Training Part 1 – Introduction to Excel

Formatting Cells in 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.

How to Format 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.

Continue reading Formatting Cells in Excel

How to Calculate Percentages 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 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%.

Continue reading How to Calculate Percentages in Excel

How to Multiply in Excel

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 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.

How to multiply in Excel
How to multiply in Excel

Continue reading How to Multiply in Excel

How to add in Excel

How to add in Excel

How to add in Excel manually
How to add in Excel manually
How to add in Excel using SUM
How to add in Excel using SUM

 

A Tutorial on how to add in Microsoft Excel.

Numbers in Excel can be added in several ways  including:

  1. Typing in the numbers and formula all at once for simple additions
  2. Adding together numbers in existing cells by typing a formula
  3. Adding numbers in cells by clicking the Insert Function (fx) button and clicking SUM
  4. Adding numbers in cells by clicking the Autosum function from the formulas menu.

The first method can be accomplished by clicking a Cell and typing the = sign followed by the first number you want to add followed by the + sign and the second number you want to add followed by another + sign and another number for as many numbers as you want. Example: =9+5+7.

Continue reading How to add in Excel