Description

Course Description:
When you master Excel, you have one of the most practical and valuable skillsets in modern business. You can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course builds on your existing Excel knowledge and teaches you how to efficiently manage data using charts and tables, and how to use powerful reporting tools such as Pivot Tables, Pivot Charts, Slicers, Timelines, and more. Duration: 5 Hours.

Instructors:
Bigger Brains

Audience:
Interested employees.

Learning Objectives:

• Create and use named ranges
• Insert functions into spreadsheets including Date and Time functions, Logical functions, Text functions, Math functions, Database functions, Subtotals, and nested functions
• Sort and filter data
• Create and modify tables
• Apply advanced Conditional Formatting
• Create and modify charts and graphics, and apply advanced charting tools
• Create a Pivot Table
• Use advanced Pivot Table tools, create a Pivot Chart, and filter data using Slicers and Timelines

Disclaimer

The information presented is for general reference only. HAI Group makes no representation or warranty about the accuracy or applicability of this information for any particular use or circumstance. Your use of this information is at your own discretion and risk. HAI Group and any author or contributor identified herein assume no responsibility for your use of this information. You should consult with your legal, professional or subject matter advisor before implementing any new strategy or policy.