Getting the Most from Microsoft Excel

Course Description

Getting the Most from Microsoft Excel course is offered multiple times in a variety of locations and training topics.

What you will learn

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.

Course: Getting the Most from Microsoft Excel

$149.00

View All Dates

Looking for Group eLearning Options?

Get your team access to 4,000+ top courses anytime, anywhere.

Request On-Site Training

Upcoming Dates

Location: , Virtual Live
Date & Time: Apr 30, 2024 09:00 AM CST

$149.00

Location: , Virtual Live
Date & Time: Apr 30, 2024 01:00 PM CST

$149.00

Location: , Virtual Live
Date & Time: May 02, 2024 09:00 AM CST

$149.00

View All (26)

Location	Date & Time	Duration	Course Type CL Classroom Live - Traditional live classroom with in-person instructor. CV Classroom Virtual - Attend this live instructor-led event remotely from the indicated tech facility. VL Virtual Live - Attend this live instructor-led event remotely from anywhere.	Price

Show Events

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.