EXCEL SKILLS FOR BUSINESS AND EMPLOYMENT – FUNDAMENTAL LEVEL

10,500.00

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