Microsoft Excel Basic Lessons

 


 

Select Cells Effectively

Select a cell
Select a range of cells
Select multiple columns
Select multiple rows
Select non-adjacent cells / columns / rows
Select all cells in a sheet

Format Cells and Ranges

Change the width of multiple columns
Change the height of multiple rows
Change the height of all rows
Change the width of all columns
Use horizontal and vertical alignment tools
Modify cell indentation
Change text orientation
Wrap text within cells
Merge cells
Increase / decrease decimals
Apply number formatting
Apply currency formatting
Apply date formatting
Apply text formatting
Use the Format Painter tool to copy the format of a cell
Use the Format Painter tool to copy the format of a row
Use the Format Painter tool to copy the format of a column

Change Workbook Structure

Change sheet tab colour
Rename a sheet
Move a sheet
Copy a sheet within a workbook
Copy a sheet from another workbook
Move a sheet from another workbook

Insert Data in Cells and Ranges

Insert and delete rows
Insert and delete columns
Use the Insert Cells tool to insert a cell
Use the Delete Cells tool to delete a cell
Find data within a workbook
Replace data within a workbook
Insert / edit / remove a website hyperlink
Insert / edit / remove a note
Insert / edit / remove a comment

Copy, Cut and Paste Data

Copy and paste a cell
Copy selected text and paste into a cell
Copy and paste a cell to a range of cells
Copy and paste a range of cells
Copy and paste between sheets
Copy and paste between workbooks
Use the paste options tool to keep source column widths
Cut and paste a cell
Cut and paste a range of cells
Cut and paste a row
Use the mouse to move cells
Use the clipboard

Use the Fill Handle to Enter Data

Use the Fill Handle to copy a cell
Use the Fill Handle to copy a range of cells
Use the Fill Handle to copy a row
Use the Fill Handle to fill days of the week or months
Use the Fill Handle to insert a series of numbers
Use the Fill Handle to insert fixed text and a variable number

Work with Basic Calculations

Use the Status Bar
Use the Sum tool to add a range of cells
Use the Cancel tool / Enter tool
Use the Enter tool within the formula bar
Add a cell to another cell
Subtract a cell from another cell
Use date cells in a formula
Multiply a cell by another cell
Multiply a cell by a percentage
Divide a cell by another cell
Divide a cell by a number
Use the Fill Handle to copy a formula

Summarize and Organize Data

Sort data by a column
Filter data using text / a number / a date
Convert data to a table
Apply conditional formatting to highlight cells

Configure Worksheets and Workbooks for Distribution

Save a workbook as a PDF
Print a selection
Print specific pages
Print specific sheets
Use scaling options to fit data on a page
Print gridlines
Change orientation
Change margins
Insert a text header / text footer
Insert page numbering in a header or footer
Insert a file path in a header or footer
Insert a logo in a header or footer