Brownwood - Excel for the Business Professional 5/27/2020 (Level 1)
NON-MEMBER PRICE: $169.00
CHAMBER Member Price - $149.00 (Use the coupon code save20)
6.5 hours (1 day)
8:30 a.m. – 4:00 p.m.
One-hour break for lunch and a 15-minute morning and afternoon break.
Brownwood Chamber of Commerce – Board Room
600 E Depot St
Brownwood, TX 76801
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:
- 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
- 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
- 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.
Who Should Attend?
Anyone who wants to learn Excel.
Class must be canceled 5 days before start date
|Event Date||05-27-2020 8:30 am|
|Event End Date||05-27-2020 4:30 am|
|Cut off date||05-27-2020|
|Location||Brownwood Chamber of Commerce – Board Room|