Businesses are run and led by people who are good at understanding trends and patterns. In order to make better decisions, most businesses collect a lot of data; however, data without insight does not provide strategic benefits.
Excel allows you to unlock the hidden connections and map out valuable trends that very few would notice in a table of data.
This boot camp will help you learn powerful processes that transform the data you have available into tools that can support and develop business strategy. The instructors will walk you through real-world examples to gain hands-on experience while covering the following topics:
- Data Import: imports, connections, validation, duplicates
- Data Manipulation: vlookups, hlookups, arithmetic, functions, etc.
- Data Hypothesis and Analysis: pivot tables, data enrichment, graphs, etc.
- Data Extraction: PERL, CSV and PDF conversions (time permitting)
Please bring a laptop loaded with Microsoft Excel in order to complete in-class exercises. Previous experience with Excel is recommended but not required.