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.
WHY SHOULD YOU ATTEND?
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.
AREA COVERED
Entering Excel formulas
- Rules for entering formulas
- Understanding the order of operations
- Creating basic calculations
- Entering functions
- Using AutoSum
- 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 chart size and position
- Changing the chart type
- Switching data
- Changing the chart layout and style
- Adding labels
- Moving a chart to a chart sheet
Summarizing data with PivotTables
- Creating a PivotTable
- Analyzing data with PivotTables
- Adding styles and report layouts
- Creating a PivotChart
Working with presentation elements
- Inserting pictures and clip art
- Sizing, moving and changing the orientation of objects
- Enhancing pictures
- Drawing and formatting shapes
- Selecting multiple objects
- Arranging, aligning and grouping images
Protecting worksheets and files
- Worksheet-level protection
- Workbook-level protection
- File-level protection
LEARNING OBJECTIVES
- Enter formulas and functions correctly, using the order of operations and cell references
- Copy formulas with AutoFill and total data with AutoSum
- Sort and filter data to find relevant information
- Create, format and relocate charts
- Summarize and analyze data with PivotTables and PivotCharts
- Insert, format and arrange pictures and shapes
- Protect worksheets, workbooks and files
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 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
- Rules for entering formulas
- Understanding the order of operations
- Creating basic calculations
- Entering functions
- Using AutoSum
- 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 chart size and position
- Changing the chart type
- Switching data
- Changing the chart layout and style
- Adding labels
- Moving a chart to a chart sheet
Summarizing data with PivotTables
- Creating a PivotTable
- Analyzing data with PivotTables
- Adding styles and report layouts
- Creating a PivotChart
Working with presentation elements
- Inserting pictures and clip art
- Sizing, moving and changing the orientation of objects
- Enhancing pictures
- Drawing and formatting shapes
- Selecting multiple objects
- Arranging, aligning and grouping images
Protecting worksheets and files
- Worksheet-level protection
- Workbook-level protection
- File-level protection
- Enter formulas and functions correctly, using the order of operations and cell references
- Copy formulas with AutoFill and total data with AutoSum
- Sort and filter data to find relevant information
- Create, format and relocate charts
- Summarize and analyze data with PivotTables and PivotCharts
- Insert, format and arrange pictures and shapes
- Protect worksheets, workbooks and files
- 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
Medical Device Cybersecurity Following FDA’s 2026 Premarket…
Managing Toxic Employees: Strategies For Leaders To Effecti…
California Meal and Rest Breaks: What You Don't Know Can Co…
Human Error Reduction Techniques for Floor Supervisors
Unlock Employee Loyalty: Stay Interviews Will Keep Them Eng…
Performance of Root Cause Analysis, CAPA, and Effectiveness…
Your AI Advantage: How HR Professionals Can Use Claude to S…
The Anti-Kickback Statute: Enforcement and Recent Updates
Empowering Conflict Resolution: Letting Go to Gain Control
Wage & Hour Laws: Ensuring Compliance with the Fair Labor S…
Using Copilot to Format Legal Documents in Microsoft Word
Dealing With Difficult People: At Work & In Life
Using Stay Interviews To Improve Employee Retention & Engag…
AI in Word - Smarter Writing and Document Creation with Cha…
FDA Current Trends in Compliance and Enforcement for FDA-Re…
Zero Acceptance Sampling to Reduce Inspection Costs
Why EBITDA Doesn't Spell Cash Flow and What Does?
Mastering Tough Conversations: Turn Conflict into Clarity, …
Enhancing Pivot Tables with Images: Visualize Your Data Lik…
Discover how Emotional Intelligence turns AI from a technic…
Understanding Financial Statements for Non-Financial Profes…
SOPs - How to Write Them to Satisfy those Inspectors
Managing Projects When AI Joins the Team: Human Judgment, A…