Microsoft Excel Training

Join Training and Development in person and via Zoom (https://anthc.zoom.us/j/99690230007) for Microsoft Excel from 9 a.m.- 12 p.m. on Thursday, May 18.

Discover the essentials needed to create a basic workbook, insert and modify data in the spreadsheet, filter and sort tables, perform calculations, and modify charts and objects.

Learn the essentials to create and manage worksheets and workbooks; data cells and ranges; charts and objects, and tables. Learn to perform operations with the AutoSum functions

In this training you will create and edit basic Excel worksheets and workbooks.

• Create a basic worksheet
• Perform calculations in an Excel worksheet
• Modify the appearance of a worksheet
• Manage and print Excel workbooks

Basic Course outline:

Lesson 1: Getting Started with Excel

Topic 1A: Identify the Elements of the Excel Interface

Topic 1B: Navigate and Select Cells in Worksheets

Topic 1C: Customize the Excel Interface

Topic 1D: Create a Basic Worksheet

Lesson 2: Modifying a Worksheet

Topic 2A: Edit Worksheet Data

Topic 2B: Find and Replace Data

Topic 2C: Manipulate Worksheet Elements

Lesson 3: Modifying the Appearance of a Worksheet

Topic 3A: Apply Font Properties

Topic 3B: Add Borders and Colors to Cells

Topic 3C: Align Content in a Cell

Topic 3D: Apply Number Formatting

Topic 3E: Apply Cell Styles

Lesson 4: Performing Calculations in an Excel Worksheet

Topic 4A: Create Formulas in a Worksheet

Topic 4B: Insert Functions in a Worksheet

Topic 4C: Reuse Formulas

Lesson 5: Managing an Excel Workbook

Topic 5A: Manage Worksheets

Topic 5B: View Worksheets and Workbooks

Lesson 6: Printing Excel Workbooks

Topic 6A: Define the Page Layout

Topic 6B: Print a Workbook

Sign up in HealthStream, search the Catalog for Microsoft Excel, and click Enroll or Choose Class to register.

Space is limited to 16.

For questions regarding Microsoft OneNote, contact Training and Development at training@anthc.org or call 907-729-1301.