Excel Tutorial Format the Spreadsheet

These two excel tutorials explain how to format or customize the fonts and cell backgrounds in MS excel to add a professional look to your spreadsheets and make certain data stand out.

In the first excel tutorial video discover how to modify text and add colours to your spreadsheet. It answers the following questions:

How do I centre a title and merge it across several cells in excel?
How do I make a text in a cell display on two lines in excel?
How do I change text or font size and text color in excel?
How do I place currency symbols before numbers in excel and choose how many decimal places, if any, for displaying money amounts?
How do I re-apply a format in excel by copying from a current cell and pasting using the format painter?
How do I color cell backgrounds in excel?
How do I “float” the cell colour box in excel so I can experiment more easily?

This is the second excel tutorial video about format – on changing text colour and border styles. It also introduces print preview and conditional formatting. It answers the questions:

How do I change font colors in excel and should I?
How do I  “float”  the font colour box so I can experiment?
How do I undo my changes in excel?
How do I get the grid lines in excel to display over the top of a cell background color?
How do I make borders appear around excel cells?
How do I indicate that a cell is “redundant” or empty by design?
How do I make grid lines print, or not print, in excel?
How do I use auto conditional formatting in excel?
How do I make excel highlight a cell automatically? For example when a cell number is greater or lesser than a value.

Excel Tutorial

Basic Enter and Edit Data

This excel tutorial is the basics of entering data, editing data, changing column widths and Autofill.

This excel tutorial video answers the questions:

How do I add a title row or label for my spreadsheet?

How do I use keyboard commands for moving around a spreadsheet and editing cell data?

How do I adjust column widths?

How to and why should I constantly save in Excel?

Which key moves you across a row or down a column?

Excel Tutorial 1

Create Basic Calculation Formulas

This excel tutorial  introduces add, subtract, multiply and divide calculations and explains the basic mathematical operators in Microsoft Excel and how to write the calculation formulas the smart way.

This Excel Tutorial Video Answers the Questions:

Which keyboard keys mean add, subtract, multiply and divide on the numerical keyboard and where do I find them on a laptop?

How do I easily add, subtract, multiply and divide on a row?

How do I use the auto “smart” features of Excel to create calculation formulas, rather than writing them in the top bar?

Where do I place the cursor and how do I confirm or enter where the result will appear while creating the formula?

How do I add up a column using autosum?

How do I use the auto “smart” features of Excel to copy a formula from one cell to repeat a calculation correctly for a different cell?