2 Hour Live Training on 10 must know tips and tricks for efficiently using Microsoft Excel
Training TypeLive Training
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.
How to use and create Templates
When to use Absolute and Relative References in a Formula
Using, AutoFill, Flash Fill and Custom Lists
Work efficiently with Rows and Columns
Printing Secrets(Print Optimization)
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 Experience in MS Excel