2 Hour Live Training on 10 must know tips and tricks for efficiently using Microsoft Excel

About the Course

In this course, you will learn a minimum of ten tips and tricks for efficiently using Microsoft Excel. You will learn how to create ‘templates’ to save you time and easily have a professional-looking spreadsheet plus turn your spreadsheets into templates for using again. We will use formulas and utilize the ‘absolute referencing’ technique to streamline your spreadsheet formula, this will refer to the cell address that locks that row or column in the formula, so it won’t change when copied. We will use a tool available in all versions of excel for coping date, speed up data entry with ‘flash fill’, and built-in ‘custom lists’ that you will learn how to customize for your use.  Learn how to insert and delete rows, columns, and cells without creating a new spreadsheet. Learn to print titles on every page of your spreadsheet without inserting unnecessary rows and columns. We will learn how to work with ‘Conditional Formatting’ and how to work with ‘Tables’ inside of your spreadsheets. Top this all off with the ease of using ‘Pivot Tables’ and easily interact with your data and use magic within your spreadsheets not to mention the amount of time these tips and tricks will save you in your workday.

Course Objective

How to use and create Templates

When to use Absolute and Relative References in a Formula

Using, AutoFill, Flash Fill and Custom Lists

Paste Special

Work efficiently with Rows and Columns

Printing Secrets(Print Optimization)

Conditional Formatting

Turn on AutoFilters and convert your data into Tables

Ease of Pivot Tables

Shortcut Keys – Most useful for Mouse and Keyboard

Who is the Target Audience?

Everyone with basic knowledge of using Excel

Basic Knowledge:

Basic Experience in MS Excel