2019 Workshop: Microsoft Excel Tips & Tricks, Part 1 3/26/19

  • Share:
Name: 2019 Workshop: Microsoft Excel Tips & Tricks, Part 1 3/26/19
Date: March 26, 2019
Time: 9:00 AM - 11:00 AM EDT
Registration: Register Now
Event Description:

Excel Tips and Tricks, Part 1

This workshop contains a variety of quick tips and tricks in Microsoft Excel that will save you hours of time!  You'll learn how to add buttons to the Quick Access Toolbar, so the commands you want are at your fingertips. You'll learn how to view all the formulas in a worksheet and how to freeze rows and columns for easier viewing and navigation. You'll practice time-saving shortcuts for selecting, moving, and copying cell, and you'll learn how to use Autofill to create a series of numbers or dates or to copy formulas.
You'll review basic formulas and functions, including the order of operations, absolute references, and AutoSum.  You'll learn to fix formatting problems easily with the Format Painter, and how to deal with formatting annoyances like zip codes, centering titles, date formats, etc. The class will also cover sorting and filtering lists, including custom sorts on more than one level.
You'll also practice using Excel's extensive (and sometimes confusing) cut and paste options, and learn how to copy from Excel to Word as text or as a link that updates automatically. You'll practice preparing a spreadsheet for printing, including setting the print area, scaling, and adding headers and footers. The workshop will also cover new features, such as Flash Fill, Quick Analysis, and "Tell Me" Help. A complete list of keyboard shortcuts is also included.

Quick Access Toolbar

Viewing Your Spreadsheet

Freezing Rows and Columns

Viewing All Formulas

Using AutoFill

Filling in a Series of Numbers and Dates

Copying Formulas

Selecting Cells and Ranges

Moving Cells and Ranges

Formulas and Functions

Entering Cell References

Order of Operations

Using Absolute References

AutoSum

Average

Min / Max

Formatting a Spreadsheet

Delete vs. Clear All

Centering Titles

Formatting Zip Codes

Format Painter

Sorting and Filtering

Custom Sorts

Cut, Copy and Paste

Paste Options

Pasting Values

Pasting into Word as Excel Object and Link

Printing

Setting the Print Area

Page Layout View

Adding Headers and Footers

Page Break Preview

Scaling a Spreadsheet

New Features

Flash Fill

Quick Analysis

"Tell Me" Help

Quick Shortcuts

Keyboard Shortcuts


Pre-registration is required; space is limited.

To Register:  https://goo.gl/forms/pX8YUuC25YdMsLjD2


 
Location:
Northampton Chamber of Commerce
99 Pleasant Street
Northampton, MA
Date/Time Information:
March 26
9:00 - 11:00 am
Fees/Admission:
$25 Members
$35 Non-Members
RSVP required, space limited
Set a Reminder:
Enter your email address below to receive a reminder message.
Please complete the Captcha