
During the pandemic all in-person classes are delivered live online. You can retake the course in-person at no cost once our classrooms reopen. See how live online training works in this brief video.
All classes include
Free retakes
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Microsoft Excel Class Online - Nights - May 1 2023 Introduction
Excel Class - Introduction
$249.00
In the introductory Excel class learn to become more efficient with managing, organizing, presenting and evaluating data. Discover how to navigate the user interface and quickly move into data entry and calculations including averages, sums, and counts. Find out how to use autofill and the quick access tool bar to save time. Understand how to use formatting to change appearance, the case of text, or remove certain characters. Discover ways to format text and cells automatically, such as positive cells appear green and negative in red. Explore how to create charts to visualize and summarize data. Learn to manage multiple Excel sheets as well as share documents through printing and exporting.
Introductory Excel Class Topics Covered
Topics covered in the introductory Microsoft Excel course include the following:
Getting Started with Excel
Understanding the Excel interface
Data entry using Excel
Navigating a worksheet using keyboard shortcuts
Editing in the formula bar
Using AutoFill
Naming worksheets and saving the workbook
Creating a Worksheet in Excel
Creating a worksheet
Selecting cells, ranges, collections, rows, and columns
Inserting/deleting rows and columns
Inserting, deleting, hiding, copying, and moving worksheets
Formatting in Excel
Formatting text, dates, and numbers
Changing column width and row height
Editing cell alignment
Applying borders and using shading
Using the Format Painter in Excel
Applying conditional formatting
Applying themes
Working with Formulas and Functions
Creating formulas
Using order of operations in formulas
Using functions in Excel, including SUM, AVERAGE, MAX, MIN, COUNT, and IF
Understanding cell references
Using formula auditing to edit formulas and functions