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
Teach online with
Creating a Function, The Function Library, Insert Function Command
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock