Excel Course in Boston on September 13, 2024 Introduction

Introductory Excel class - complete topics covered:

Topics covered in the introductory Microsoft Excel course include the following:

Getting started with Excel

Understand various ways of entering data in Excel. Find out how to use multiple worksheets in Excel, and learn to organize data by creating, moving, copying, and managing Excel worksheets. Find out how to work more efficiently by using repeat actions in Excel to duplicate prior actions quickly. Find out how to save time using Excel Shortcuts as you discover keyboard shortcuts that save time and help you to work more efficiently.

Getting to know the workspace

• Understanding the Excel interface
• Data entry using Excel
• Moving around a worksheet using keyboard shortcuts
• Editing in the formula bar
• Using AutoFill
• Naming worksheets and saving the workbook

Creating a worksheet in Excel

Understand various ways of entering data in Excel and printing from Excel as you learn how to easily print or convert Excel content to PDF. Find out how to use multiple worksheets in Excel, and learn to organize data by creating, moving, copying, and managing Excel worksheets. Find out how to work more efficiently by using repeat actions in Excel to quickly duplicate prior actions. Find out how to save time using Excel Shortcuts as you discover keyboard shortcuts that save time and help you to work more efficiently.

• 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

Learn about formatting Excel sheets and content. Learn to visually distinguish specific text and numbers by applying formatting. Learn how to use the Format Painter in Excel: Learn to duplicate formatting from any cell and apply it to others. Applying Conditional Formatting: Discover how to apply formatting depending upon rules relating to content.

• Formatting text, dates, and numbers
• Changing column width and row height
• Editing cell alignment
• Using cell styles
• Applying borders and using shading
• Using the Format Painter in Excel
• Applying conditional formatting
• Applying themes
• Using text functions
• Creating and using templates

Working with charts

Learn to create line charts and sparklines to represent data visually. Find out about various chart types, including creating Column Charts using Excel as you learn to create column charts for data visualization. Discover how to create pie charts, bar charts, and line graphs for data visualization.

• Understanding chart types
• Creating charts in Excel
• Customizing charts
• Printing a chart from a chart sheet or a sheet
• Using Sparklines

Working with formulas and functions

Learn to create Excel calculations, formulas, and functions, including using Excel formulas to perform mathematical expressions.
Use True / False in Excel to check for matching data. Find out how to use Excel Functions, including AutoSum and text functions that can modify text based on input values. Also, learn about multi-Input Functions, which require multiple inputs and Constant Cell References that can be used for calculations.

• Creating formulas
• Using the 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
• Printing your spreadsheet
• Protecting your workbook