Business professional working on a laptop using Microsoft Excel

Live Virtual Workshop

•

2 days

•

4.5

(1,000)

Advanced Microsoft Excel Techniques

Approved for NASBA credits

Course Outcomes Agenda Reviews FAQs

You may use Microsoft Excel daily, or maybe only casually, but one thing’s for sure — you’ve probably wished you knew more about this dynamic program. That’s why you’ll want to attend this two-day Excel workshop. In it, you’ll learn ways to make your job easier and increase the sophistication of your data reporting and analyzing. Each Excel advanced training session focuses on saving-you-time techniques, advanced “how-to’s,” exploring those previously “programmer only” features and more. Along with this practical and usable training, you’ll learn how to integrate your work within the Office suite for even greater results. If you’ve ever been frustrated using Excel because you knew there had to be a better way of accomplishing your tasks, you’ll soon be on your way to getting more done — more efficiently — with this power-boosting workshop. Enroll today!

For an optimal experience with this course, we recommend Excel 2016 and later. Windows platform preferred.

Course Outcomes

Time-saving techniques that’ll allow you to get your work done faster with Excel
Effectively utilize charts to visually communicate your data
Build interactive forms with Excel, ensuring data quality with forms controls
Use built-in visualizations to communicate data effectively
Efficiently analyze data and make recommendations using Scenario Manager, Goal Seek and other tools
And much more!

4.5_{out of 5}

(1,000)

1,000

people have taken this course

100%

found this course to be helpful in their workplace

Course Agenda

2 days

Accreditations: NASBA credits

Live Virtual Workshop

Print Agenda

Day 1

Session 1: Time-Saving Techniques — Understanding Essential Power Shortcuts and Functions

Session 2: Charting Essentials

Session 3: Mastering Forms, Form Objects and Templates

Day 2

Session 1: Data Visualization Techniques

Session 2: Powerful Data Analysis Tools

Use formula auditing tools when you’re the original author of a workbook
Experiment with different inputs and compare the outputs using Scenario Manager
How to work backwards from a desired result using Goal Seek
Harness the Solver to help schedule employees while controlling payroll
Use the Descriptive Statistics tool to calculate details about a population of numbers instead of writing many formulas
Forecast sales and expenses based on historical patterns using the Forecast tool and Excel’s Analysis ToolPak

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.

SkillPath, the Graceland College Center for Professional Development and Lifelong Learning, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors on its website: www.nasbaregistry.org. SkillPath's Sponsor ID number is 146710. This course qualifies for 6.4 CPEs. Delivery Method: Group Internet Based. Field of Study: Computer Software & App. Prerequisites: None. Program Level: Advanced. Advanced Preparation: None.

Event Dates & Locations

Date	Time	Price
Feb 6-7	3:00 PM-6:00 PM UTC	^$399
Feb 6-7	7:00 PM-10:00 PM UTC	^$399
Feb 20-21	3:00 PM-6:00 PM UTC	^$399
Feb 20-21	7:00 PM-10:00 PM UTC	^$399
Mar 6-7	3:00 PM-6:00 PM UTC	^$399
Mar 6-7	7:00 PM-10:00 PM UTC	^$399
Mar 13-14	2:00 PM-5:00 PM UTC	^$399
Mar 13-14	6:00 PM-9:00 PM UTC	^$399

Live Virtual Workshop

Course Dates & Times

Feb 6-7Thu | 3:00 PM-6:00 PM UTC

Feb 6-7Thu | 7:00 PM-10:00 PM UTC

Feb 20-21Thu | 3:00 PM-6:00 PM UTC

Feb 20-21Thu | 7:00 PM-10:00 PM UTC

Schedule a private group trainingLearn More

Show 4 More Dates

Save when you enroll multiple attendees!

Just $349 per person when you enroll 4+ learners

Included in
SkillPath Unlimited+Live

^$ per year

Access this course and 6000+ other live virtual workshop sessions(includes live virtual events priced $399 or less)
500+ webinars broadcast daily
2,000+ on-demand resources
And so much more!

More Courses in

Live Virtual Workshop Business & Technology

Participant Takeaways

Trainer was excellent. The workbook he created was extremely helpful and being able to do the exercises with him helped me retain the knowledge much better than just lecturing. Great class, highly recommend.

Randelyn S.

Great instructor always follows up if we are following the slides on the spreadsheet. I learned more than what I expected from this course. thank you.

Guen C.

I appreciated the pace the instructor set. I was able to learn, interact and take notes . I also really like that it gives and email to contact him and ask questions in the future about things learned in this course.

Lucy H.

Excellent course & the trainer did a fantastic job walking us through the course content and explaining the steps.

Monica V.

Our facilitator was awesome. He made everything clear and paced each lesson.

Maria C.

FAQs

How does a virtual seminar work?

A virtual seminar is a live, instructor-led experience. One or two days before the actual date of your seminar (also referred to as a course or workshop), you’ll receive an email with a link and a unique registration ID you’ll use to connect to the training. It will also include an additional link to the course materials along with any additional instructions you’ll need.

About 15 minutes before the scheduled start of your workshop, you’ll be able to log on from your computer, laptop, tablet or smartphone and join the event. Your unique registration ID may only be used once.

To ensure you have the best experience possible, please make sure your system has the necessary components. You can check your system now by following this link: Click here. Note: Please disable any pop-up blockers before testing your system.

Why should I choose virtual training?

Do you offer closed captioning?

What happens if I register, and then something comes up and I have to cancel?

We understand that occasionally things happen beyond your control, making cancellation unavoidable.

CANCELLATION POLICY: Cancellations occurring 5 business days or less before the event will be eligible for a one-time transfer to a future event. Refer to the confirmation number received upon registration and notify us by email at [email protected] or call us at 1-800-873-7545 prior to the date of the event. Post-event cancellations will be ineligible for transfer and the registrant will be liable for the entire course fee.

What happens if I get disconnected during the seminar?

How do I contact Customer Service?

Related Courses