Microsoft Excel 365 Customized: Intermediate to Advanced

This in-depth two-day course introduces Microsoft Excel 365 users to the advanced features of the software application. Participants will learn how to perform calculation, work with chart and format chart, use logical function, work with hyperlinks, manage data from multiple worksheets and workbooks, use table style and conditional formatting, sort and manage data in lists, filter data, use lookup functions, and work with PivotTables. In-class exercises will involve use of data tables and scenarios to make projections about data and use Goal Seek. Students will also learn how to audit worksheets, protect workbooks, create and use macros, and work with cell comments.

Upon successful completion of this course, students will be able to:

• Perform calculations and manipulate worksheet data
• Create and edit charts
• Format charts
• Use logical functions
• Work with hyperlinks
• Work with multiple worksheets and workbooks
• Work with table styles and formats
• Sort and manage data in lists
• Filter data
• Use lookup functions
• Use PivotTables to display and chart data
• Use data tables, scenarios and forecast to make projections about data
• Use goal seek to analyze data
• Audit worksheets
• Protect worksheets and workbooks
• Work with macros
• Work with comments