Agenda
WORKSHOP AGENDA
Program time: 3 hours
Session 1: Excel Fundamentals
Understand the Excel interface — the Quick Access Toolbar, ribbon, formula bar, editing area and status bar
Recognize the three unbreakable rules of worksheets
How to input the only three ingredients you’ll ever need in a workbook
Communicate effectively with the revamped natural language help system
Session 2: Getting Down to Business: Building a Scalable, Sustainable Workbook
Triple your speed — Tips to remember the essential keyboard shortcuts for data entry
Ensure a consistent look within your workbook by standardizing with built-in cell styles
Solve common printing problems
Create custom views to preserve print settings — so you don’t have to format and reformat worksheets each time you need to print
Generate a well-structured workbook that will be scalable and sustainable
Session 3: Time-saving Techniques — Understanding Essential Power Shortcuts and Functions
Learn the must-know shortcuts and functions for power users
Get your work done faster by using keyboard shortcuts and speed keys
Expand your skills using CONVERT, COUNTIFS and SUMIFS
Analyze data by consolidating data sets stored on different sheets
Construct PivotTable reports out of tabular data
Session 4: Charting Essentials
There are dozens of options for charting your data in Excel. Which one should you use?
Understand the fastest way to build a chart
Customize standard charts with trendlines and custom settings
Use sparklines to make your workbook data more visual
Apply custom number formatting and conditional formatting to data visualizations
You’ll also receive the Microsoft Excel for Office 365 Tool Kit, a robust reference guide containing helpful shortcuts and a glossary of Excel terms.
Comments
Registrations for classes must originate from either the United States or Canada.Cancelation Policy: If you cannot attend an event, you may send someone else in your place. If that isn’t an option for you, cancellations received up to five working days before the event are refundable, minus a registration service charge ($10 for one-day events; $25 for multiple-day events). After that, cancellations are subject to the entire seminar fee, which you may apply toward a future seminar. Please note that if you don’t cancel and don’t attend, you are still responsible for payment.