Overview
This class will guide you through the process of setting up, managing, and analyzing data within Excel, turning you into a more efficient and organized user. You’ll start by learning how to set up a usable database, followed by sorting data and filtering data for easy navigation and to find a specific data set. You’ll also learn how to Subtotal data for meaningful aggregation.
Discover the many benefits of using Tables, including how to create, modify, and add or delete data within them. With a focus on Tables, you’ll see how to calculate and summarize data using Excel's built-in tools, such as the Total Row. Learn the importance of refreshing PivotTables when working with dynamic tables.
Why you should Attend
If you work with data on a regular basis-whether you're tracking sales, managing inventories, or conducting research-this class will provide you with essential tools to make your work more efficient and insightful. You’ll learn how to organize and manipulate data, freeing you from time-consuming manual processes. The skills you gain will allow you to create streamlined, user-friendly databases, perform data analysis, and generate reports with ease. Whether you’re looking to improve your Excel proficiency for personal projects or seeking to boost your professional skills, this class will equip you with the knowledge to analyze data quickly and make informed decisions.
Areas Covered in the Session
- Set up a usable database
- Sort data by columns
- Custom filter for text, numbers and dates
- Subtotal data
- Learn the benefits of tables
- Create and modify tables
- Add and delete data in a table
- Calculate data in a table
- Use the table’s total row
- Convert tables to normal ranges of data and why
- Summarize table data with a PIvotTable
- Learn the benefit of refreshing PIvotTables based on tables
Who Will Benefit
- Financial Analysts
- Accountants
- Data Analysts
- Project Managers
- Operations Managers
- Marketing Analysts
- Sales Managers
- Supply Chain Managers
- HR Professionals
- Researchers
Speaker Profile
Cathy Horwitz is a highly experienced Microsoft Office instructor, specializing in Excel, Word, PowerPoint, Outlook, and Access. With over 30 years of expertise in both in-person and online training, she has helped thousands of professionals boost productivity, streamline workflows, and master essential Microsoft Office skills.
Cathy has been teaching Microsoft Office since its inception, offering tailored training programs that meet the unique needs of individuals and businesses. Her courses cover everything from Excel formulas, PivotTables, and automation with macros to Word document formatting, PowerPoint presentation design, and Outlook email management. Workshops from beginning level through advanced are available.
Known for her engaging, hands-on teaching style, Cathy incorporates real-world business scenarios to ensure students gain practical skills they can immediately apply. Whether you're looking for corporate training, individual coaching, or advanced Microsoft Office workshops, Cathy delivers results-driven instruction that enhances efficiency, problem-solving, and software proficiency.
Instructor
Cathy Horwitz