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.

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.

Learn about our Boston Training Center

AGI Training Boston
8 Cabot Rd
Woburn, MA
01801
USA
(781) 376-6044
Graphic Design Courses, Web Design Classes, Adobe Training, Photoshop Classes, InDesign Courses, HTML Classes, UX Classes, Creative Cloud Classes, Illustrator Classes, and Apple Training in Boston.

 


View Larger Map

All classes include

free retakes of courses Free retakes

Curriculum provided Detailed curriculum

Live instructor Live instructor

flexible rescheduling Flexible rescheduling

flexible rescheduling Certificate of Completion

Microsoft Excel Class in Boston on September 14, 2023 Introduction

Excel Class - Introduction

AGI Training Boston

$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.

Download Course Description (PDF)
See all Excel Classes

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