Microsoft Excel – Intermediate

WORKSHOP DESCRIPTION

Microsoft Excel remains the de facto spreadsheet application for business. This versatile software package can help you manage virtually any type of data. Whether you are tracking orders, working with budgets, or analyzing a database – Excel is the powerful and flexible solution your job requires.

This hands-on course will teach you the important functions of this industry-standard software.

Course content is designed for current versions of Microsoft Excel, including Microsoft 365 and Excel 2024.

WHO SHOULD ATTEND:

• People with a basic knowledge of Excel and a desire to upgrade their skills

YOU WILL LEARN:

• Organize, protect, and display data using various tools
• Use the IF function to create linking formulas and to manage links
• Manage and arrange multiple workbooks: insert and manage multiple worksheets within a workbook and consolidate data from multiple sources
• Create, modify, customize, and enhance charts to present data effectively
• Create, apply, and modify styles to format worksheets consistently and quickly
• Use comments and text boxes to annotate worksheets, and use sparklines to highlight data

COURSE OUTLINE

Worksheet Organization

• Managing range names
• Creating and using workbook templates
• Applying worksheet security
• Creating and using outlines

Advanced Formulas

• Using the IF function
• Linking formulas
• Modifying and restoring links
• Introducing modern lookup and dynamic formula concepts where appropriate

Using Multiple Workbooks and Worksheets

• Working with multiple workbooks
• Working with multiple worksheets
• Consolidating data

Working with Charts

• Creating charts
• Changing chart data
• Modifying chart elements
• Creating custom charts

Applying Formatting

• Working with styles
• Annotating worksheets
• Using sparklines

Summary and Evaluations

METHODOLOGY

This is a live, instructor-led workshop with hands-on exercises

Participants are requested to bring their computers to the session. Laptops are also available to rent for an additional fee.