Your business training experts!
Excel Managing Large Datasets Course
Class Duration: 7 hours
Do you feel like you have rows and rows of data and it’s hard to make heads or tails of it? This Excel training will help you learn how to manage large datasets in Excel, and get the most out of them. You will learn how to analyze Excel data, as well as better manage large tables of it. You will learn the most useful database functions in Excel to help you add, average, count, and find information in your rows. You will learn how to use macros, which can help you automate repetitive steps in large lists of data. Your instructor will be available to address all of your questions and lead you to a mastery of managing databases in Excel.
Training Class Goal
This Excel class is for people who have to regularly manage large tables of data within Excel. Upon completing this course, students will know how to manage large amounts of data in Excel, and have a mastery of the tools and formulas that work best in dealing with large sets of information. Students will gain an understanding of database functions, macros, analysis tools, and viewing tips, to best work with large amounts of data.
Prerequisites
Students must already have an understanding of Excel fundamentals including formatting, navigation, and basic formulas.
Topics Covered
Large Dataset Management Tools
- Arranging and viewing large amounts of Data
- Filtering Data
- Conditional Formatting
- Sparklines
- Watch Window
- Group and Summarize Data
- Subtotal Data
- Removing Duplicates
- Custom Views
- Excel Workspace
- Page Break Preview
Functions & Formulas
- Financial Functions
- The Amortization tool
- Data Tables
- Data Consolidation tools
- Naming cell ranges
- Database functions
- Reference Functions
- Other classes covering Excel Formulas and Functions
What-If Analysis Tools
- Goal Seek
- Solver
- Scenarios
- Analysis of tool pack
Macros
- Planning and Recording
- Running
- Viewing and Editing VBA Code
- Saving
Collaboration Tools
- Tracking changes
- Sharing and Merging Workbooks
