Description
Microsoft Excel is a spreadsheet program that allows you to organize, store and analyze information. Anyone can learn how to take advantage of the program’s powerful features and also process complicated data. Whether you’re keeping track of expenses, budget, organizing a training, inputting data or creating an invoice, Excel makes it easy to work with different types of data.
The procedures in this manual will work for all recent versions of Microsoft Excel, including Excel 2019, Excel 2016, Excel 2013 and Office 365. There may be some slight differences, but for the most part these versions are similar.
FUNDAMENTAL MICROSOFT EXCEL TRAINING CURRICULUM
UNIT 1: WORKING WITH THE EXCEL ENVIRONMENT
A. The Ribbon
B. The Quick Access Toolbar
C. Worksheet views
D. Backstage view
UNIT 2: CREATING AND OPENING WORKBOOKS
A. To Pin a workbook
B. Using templates
C. Compatibility Mode
UNIT 3: SAVING AND SHARING WORKBOOKS
A. AutoRecover
B. Exporting workbooks
C. Sharing workbooks
UNIT 4: CELL BASICS
A. Cell content
B. To use the fill handle
C. To use Flash Fill
UNIT 5: MODIFYING COLUMNS, ROWS AND CELLS
A. Inserting, deleting, moving, and hiding
B. Wrapping text and merging cells
UNIT 6: FORMATTING CELLS
A. Cell borders and fill Colours
B. Cell styles
C. Text alignment
D. The Format Painter
UNIT 7: UNDERSTANDING NUMBER FORMAT
A. Applying number formats
B. Using number formats correctly
C. Percentage formats
D. Date formats
E. Number formatting tips
UNIT 8: WORKING WITH MULTIPLE WORKSHEETS
A. To insert a new worksheet
B. To rename a worksheet
C. To move a worksheet
D. To change the worksheet tab Colour
E. To delete a worksheet
F. Grouping and ungrouping worksheets
UNIT 9: USING FIND & REPLACE
A. To find cell content
B. To replace cell content
UNIT 10: PAGE LAYOUT AND PRINTING
A. Choosing a print area
B. To print a selection
C. Adjusting content
D. To include Print Titles
E. To modify margins in the Preview pane
UNIT 11: INTRODUCTION TO FORMULAS
A. Mathematical operators
B. Understanding cell references
C. Modifying values with cell references
D. Copying formulas with the fill handle
E. The order of operations
F. Creating complex formulas
UNIT 12: RELATIVE AND ABSOLUTE CELL REFERENCES
A. Relative references
B. Absolute references
C. Using cell references with multiple worksheets
UNIT 13: FUNCTIONS
A. Creating a function
B. The Function Library
C. The Insert Function command
BONUS
Profitability sheets and Quotes
EXCEL KEYBOARD SHORTCUTS