Learn Excel Now

Conquer the Fear of Excel

  • Home
    • Our Team
  • Training
    • Custom Training
      • Custom Virtual Group Training
      • Custom Onsite Group Training
      • Consulting Services
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
      • Simply Excel Pt. II
  • Resources
    • Contact
    • FAQ
    • New User Onboarding
  • Login

Simply Excel Pt. 2: Tips, Tricks, Shortcuts & More

Summary

This course, built in bite-size pieces, is intended for Excel users at a beginner-intermediate level. Each self-paced module ranges from 10 to 20 minutes and includes a knowledge review quiz. You will learn the most useful shortcuts, as well as all the common functions, which will empower you to work more efficiently and effectively. Additionally, we'll guide you through the best practices for formatting and analyzing your data, in a snap!


Register today, to master the basics of Excel and advance your career by discovering:
  • Time-saving shortcuts & features
  • Conditional formatting techniques
  • Keys to creating drop down lists & rules
  • Tools to identify & correct formula errors
  • Common functions: IF, SUMIF, COUNTIF & VLOOKUP
  • Step-by-step guidance for creating Tables to enhance your reports
  • & MUCH more!

Program Highlights

Module 1 - Recommended Setup & Options

  • Startup preferences for simplifying your workflow
  • Ways to customize open, resume & save settings
  • Shortcuts for saving & navigating workbooks
  • Page Setup settings & the Backstage view
  • Auto Calculate option recommendations
  • Suggested Status Bar settings

Module 2 - Simple Shortcuts, Navigation & Formatting Techniques

  • Entry & editing techniques
  • Selection & navigation shortcuts
  • Keyboard commands for quick formatting

Module 3 - Subtotal & Sort: Summarize Data in a Snap

  • Shortcuts for streamlining summation
  • Multi-level sorting techniques for organizing data
  • Group & view levels of data automatically with Outline
  • Generate reports faster with Subtotal formulas & functions

Module 4 - Excel Tables: Build Better Reports Efficiently & Effectively

  • Expert methods for creating & modifying tables for different use cases & audiences
  • Time-saving tricks to make your tables automatically adjust to new data
  • Formatting features you need to know for grouping & sprucing up data
  • Slicers: The solution for preparing user-friendly data for sharing
  • How to use Filters & focus on the metrics that matter most

Module 5 - Excel Calculations: Automate, Update & Refresh with Ease

  • Step-by-step guidance for automating simple & complex calculations
  • Workflow optimization techniques: Windows, views & layouts
  • Ways to use fill handle & formulas to auto-complete lists
  • Shortcuts & formulas for updating all sheet tabs at once
  • Relative vs. absolute references & when to use each

Module 6 – Excel Text Calculations: Shortcuts, Formulas & Functions

  • Various ways to combine data automatically from multiple columns
  • Shortcuts for splitting data – separate names in an instant
  • Copy & paste tricks that will help you work much smarter

About The Speaker

Mitzi Gibson Katz has trained thousands of end users and developed curriculum for over twenty-five years.

  • As a consultant, she specializes in the Microsoft Office suite including Excel, Access, PowerPoint, Word, Outlook and much more.
  • After teaching a variety of special education classes in Kansas, Montana, and Alaska for the early part of her career, Mitzi became interested in technology as the first personal computers were introduced to the market. She made the change in careers from public school education to private computer training and has been teaching students how to use software applications ever since.
  • Mitzi helps students understand Microsoft Applications by her passion: "It's the people part of the business that keeps me involved.

Program Benefits

Simply Excel Pt. 2 contains 6 individual training modules, each with its own video, exercise, and quiz. With the knowledge you gain from this self-paced course, you will have the ability to build better reports with increased efficiency and accuracy.

Each registration grants access to a single user.

Need to train a team, or an entire organization ? Call 1-800-964-6033 for group pricing today!

Simply Excel Pt. 2: Tips, Tricks, Shortcuts & More

$349 + applicable taxes
Add To Cart

Chat with somebody about our All Access Subscription for individuals or groups:

Live Chat
or call us now
1-800-964-6033

Simply Excel Pt. 2: Tips, Tricks, Shortcuts & More

$349 + applicable taxes
Add To Cart

To discuss custom programs, group rates, or to ask questions, contact us:

Live Chat
or call us now
1-800-964-6033

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.