Excel Level 1 - APHL (Private Class)

CLASS TIME

12:00 PM – 5:00 PM (EASTERN TIME)

APPROXIMATE BREAK TIMES

2:00 PM – 2:15 PM
3:45 PM – 3:55 PM

Method of Delivery

This class will be held online using GoToMeeting.  Class participants will receive a PDF of the book and will be able to access the class files online.

When you register, be sure to use the email that you would like your GoToMeeting invitation sent to.  The meeting invitation will be sent no later than 1 hour prior to the class. Check your junk mail if you do not receive an invitation, especially if you have a Gmail or Hotmail account.  You do not have to have a GoToMeeting subscription to participate.  

The web browser client will download automatically when you start or join your first GoToMeeting meeting and is also available for manual download here.

https://www.gotomeeting.com/

It is a good idea to download this prior to the online meeting.

COURSE DESCRIPTION

This class is designed for the student who wants to learn how to build a spreadsheet from scratch using basic formulas. In this class you will learn how to navigate large spreadsheets and use keystrokes to improve your speed. You will learn how formatting effects the way a cell looks but not its value. Have you been using a spreadsheet that someone else designed but you don’t know how they created the formulas? This class is for you. Although this class is designed to teach basic concepts, intermediate users often take the class and learn a lot of shortcuts and tips that will help them "fill in their knowledge gaps".

EXCEL BASICS

• Overview of Excel
• Understand how to modify the Quick Access toolbar, Ribbon and Status Bar to improve access and speed.
• Enter and Edit Data and Understand Excel modes – Ready, Enter, Edit Modes.
• Learn various methods of entering data and how each method can help based on the circumstance.
• Perform basic calculations such as Add, Subtract, Multiply or Divide
• Copying Using Fill Handle
• Learn to Work with Functions such as SUM, AVERAGE, MIN, MAX, COUNT, AND COUNTA
• Move and Copy Data – Understand the Office and Windows Clipboards
• Understand Paste Options such as Paste Value or Paste Column Widths
• Insert Rows and Columns
• Hide Columns and Freeze Panes
• Saving your work – Save vs Save As, Saving as .txt, csv or .pdf
• Identify Effective Shortcuts for Navigating documents, selecting large data sets and columns of information. Also learn shortcut keystrokes for common tasks.

FORMATTING OPTIONS

• Learn how to Format Cells using various methods
• Use Number and Text Alignment Formats
• Work with Notes (Office 365) and Comments (All Versions)
• Learn the difference in the Delete key verses Clearing Content, Formats, Comments, etc.
• Work with Dates and Understand Date Formatting
• Use Format Painter and F4 to Copy Formats or Repeat Actions
• Use Fill Series and Flash Fill

SORT AND FILTER

• Best Practices on How to Set up the Data
• Sort using Quick Sort and Data Sort
• Turn on and off Filters
• Filter using various methods.

PREREQUISITES: None