at Computers Etc Software Training Center - Miramar
Fri, Jun 02, 9:00am - 4:00pm Pacific Time
3 people saved this classGive as a Gift Book as Private Event
Recommended for anyone who hasn't worked with formulas or charts before or those with little or no experience with Excel. Great refresher course for students who haven't used Excel in a long time. Learn how to navigate the Excel user interface. Customize the Quick Access Toolbar to include your favorite commands. Learn many keyboard shortcuts that will speed up common tasks. Create, Open, Close, Save, Preview, and Print a variety of different spreadsheets. Spreadsheet design principles and "best practices" will also be covered. Lots of tips and tricks are included so you'll know how to get the most out of Excel.
What you will learn:
FORMULAS AND FUNCTIONS:
Use AutoSum to add numbers. Use Formulas to add, subtract, multiply, and divide numbers, calculate percentages. Learn how to AutoFill (copy) Formulas. Understand cell references in formulas so you can perform basic calculations. Much of the class will be devoted to creating formulas.
Add borders and background colors to cells, center, bold, italicize, and change font/font size. Learn the 6 most common number formats, including currency and percentages.
Select, copy, move, format, and delete text and numbers. Insert and delete sheets, columns, and rows. Resize columns and rows. Sort data. Add graphics and SmartArt diagrams, rename a spreadsheet tab, change tab colors, etc.
CHARTS & GRAPHS:
Create and Edit a variety of different dynamic (automatically updating) charts, change chart types, apply Styles and Layouts to charts, format individual elements in a chart, etc. Create Sparkline charts (small charts that occupy a single cell).
WORKING WITH LARGE SPREADSHEETS:
Use Freeze Panes so column and/or row headings always remain visible as you scroll. Hide / unhide columns and / or rows. Learn about various printing options, including how to fit everything on one page. Make titles (column headings) print on every page. Add headers and footers, page numbers, logos, etc.
Fill in word patterns, date patterns, and number patterns, etc.
Still have questions? Ask the community.
Transfer Policy: You can transfer free-of-charge to another class provided that you give us at least 24 hours advance notice by phone or e-mail. You can also send someone else in your place. Please inform us who will attend the class.
Refund Policy: If you feel a class isn't right for you, just let the instructor know during the first break. We will issue a full-refund, transfer you to another class, or issue a full credit for the class - Your choice. You must inform the instructor during the first break!
Computers Etc Software Training Center
6920 Miramar Road Suite 206
San Diego, California 92121 Miramar
6920 Miramar Road Suite 206
San Diego, California 92121
From 805: Go east on Miramar Road. Look for Jack in the Box, Flooring Wholesalers, and Starbucks. Turn left at stoplight onto Production Ave and continue just past railroads tracks. Turn left into parking lot. Do not park in reserved spaces. From 15: Go west on Miramar Road. Look for Jack in the Box, Flooring Wholesalers, and Starbucks. Turn right at stoplight onto Production Ave and continue just past railroads tracks. Turn left into parking lot. Do not park in reserved spaces.
Don't see a date that works for you?Save to WishList
Get quick answers from CourseHorse and past students.
Computers Etc. was founded in 1992. We teach popular computer programs such as Access, Excel, Outlook, PowerPoint, Word, and QuickBooks. Over 25,000 students have attended our computer classes over the years. Our mission is to offer the finest computer classes at the lowest possible prices. From the...
Read more about Computers Etc Software Training Center
This school has been carefully vetted by CourseHorse and is a verified San Diego educator.
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.