Purchase any WEBINAR and get
10% Off
CODE: SAVE10
T&C applicable, please referFAQ
Validity : 29th Jan'25 to 08th Feb'25
Mastering Excel Tables: Supercharge Your Database Skills
- 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 Pivot Table
- Learn the benefit of refreshing Pivot Tables based on tables
Overview of the webinar
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.
Who should attend?
This class is ideal for anyone looking to take their Excel skills to the next level and streamline their workflow. Whether you're an analyst, manager, or anyone who works with datasets, mastering these tools will save you time, reduce errors, and help you extract meaningful insights quickly.
- Financial Analysts
- Accountants
- Data Analysts
- Project Managers
- Operations Managers
- Marketing Analysts
- Sales Managers
- Supply Chain Managers
- HR Professionals
- Researchers
Why should you 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.
Faculty - Ms.Cathy Horwitz
Cathy Horwitz believes that when you know the capabilities of the software you use, you will demonstrate improved productivity, will be more efficient and will be able to problem solve more easily.
She is an experienced educator specializing in the Microsoft Office suite, including Excel, PowerPoint, Word, Access, and Outlook. With over 30 years of expertise in classroom and virtual training, Cathy has been teaching Microsoft Office since its inception, helping students and professionals master its powerful tools.
Cathy excels at tailoring her classes to meet the unique needs of her students, incorporating practical, real-world business examples to enhance learning. Known for her high energy and engaging approach, she brings a dynamic and supportive style to adult education, ensuring her students gain both confidence and competence in using Microsoft Office effectively.
She holds the Modern Classroom Certified Trainer certification from Logical Operations which prepares instructors for all aspects of delivering a course using the latest training technologies and approaches.
When not teaching, Cathy enjoys gardening, traveling, and refinishing mid-century furniture.