Excel 1-Day Fundamentals Workshop | In Person | New York City
About this workshop
Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate and enhance the way you analyze and restructure your data. Dive into formula writing, combining formulas, creating basic to intermediate charts, and, of course, leveraging the ultra-powerful PivotTable in Microsoft Excel.
This 6-hour Excel 1-Day Workshop is the quickest way to get started on learning to leverage your data. You will dive head first into Excel, skill up with exercises, and by the end of the day you'll know how to ask — and answer — the right questions of your data sets.
Takeaways
- Apply basic formula logic using absolute or relative references.
- Quickly pull necessary information out of large data sets.
- Execute advanced Excel functions, such as VLOOKUP and IF variants such as SUMIF and COUNTIF.
- Combine formulas to clean, edit, or analyze data sets with greater efficiency, compiling accurate spreadsheets.
- Build and modify PivotTables to quickly and effectively analyze large quantities of data.
- Create visualizations to clearly communicate insights.
Prereqs & Preparation
- A laptop loaded with Excel, and a general familiarity with the program (including basic data entry, and copying & pasting).
- You will also want to set up a Gmail account as we may jump in and out of Google Spreadsheets during the workshop.
- It is also recommended (but not required) that you bring a mouse, as if may make some exercises easier.
Regulatory Information:
