Excel Tips Techniques and Shortcuts - Excel Training

EXCEL

Microsoft® Excel –

Tips, Techniques, and Shortcuts

Course Description

This one-day workshop, designed for intermediate Excel users who want to enhance their skills, covers all versions of Excel for Windows and Macintosh users.

Course Objectives

After completing this skill-boosting workshop, participants will have the tools, tips and techniques needed to become an Excel "power user."

· Cut the time it takes to build every worksheet

· Find out the most underutilized Excel tools and why you should use them

· Discover how to customize Excel's toolbars for the way you work

· Create more intelligent worksheets

· Master essential techniques for creating eye-catching charts and tables

· Discover how to effortlessly link worksheets to avoid rekeying shared information

· Learn how to transform any list into a useful

Excel database

Who Should Attend

Anyone who's mastered Excel's fundamentals and wants to acquire the tools to become a "power user." Bring onto your site or our Bellingham training facility.

Course Overview

Designed for the majority of Excel users who know the program fundamentals, this one-day workshop, Mastering Microsoft® Excel, teaches participants the tools, tips, techniques and shortcuts needed to increase efficiency and productivity.

The hands-off training approach incorporates state-of-the-art visual demonstration and group interaction to thoroughly explore the features and functions of this application.

Expand skills, maneuver more easily in the program and better utilize its many functions and features. A special section on macros completes this informative day of training.

Take your skills to an even higher level when you stay one more day for Advanced Microsoft® Excel for the Power User.

Trade in your time-consuming habits for razor-sharp Excel skills to speed you through any task.

· Discover easier ways to maneuver around in Excel

· Learn to easily link Excel worksheets to avoid errors and wasting time

· Find out how to create a Pivot Table

· Analyze data more easily with Excel

· Master shortcuts to improve speed and productivity

· Learn the types of mathematical functions Excel performs and how to do each

· Take a list and turn it into a database on Excel

· Create eye-catching spreadsheets that are easy to read and understand

· Manage enormous spreadsheets so they're easy to work in

· Learn Excel features to help with budgets, invoices and other routine computing needs

· Produce templates with Excel to increase productivity

· Customize your toolbar and formula bar to improve your work speed on the type of worksheets you create most frequently

· Learn rules of thumb to improve your chart's appearance without spending a lot of time on it

EXCEL

Microsoft® Excel

Go Beyond Mere Basics, Become a Power Excel User!

AGENDA

1. The Key to Spreadsheet Success: Getting Off to a Good Start

· Navigate Excel menus like a pro

· Learn time-saving keyboard shortcuts

· Learn to save documents as templates

· Protect your data in case disaster strikes

2. Formulas and Functions

· Find out how to use the VLOOKUP and HLOOKUP functions

· Learn to back yourself out of mistakes

· Spot potential formula goofs

· Calculate percentages, statistics, interests, averages, dates and more

· Know how to use logical and IF functions

3. Lighten Your Load With Multiple Worksheet Links

· Create a linking formula with our guidelines

· Save valuable time by moving rapidly among multiple worksheets

· Reduce chances for errors by linking instead of rekeying data

4. The Path to Print Perfection

· Avoid the most common Excel printing goofs

· Learn to add headers, footers and page numbers

· Create recurring titles without rekeying them

· Find out the easy way to print worksheet selections — and get what you ask for

5. High-Impact Spreadsheets, Charts

and Graphs

· Learn a variety of chart formats

· Create impressive charts in minutes

· Add free-form narrative and graphics to your worksheets to facilitate understanding

· Alter the plot direction on a chart

· Change the data source on a chart

· Learn to use and disable the time-scale axis

6. Creating Custom Toolbars, Menus and Dialog Boxes

· Replace duplicated efforts with a single menu or toolbar command

· Record a macro in your customized toolbar

· Customize your toolbar in four quick steps

· Simplify data entry by limiting menu and dialog box choices

7. Analyzing Data and Database

How To's

· Perform a what-if analysis using the

Scenario Manager

· Understand and use one- and two-variable

data tables

· Use Solver to solve problems by

working backwards

· Examine the association between cells and formulas in a worksheet with the

Auditing Toolbar

· Trace cells that cause errors

· Create a Pivot Table to quickly summarize large amounts of data

· Learn the fundamentals of creating

Excel databases

Special Section: Macros

· Get two powerful reasons to use macros from now on

· Record a simple macro in five steps

· Develop your own personal macro file to keep your macros organized

· Automate your worksheets and kick into the "instant reply mode"

· Know when to use Excel macro language and when to use Visual Basic

· Create a macro toolbar customized with the shortcuts you use most often

· Avoid input errors using macros

-----------------------------------------
Excel training, Excel tips, Excel workshop, Excel shortcuts, Excel seminars, Microsoft Excel Training, Microsoft training, Microsoft workshops, computer training, computer seminar, computer workshop, Bellingham excel, Excel Tips Techniques and Shortcuts, intermediate excel user