Lubbock Excel for the Business Professional 5/21/2019 (Level 1)

Length

7 hours (1 days)

Class Time

8:30 a.m. – 4:30 p.m.

Location:

Lubbock Classroom
Melonie Park Meeting Space
3502 74th Street
Lubbock, TX 79423

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

Class must be canceled 5 days before start date

Class Information

Class date: 05/21/19
Class end date: 05/21/19
Seats Remaining: 5
Cut off date: 05/21/19
Individual Price: $169.00
Location: Lubbock Classroom

Group Rate

No Number registrants Rate/Person($)
1 3 149.00
Share this class: