Purchase any WEBINAR and get
10% Off
CODE: SAVE10
T&C applicable, please referFAQ
Validity : 29th Nov'24 to 09th Dec'24
Excel Data Simplified: Sorting and Filtering, Tables, and PivotTable Mastery
Sorting and Filtering Data
- Sorting a single column
- Sorting multiple columns
- Filtering for specific data
- Advanced filtering
- Sort and filter by color
Using Tables
- Creating and modifying tables
- Formatting tables
- Calculating tables
- Calculating data in a table
- Convert the table to a normal range of data
Subtotals
- Creating subtotals
- Adjusting views with subtotals
- Removing Subtotals
Summarizing Data with PivotTables
- Creating a PivotTable report
- Rearranging, sorting, filtering, and formatting a PivotTable
- Changing a PivotTable Calculation
- Show values as Percentages
- Refreshing Data in a PivotTable
- Grouping dates
- Showing/hiding PivotTable tools
- Changing PivotTable style
- Change the layout and format of a PivotTable report
- Creating Pivot Chart
- Filtering PivotChart
Overview of the webinar
Mastering these essential Excel skills will empower participants to work more efficiently with large datasets, helping you quickly organize and analyze information. This class invaluable for anyone looking to enhance their Excel expertise for better data-driven decision-making.
Who should attend?
- Business Owners
- CEO's / CFO's / CTO's
- Managers
- Accountants
- CPA's
- Financial Consultants
- IT Professionals
- Auditors
- Human Resource Personnel
- Bookkeepers
- Marketers
- Anybody with large amounts of Data
- Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive
Why should you attend?
Learning advanced sorting and filtering techniques allows users to hone in on relevant data, while mastering tables and PivotTables provides dynamic ways to summarize and present data in a professional and intuitive manner. Customizing views, formatting, and adjusting calculations in PivotTables will give users the flexibility to present their findings clearly.
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.