Microsoft Excel Training

Join Training and Development in Zoom (https://anthc.zoom.us/j/99690230007) for Microsoft Excel from 9:00 a.m.– 12:00 p.m. on Wednesday, Dec. 14.

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.