Excel III - Advanced Data Analysis


This is a 4-hour, web-based class taught using WebEx and a live instructor. If you perform any of the following tasks, this class is a must: accounting/budgeting, data analysis, forecasting or collection/verification of business data.

This class explores the advanced features of Excel 365/2019/2016 and will teach attendees how to: automate worksheet functionality, analyze data, work with multiple workbooks, explore data and import/export XML data. This class is geared toward participants who are already familiar with Excel but would like to become more proficient with more advanced functions of Excel: master Vlookup/Hlookup functions, nested IF Functions, SumIF Functions, PivotTables & PivotCharts, conditional formatting, record a simple macro, What If Analysis using: Goal Seek features, single variable data tables, double variable data tables, the Scenario Manager feature.

No courses found