Microsoft® Excel 2016/365 Level I Foundations

Open Enrollment Course Dates:  

Click here to pre-register for this course now!

Course Length: 1 day
Delivery: Instructor Led/Group Live
Prerequisites/Advanced Preparation: None
Course Level: Basic
Course Fee: $345
Course Hours: 8:30 a.m. – 4:15 p.m.
Recommended CPE:  8 hours
PDUs:  7.5/PDHs 7.5/PDCs:  7.5


Course Outline:

Create an Excel workbook
Become familiar with the Excel screen

Use the Excel Ribbon
Contextual Tabs
Quick Access Toolbar
Shortcut menus
Changing views

Moving around your cursor
Activate a cell
Move within a selected range
Move to other sheets within a workbook

Select a Range of cells
Select a single cell
Select a range of cells
Select columns and rows
Select non-adjacent ranges
Select multiple worksheets

Entering Data Into a Worksheet
Entering text (labels)
Editing text with the formula bar
Replacing contents of cells
Using delete, undo/redo
Using AutoFill to enter data
Customize AutoFill
Use a List to enter data

Using a Simple Formula
Resizing the Formula Bar
Enter a Formula using the keyboard
Enter a cell or Range Reference using the mouse
Using AutoSum to calculate totals
Using Relative References
Using Absolute References

Using Simple Functions
Enter a function directly
Using AutoComplete to create formulas
Turn Formula Autocomplete on and off
Insert other functions using AutoSum button
Using AutoCalculate to do a calculation without a formula

Managing Worksheet Information
Move information using Cut and Paste
Drag and drop information
Copy and paste information
Using Paste options and Paste Live Preview
Copy as a picture
Insert rows/multiple rows
Insert columns/multiple columns
Insert a cell

Managing Workbook Information
Rename a Worksheet
Add a New Worksheet
Rearrange Worksheets
Copy Worksheets
Hide and Unhide Worksheets and Workbooks
Format a Worksheet Tab
Add a Sheet Background

Adjusting Rows and Columns
Adjust Rows and columns using the mouse and the Menu
Hide/Unhide rows and columns
Freeze a column or a row
Split a worksheet into panes

Formatting Cells Using Ribbons
Change the font and font properties
Align data in a cell
Indent data in a cell
Merge cells
Change numbers to percentages
Increase/decrease decimal places
Copy a format using Format Painter

Formatting Cells Using the Format Cells Dialog Box
Double Underline using the Menu option
Align cell data vertically
Change text orientation
Wrap text in a cell
Format numbers as currency
Format dates
Change the background color of a cell
Add an outline border
Draw a border using the mouse
Format a Table quickly

Using Comments
How To Add A Comment Into A Cell
How To Show/Hide Comments Permanently
How To Show/Hide Comment Indicators

Cancellation Policy: 5 working days for full refund. Cancellations after that time are charged full tuition for the course.

For more information regarding refund, concerns, and/or program cancellation policies please contact our offices at 919-878-7100 ext. 22

Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Concerns regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: