Advance Excel

Description

In this course, you will learn how to: Duration: 3 Month

• Create outlines in Excel
• Create your own templates
• Work with sparklines
• Create and manage scenarios
• Use Goal Seek and Solver
• Create, manage, and format pivot tables and pivot charts
• Use the Excel mathematical functions
• Create and write complex formulas
• Perform data lookups
• Create and use IF statements
• Use Excel's data functions
• Create and use data validation rules
• Apply custom and prebuilt conditional formatting
• Work with functions to manipulate strings of text and data
• Create and use macros
• Troubleshoot and audit formulas
• Create pivot tables and pivot charts
• Use queries to import external data
• Import and clean data
• Link and consolidate worksheets and workbooks
• Troubleshoot errors
• And more