Getting the Most From Microsoft Excel

SkillPath
Training overview
Professional Course
3 hours

Course description

Getting the Most From Microsoft Excel

Do you ever find yourself searching through an 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!

Want to find out more?

Training content

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

Certification / Credits

  • Refresh your skills quickly with the must-know essentials aspects of Microsoft® Excel®
  • Learn the secrets to building a scalable, sustainable workbook that is truly user-proof
  • Save time with shortcuts and functions for power users
  • Analyze data by consolidating data sets stored on different sheets
  • Effectively utilize charts to visually communicate your data
  • Learn practical tips and techniques you need to get more done in less time

About SkillPath

SkillPath

SkillPath is a leader in business training with more than 30 years of experience. Our professional training programs prioritize learner engagement — helping theory take root with learners, so it transforms their thinking and becomes day-to-day practice. SkillPath’s courses are...


Read more and show all training delivered by this supplier

Contact this provider

Fill out your details to find out more about Getting the Most From Microsoft Excel.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

SkillPath

6900 Squibb Road
66202 Mission Kansas

 Show phone number
skillpath.com


Request Information

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available