Excel is more than inputting data into rows and columns. It is calculating that data. It is summarizing your data. It is inserting graphs and chats to communicate that data. Do you have to sort the data in order to find relevant information? Is there criteria to input to isolate certain data sets? There may be a need to analyze that data into metrics that fit a specific set of standards. Then the data should be protected against unwanted changes. You will learn all of this in one easy to follow workshop.
WHY SHOULD YOU ATTEND?
This 6-hour session will teach you skills in a variety of areas within Excel. You will learn basic formulas and functions and sorting and filtering data. Then we will venture to more complex topics like PivotTables and even drawing shapes and inserting pictures. You will receive a well-rounded exploration of Excel.
LEARNING OBJECTIVES
- Entering Excel Formulas
- Rules for Entering Formulas
- Understanding the Order of Operations
- Creating Basic Calculations
- Entering Functions
- Using Auto Sum
- Understanding Relative and Absolute Cell References
- Using Autofill to Copy Formulas
- Sorting and Filtering Data
- Sorting a Single Column
- Sorting Multiple Columns
- Filtering for Specific Data
- Creating Charts
- Creating a Chart
- Changing the Size and Position of a Chart
- Changing the Chart Type
- Switching Data
- Changing the Chart Layout
- Changing the Chart Style
- Adding Labels
- Moving a Chart to a Chart Sheet
- Summarizing Data with PivotTables
- Creating a PivotTable
- Analyzing Data Using PivotTables
- Adding Styles Report Layouts to PivotTables
- Creating a PivotChart
- Working with Presentation Elements
- Inserting Pictures and Clip Art
- Sizing and Moving Objects
- Changing the Orientation of an Object
- Enhancing Pictures
- Drawing Shapes
- Selecting Multiple Objects
- Formatting Shapes
- Arranging, Aligning & Grouping Images
- Protecting Worksheets and Files
- Worksheet Level Protection
- Workbook Level Protection
- File Level Protection
WHO WILL BENEFIT?
- 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
This 6-hour session will teach you skills in a variety of areas within Excel. You will learn basic formulas and functions and sorting and filtering data. Then we will venture to more complex topics like PivotTables and even drawing shapes and inserting pictures. You will receive a well-rounded exploration of Excel.
- Entering Excel Formulas
- Rules for Entering Formulas
- Understanding the Order of Operations
- Creating Basic Calculations
- Entering Functions
- Using Auto Sum
- Understanding Relative and Absolute Cell References
- Using Autofill to Copy Formulas
- Sorting and Filtering Data
- Sorting a Single Column
- Sorting Multiple Columns
- Filtering for Specific Data
- Creating Charts
- Creating a Chart
- Changing the Size and Position of a Chart
- Changing the Chart Type
- Switching Data
- Changing the Chart Layout
- Changing the Chart Style
- Adding Labels
- Moving a Chart to a Chart Sheet
- Summarizing Data with PivotTables
- Creating a PivotTable
- Analyzing Data Using PivotTables
- Adding Styles Report Layouts to PivotTables
- Creating a PivotChart
- Working with Presentation Elements
- Inserting Pictures and Clip Art
- Sizing and Moving Objects
- Changing the Orientation of an Object
- Enhancing Pictures
- Drawing Shapes
- Selecting Multiple Objects
- Formatting Shapes
- Arranging, Aligning & Grouping Images
- Protecting Worksheets and Files
- Worksheet Level Protection
- Workbook Level Protection
- File Level Protection
- 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
Speaker Profile
Cathy Horwitz
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, …
Upcoming Webinars
AI for Excel Professionals: Enhancing Productivity with Cha…
Leadership: Strategic Planning and Decision Making
2026 Form I-9 Changes & New ICE Penalties: What Every Emplo…
Human Factors Usability Studies Following ISO 62366 and FDA…
2-Hour Virtual Seminar on How to Conduct an Internal Harass…
Fostering a Culture of Respect: Eliminating Gossip, Rumour…
Bootcamp for New Managers and Supervisors: Develop These Es…
FDA Compliance for Regulated Systems using COTS, Cloud, and…
Implementing an Effective Succession Plan to Identify, Deve…
Boost Financial Analysis with Claude in Excel
ChatGPT for HR - Build HR Policy Framework and Strategy
I-9 Enforcement & Compliance: A 5-Step Plan for Employers t…
The Anti-Kickback Statute: Enforcement and Recent Updates
Wage & Hour Laws: Ensuring Compliance with the Fair Labor S…
Emotional Intelligence: Mastering the Emotions of Great Lea…
Expense Reimbursements 2026 - Proper Recordkeeping and Acco…
Unlock Employee Loyalty: Stay Interviews Will Keep Them Eng…
Construction Lending And Real Credit Administration: Evalua…
Dealing With Difficult People: At Work & In Life
Claude AI For CPAs & Finance Professionals: Best Practices …
Secrets Of The Staffing Fix - Solving The Employee Training…
Mastering the Prompt: How Every Professional Can Use AI to …
Eliminate Harmful And Unproductive Drama In The Workplace
Using Copilot to Format Legal Documents in Microsoft Word
Setting SMART Goals & Leveraging Storytelling for Reporting
Excel + AI: The Smart User's Guide to Faster, Easier Work w…
Discover how Emotional Intelligence turns AI from a technic…
Introduction to Microsoft Power BI Dashboards
Excel Spreadsheets; Develop and Validate for 21 CFR Part 11…
Major cGMP Issues: FDA Concerns in 2026
Elevate Your Workplace Wellness: 10 Critical Wellness Facto…
Maximizing Productivity with ChatGPT: AI Solutions for HR, …
Excel - Pivot Tables - The Key To Modern Data Analysis and …
Managers/Supervisors: New Role, Same Team - How to Lead Wit…
HR Auditing - New Update on Important Issues for 2026
2-Hour Virtual Seminar on In-Person Onboarding Your New Hir…
6-Hour Virtual Boot Camp on Microsoft Power BI
Outlook - Master your Mailbox - Inbox Hero Inbox Zero
Managing Toxic Employees: Strategies For Leaders To Effecti…
California Meal and Rest Breaks: What You Don't Know Can Co…