Microsoft Excel Basic User
Online Course
of
lessons completed
0%
Microsoft Excel Basic User
Collapse
Expand
-
Select Cells Effectively
- Introduction
- 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 cell
- Use the Format Painter tool to copy the format of row
- Use the Format Painter tool to copy the format of column
-
Change Workbook Structure
- Change worksheet tab colour
- Rename a worksheet
- Move a worksheet
- Copy a worksheet within a workbook
- Copy a worksheet from another workbook
- Move a worksheet 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 and the Enter tool
- 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
Apply date formatting
EXERCISE Download the file used in the video. Apply the Long Date format to the dates in column B. Delete any of the existing dates in column B and enter today’s date. Change the formatting of the dates to display the year as 2 digits. In Sheet2 select all the cells and apply the Short […]