Microsoft Excel Level I Foundations is for users who are self-taught and typically use other’s spreadsheets to enter information. This course covers navigation and the Ribbon, entering data, selecting ranges creating simple, formulas and using simple functions, change the appearance of worksheets using the Ribbon and the Format Cells Dialogue Box, and using comments in cells.
This one-day Excel training for beginners runs from 8:30 a.m. to 4:15 p.m. as a live virtual class with an instructor. You learn to create and save workbooks, move around the Excel screen and Ribbon, select cells and ranges, and enter and edit data with AutoFill and the formula bar. The class then covers simple formulas with relative and absolute references, AutoSum and basic functions, and cutting, copying and pasting information. You also practice renaming and organizing worksheets, freezing rows and columns, formatting cells and numbers, creating tables and adding comments.
Level I Foundations suits people who taught themselves Excel or mostly enter data into spreadsheets that someone else built. It is the first course in our Microsoft Excel series and gives you the basics you need before moving on to Level II Intermediate and Level III Advanced Topics. If you are looking for Excel classes for beginners that focus on everyday office tasks, this basic Excel course is the place to start.
The course fee is $345 for 8 hours of instructor-led training. Organizations can also book this beginner Excel class as private training for a team. Use the form on this page to ask about upcoming dates or a group session.
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
