Data analysis with MS Excel 2016
Advanced Level
Ava
Book your Space
The analysis of historical data is fundamental in the decision making process in any organization. The Excel 2016 tool allows us to do various profitability analyses, highlight significant data changes, compare data for years, view hierarchical charts, and project future trends to support decision-making.
*** Important: You should know how to create and modify PivotTables, PivotCharts and dashboards. ***
August 24, 2018 @ 9:30am – 12:30pm
American University, Bayamón, PR
$50.00 Non-Members │ free of cost for members
* Includes manual, certificate and snack.
What are we going to discuss?
Profitability Analysis
Apply conditional formatting (conditional Formatting) For Detect important signals in the data.
Use the calculated field function (calculated field) To do operations with the existing fields in a PivotTable.
Hierarchical data and multiple dynamic tables
Describe the features of the new hierarchical charts in Excel 2016: TreeMap and Sunburst.
Use the Data Model feature (DATA Model) to make a PivotTable from related data in multiple sheets.
Year-after-year comparison
Discuss the advantages and limitations of the role GETPIVOTDATA In dynamic tables.
Apply the function SUMIFS To add multiple criteria.
Create Sparkline (Sparklines) to highlight trends.
Prognosis and trend
Predict future values and possible behaviors according to historical data with the prognostic functions (Forecast) and Trend (Trend).
Identify the difference between forecasting and trending functions.
follow us
Grant funded project 2022-2025