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
Use date cells in a formula
EXERCISE Download the file used in the video. In Sheet1 insert a formula to calculate each No of Days as shown in the video (ie End Date – Start Date). In Sheet2 insert a formula to calculate each Payment Due Date as shown in the video (ie Invoice Date + 30). In Sheet3 insert a formula to […]