IconLogoc IconLogoc

Excel Tips and Tricks Training

Excel Tips and Tricks Training

Course Date Course Time Price Seats
Dec 14 2020 3pm - 4pm ET

Microsoft Excel Tips and Tricks Training

Excel is such an amazing and powerful software program, it’s easy to be overwhelmed by all of its capabilities! But even advanced users can be working smarter if they know some tips, tricks, and shortcuts! In this MS Excel tips and tricks training, we'll explore ways to work smarter and more efficiently in Excel.

Who should attend this class?

Anyone who has some working knowledge of Excel. You don’t have to be a power user, but being comfortable in the Excel environment is beneficial. Any version of Excel will work, although not all shortcuts will work in all versions.

Where is this class held?

This is a live, online class led by a field expert; and just like an in-person class, it is fully interactive and engaging. The difference between an online and onsite class? No travel! You can participate from anywhere in the world with an Internet connection. Many of our students choose to stay home from work on these training days, some never even changing out of their slippers! Where applicable, students are able to speak with and hear from the instructor and other participants throughout the course as they work in real-time to complete activities.

Need something a little more personal?

We understand your team might have specific training needs and we would love to work with you. We offer both online and on-site instructor-led, fully customizable courses tailored to your training needs.

Email us so we can discuss your needs and set up your custom training »

Anyone who wants to learn more about the formatting of a website. All you need is a basic text editor such as Notepad (PC) or TextEdit (Mac) and a browser. Knowledge of basic HTML codes is mandatory.

Topics covered include, but not limited to:

  • Customizing the Excel environment

From the Quick Access Toolbar to default settings, we will cover them all!

  • Navigation and Selection shortcuts

Workbooks can be huge, and scrolling is not the most efficient way of navigating! Join us to find out how to quickly and easily navigate thousands of rows and select an enormous database.

  • Freeze Panes/Print Titles

Learn how to freeze headings on the screen so you always know which column you are in. If you need those headings to print, you have to know about Print Titles!

  • Flash Fill, AutoFill, and Custom Lists

See how to quickly fill in a lot of data with a single drag of the mouse! (Flash Fill is in Excel 2013 and later.)

  • Group Mode
  • If you use multiple sheet files, you have to know about Group Mode! Group Mode allows you to quickly enter and format data on multiple sheets in one step!

  • Quick Analysis Tool
  • Not sure how to best format your data? The Quick Analysis Tool lists all the options in one easy-to-find place! (Quick Analysis Tool is in Excel 2013 and later.)

    About Your Instructor

    Rosemary McCracken is a computer trainer with over 25 years of experience in the classroom. She teaches all levels of Microsoft Word, Excel, PowerPoint, Access, Visio, and Outlook. In addition to Microsoft products, she also teaches QuickBooks, InDesign, HTML/CSS, and WordPress. Rosemary has a B.S. from James Madison University. She is Microsoft Office Expert Certified and is also a Certified Online Training Professional.

    Be the first to review this course.

    Write Your Own Review

    Only registered users can write reviews. Please, log in or register

    Wonderful pace. Jennie Ruby is a skilled instructor. Loved the hands-on practice activities and the guided presenter active learning.
    Jessica Rogozinski