SP903 - Advanced Applications of Excel

Course Description

Learn advanced functions and database management techniques, including sorting, filtering data, and using database statistical functions. Get the most out of your Excel applications by linking data between worksheets and workbooks. Other topics include using lookup tables and performing what-if analysis using Goal Seek and scenarios.

By the end of the course, you will be able to: 

• Use Excel tables to manage data by sorting and filtering records, eliminating duplicates, adding total rows, and creating calculated columns 

• Use database statistical functions to perform calculations on data that meet certain criteria 

• Use Excel’s LOOKUP functions to look up information in a table 

• Link data between worksheets and workbooks 

• Use Goal Seek and scenarios to analyze your Excel data 

Applies Towards the Following Certificates

• Business Applications Certificate : Foundational Skills Using Excel
• Excel Certificate : Foundational Skills Using Excel 
• Foundational Skills Using Excel : Required Courses