ONLINE - Excel for the Business Professional 11/17/2020 (Level 1)

Length/CPE Hours

CPE 6.5 hours

Class Time

9:00 a.m. – 4:00 p.m.
30-minute lunch break.

Method of Delivery

This class will be held online using GoTo Metting.  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 GoTo Metting 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 GoTo Metting subscription to participate.  

The web browser client will download automatically when you start or join your first GoTo Metting 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 great keystrokes to improve your speed. You will learn how formatting effects the way a cell looks but not its value. We will also look at how to overcome certain print issues. Have you been using a spreadsheet that someone else designed but you don’t know how they created the formulas? In the class, you will learn:

Excel Basics

  • Understand the Excel screen and modify the Quick Access toolbar, Ribbon and Status Bar
  • Enter and Edit Data and Understand Excel modes
  • Learn the difference in Clearing Content, Formats, Comments and more
  • Effective Shortcuts and Keystrokes

Creating a Spreadsheet

  • Create Basic Formulas that add, subtract, multiple or divide
  • Learn to Work with Functions such as =SUM() and =AVERAGE()
  • Move and Copy Data
  • Insert Rows and Columns
  • Move and Copy Data – Understand the Clipboards
  • Use Fill Series and Flash Fill
  • Adjust Column Width and Row Height

Formatting Techniques

  • Learn how to Format Cells using various methods
  • Work with the Dialog Launcher and Dialog Boxes
  • Use Number and Text Alignment
  • Learn the various Number Formats
  • Learn to Copy or Repeat Formats
  • Work with Format Painter

Printing Solutions

  • Learn Tips and Tricks for Printing
  • Understand the Page Setup options
  • Create and Set Print Areas

Quick Look at Charts, Sorting and Filtering

  • A Quick Preview of how to Create a Chart.
  • A Quick introduction into basic Sorting and Filtering
  • Who Should Attend
  • Anyone who wants to learn Excel.

Prerequisites

None

Cancellation Deadline

For class fees paid directly to Cloud Training Services a person must cancel by the class deadline to receive a full refund. The cancellation deadline varies based upon location but it usually 5 to 10 days prior to the class. The cancellation deadline is stated at the top of this page.

If you are unable to attend and do not cancel prior to the class, you may send a substitute. Cloud Training Services will consider emergency situations such as a death in the family, illness and weather, and will make every attempt to work with the person in the event of an emergency.

Note

Cloud Training Services partners with other training vendors such as Odessa College and New Mexico Junior College and has no control over payment and registration process. When the registration fees are paid to another agency or vendor, the cancellation and refund policy will be those of that agency or vendor.

Event Properties

Event Date 11-17-2020 9:00 am
Event End Date 11-17-2020 4:00 pm
Capacity 14
Registered 0
Available place 14
Cut off date 11-17-2020 8:00 am
Individual Price $139.00
Location ONLINE

Group Rate

#Registrants Rate/Person($)
3 119.00