This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Skills for Business and Employment - Fundamental level
Overview of Microsoft Excel
Course Introduction (0:22)
What you will learn
Working with the Excel Environment
Ribbon, Quick Access Toolbar, Worksheet Views, Backstage View (5:33)
Creating and Opening Workbooks
Pin a Workbook, Using templates, Compatibility Mode (5:19)
Saving and Sharing Workbooks
AutoRecover, Exporting Workbooks, Sharing Workbooks (11:09)
Cell Basics
Cell Content, Fill Handle and Flash Fill (32:56)
Modifying Columns, Rows and Cells
Inserting, Deleting, Hiding and Moving / Wrapping Cells and Merging Cells (20:41)
Formatting Cells
Cell Borders, Cell Styles, Text Alignment, The Format Painter (11:28)
Understanding Number Format
Using Number Format, Percentage Format, Date Format and Number Formatting tips (5:32)
Working with Multiple Worksheets
Insert a Worksheet, Rename, Move, Delete & Change the tab colour / Grouping and Ungrouping Worksheets (9:30)
Using Find and Replace
Find Cell Content & Replace cell Content (4:16)
Page Layout and Printing
Print Area, Print Selection, Adjusting Content, Print Tiles, Modify Margins (13:14)
Introduction to Formulas
Mathematical Operators, Cell References, Fill Handle, Order of Operation & Complex Formulas (40:41)
Relative and Absolute Cell References
Relative References, Absolute References, Using Cell References with Multiple Worksheets (24:23)
Functions
Creating a Function, The Function Library, Insert Function Command (15:21)
Bonus Lesson
Profitability Sheets and Quotes (33:36)
Excel Keyboard Shortcuts
What you will learn
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock