Getting the Most From Microsoft Excel
Do you ever find yourself searching through a Microsoft Excel manual…wishing you had an Excel expert to ask…or even giving up in frustration by “working around” features that you know Excel is capable of because you don’t know how to use them? This LIVE, virtual seminar will show you how to end your Excel frustrations for good by providing the “how-tos” for breezing through spreadsheets, forecasts, graphs and financial reporting, plus little-known shortcuts and time-saving techniques. Work smarter, not harder, by enrolling in this live, highly interactive training event today!
For an optimal experience with this course, we recommend Excel 2016 and later. Windows platform preferred.
Course Outcomes
- Refresh your skills quickly with the essential aspects of Microsoft Excel
- Discover the secrets to building a scalable, sustainable and user-proof workbook
- Save time with advanced shortcuts and functions for power users
- Consolidate data sets from different sheets for comprehensive analysis
- Utilize charts to visually communicate your data
- Learn practical tips and techniques to get more done in less time
Course Agenda
Request group training
Complete the form below to request tailored, private training for your team. We’ll be in touch to discuss your group’s specific goals.
More Courses in
Related Courses
 | skillpath.com/OXCMEXW |
Getting the Most From Microsoft Excel
Do you ever find yourself searching through a Microsoft Excel manual…wishing you had an Excel expert to ask…or even giving up in frustration by “working around” features that you know Excel is capable of because you don’t know how to use them? This LIVE, virtual seminar will show you how to end your Excel frustrations for good by providing the “how-tos” for breezing through spreadsheets, forecasts, graphs and financial reporting, plus little-known shortcuts and time-saving techniques. Work smarter, not harder, by enrolling in this live, highly interactive training event today!
For an optimal experience with this course, we recommend Excel 2016 and later. Windows platform preferred.
Session 1: Mastering Excel Basics
- Navigate the Excel interface — the Quick Access Toolbar, ribbon, formula bar, editing area and status bar
- Recognize the three unbreakable rules of worksheets
- Master the three essential elements needed for effective workbook creation
- Utilize Excel’s updated help system to find answers and solutions more easily
Session 2: Streamlining Your Workflow
- Triple your speed with 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 reformat worksheets every time you print
- Generate a well-structured, scalable and sustainable workbook
Session 3: Time-Saving Techniques — Understanding Essential Power Shortcuts and Functions
- Learn the must-know shortcuts and functions for power users
- Get work done faster using keyboard shortcuts and speed keys
- Expand your skills with CONVERT, COUNTIFS and SUMIFS
- Analyze data by consolidating data sets from different sheets
- Construct PivotTable reports from tabular data
Session 4: Charting Essentials
- Select the best chart type for your data
- 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.