This website uses cookies to ensure you get the best experience on our websites. Learn more

Business professional with Microsoft Excel spreadsheets on computer screens

Live Virtual Workshop

•

3 hrs

•

4.6

(5,000)

One-Day Advanced Training for Microsoft Excel

Approved for NASBA credits

Course Outcomes Agenda Reviews FAQs

As an Excel user, you know that the software has nearly unlimited capabilities for making your job easier and less stressful. But learning the countless features available to you can be a daunting task. This LIVE, virtual workshop will teach you the most advanced features and functions Excel offers — taking your level of proficiency from mid-level to advanced. After a few hours of training, you’ll be amazed at how this powerful program can work for you.

This intensive training puts you in command of Excel’s most advanced features and functions. We strongly recommend that you be an experienced or mid-level Excel user in order to get the most out of this incredible training.

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

Course Preview

Course Outcomes

Utilize advanced Excel features to optimize data management and reporting
Create, configure and customize tables to effectively organize and present data
Summarize and analyze large datasets using PivotTables for insightful reporting
Develop and implement robust formulas with both absolute and relative cell references
Apply common functions to streamline and simplify complex calculations

4.6_{out of 5}

(5,000)

5,000

people have taken this course

99%

found this course to be helpful in their workplace

Course Agenda

3 hrs

Accreditations: NASBA credits

Live Virtual Workshop

Print Agenda

Session 1: Excel Tables and PivotTable Reports

Session 2: Absolute vs. Relative Cell References and Formatting

Session 3: VLOOKUP and Other Common Functions

Understand the most common text functions like UPPER, PROPER, MID and CONCAT
Discover how to use IF functions to make logical comparisons
Understand the purpose – and drawbacks – of VLOOKUP
Efficiently use VLOOKUP, INDEX and MATCH
How to use logical formulas (TRUE/FALSE)
Practice building formulas with functions

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 3.2 CPEs. Delivery Method: Group Internet Based. Field of Study: Computer Software & App. Prerequisites: None. Program Level: Intermediate. Advanced Preparation: None.

Event Dates & Locations

Date	Time	Price	Action

Live Virtual Workshop

Course Dates & Times

Schedule a private group trainingLearn More

Show 12 More Dates

Save when you enroll multiple attendees!

Just $189 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

Excellent instructor. He was personable and knowledgeable. He kept my interest for the full 3 hours. He knew how to keep me engaged. I have learned several things that I can immediately apply towards my job.

Jim W.

This was an amazing training. Made it very simple and was open to questions and repeating steps. I loved this training. I will surely take this training again.

Terrance M.

Great facilitator and great at presenting the information! Love how he let us understand at our own pace!

Ying C.

Course was great - I enjoyed having the Excel document to be able to practice what we are learning to make it more hands on. Thanks!

Samantha J.

Trainer was very interesting and held my interest and attention. I can use everything we went over today in my daily workflow, and I plan on learning more.

Tonya M.

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 custserv@skillpath.com 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