Excel Tips and Tricks
CTU-EXCELTIPS-C





Official Program Description

Excel Tips & Tricks


For a full color brochure, click here. This is a PDF file which requires Adobe Reader; to download a free copy of Adobe Reader, click here.

This seminar will give you techniques that are guaranteed to increase your productivity with Microsoft Excel 2010/2013. Participants will cover Excel's formulas and functions with advanced instruction on the most useful methods for automating reports. The seminar will impart shortcuts and tips for preparing outstanding presentations using Excel charts. And, participants will be able to see how to use Excel macros to automate spreadsheet work. The best thing about this seminar is that it's taught in layman’s terms – not “geek-speak!” 

Who Should Attend

This class is for Excel users who are interested in learning shortcuts, tips, and techniques for increasing productivity.

Prerequisites

A solid understanding of basic and intermediate Microsoft Excel is needed.

Attend and You Will Learn

Timesaving Methods for Building a Worksheet

  • Personalizing the Excel Environment with the QAT and Ribbon
  • Using Excel Options to Customize Your Work Environment
  • Seven Steps to Spreadsheet Success 
  • Basic List Rules to Keep You Sane 
  • Paste with Live Preview
  • Data Validation as a Self-Defense Move 

Creating Attention Grabbing Excel Reports

  • Sorting to Bring Order to Madness 
  • Custom Lists for Greater Flexibility 
  • Conditional Formatting
  • Filtering to Get Immediate Answers
  • Subtotals – Done Automatically For You 
  • Using the Auditing Tools to Track Problems 
  • The IFERROR Function for Better Error Handling 
  • Using Goal Seek to Find Desired Solutions 

 Combining Data with Ease and Accuracy

  • Shortcuts for Working with Worksheets and Workbooks 
  • Linking Data Across Workbooks Effortlessly 
  • Consolidating Data Across Workbooks with Active Links 

Functions that Save Time and Add Pizzazz

  • VLOOKUP for Expert Search Capabilities
  • The IF Function for Basic Decision Making 
  • The SUMIF Function for One Criterion Math Decisions 
  • The SUMIFS Function for Multiple Criteria Math Decisions 
  • The LEFT, RIGHT and MID Functions for Data Display 
  • Extremely Useful Date and Time Functions 
  • Using Macros to Expedite Analysis 

 Amazing Chart Ideas that will Get You Noticed

  • The Fastest Way to Create a Chart 
  • Positioning Multiple Charts
  • Linking Chart Titles to Worksheet Cells 
  • Sparklines
  • PivotTables for Easier Analysis
  • Slicers
  • PivotCharts for Better Visuals 
  • Wrap Up 


Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.