Excel does far more than hold data in rows and columns. This 6-hour Excel training seminar shows you how to calculate, summarize and chart your data, find what matters with sorting and filtering, and protect your work from unwanted changes.
You'll start with formulas: entry rules, order of operations, functions, AutoSum, relative and absolute references and AutoFill. Next come sorting and filtering, then building and formatting charts. The session moves on to summarizing and analyzing data with PivotTables and PivotCharts.
Finally, you'll work with presentation elements such as pictures and shapes, and learn worksheet, workbook and file-level protection.
This session gives you a well-rounded tour of Excel in one easy-to-follow workshop, from basic formulas and data sorting to PivotTables, shapes and pictures.
It suits business owners, executives, managers, accountants, CPAs, financial consultants, IT professionals, auditors, HR staff, bookkeepers, marketers and anyone who works with large amounts of data or uses Excel regularly and wants to be more productive.
Entering Excel formulas
Sorting and filtering data
Creating charts
Summarizing data with PivotTables
Working with presentation elements
Protecting worksheets and files
This session gives you a well-rounded tour of Excel in one easy-to-follow workshop, from basic formulas and data sorting to PivotTables, shapes and pictures.
It suits business owners, executives, managers, accountants, CPAs, financial consultants, IT professionals, auditors, HR staff, bookkeepers, marketers and anyone who works with large amounts of data or uses Excel regularly and wants to be more productive.
Entering Excel formulas
Sorting and filtering data
Creating charts
Summarizing data with PivotTables
Working with presentation elements
Protecting worksheets and files
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, …
New Form I-9: Documents and Policies that Ensure ICE I-9 Co…
Claude AI For CPAs & Finance Professionals: Best Practices …
Secrets Of Psychology - Why People Do The Things They Do
2-Hour Virtual Seminar on How to Conduct an Internal Harass…
Project Management For Administrative Professionals
Onboarding is NOT Orientation - How to Improve the New Empl…
Elevate Your Workplace Wellness: 10 Critical Wellness Facto…
Managing Complex Projects - Project Management
Utilizing HR Metrics to Illustrate & Improve Human Resource…
Negotiating Skills For Professional Results - Winning Strat…
NEW Nacha Rule - Third-Party Sender (TPS) Roles and Respons…
Paying and Receiving Payments for Referrals: You Can Go to …
FDA Technology Modernization Action Plan (TMAP) and Impact …
Human Factors Usability Studies Following ISO 62366 and FDA…
Construction Lending And Real Credit Administration: Evalua…
Validation Statistics for Non-Statisticians
Thriving in a Hybrid Workplace: Keys to Leadership and Team…
Excel Power Skills: Master Functions, Formulas, and Macros …
Batch Record Review and Product Release
Discover how Emotional Intelligence turns AI from a technic…
Copilot and HR: An Introduction for HR Professionals
ChatGPT for HR - Build HR Policy Framework and Strategy
Female to Female Hostility @Workplace: All you Need to Know