Loading...

Course Description

Learn to use data analysis tools, advanced formulas, creating lookup and data tables, work with database tools and pivot tables, import and export data and use of goal seeker and solver tools.

Learner Outcomes

Create advanced formulas to calculate logical and financial functions utilizing IF, SUMIF, Round and PMT; Demonstrate the ability to use subtotals and database functions to summarize list data and use data forms and validation to facilitate data entry in lists; Create and use PivotTables to analyze and compare large amounts of data; Demonstrate the ability to work with exporting and importing data; Utilize analytical tools including Goal Seek, Solver and scenarios.
Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .