Beginning Excel Class in San Diego
This class is intended for:
PC/Windows Users: Excel 2016-2019-365
Certificate of Completion (optional): $5
Course Length: 1 Day
Excel Basics:
This Excel class is 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.
Excel Formulas:
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.
Excel Functions:
- Average (average a range of cells)
- Max (display highest number in a range cells)
- Min (display lowest number in a range of cells)
- Sum (sum or total of a range of cells)
Format a Spreadsheet:
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.
Edit a Spreadsheet:
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.
Excel Charts:
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).
Work 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.
Student Feedback:
“I just want to say how great the class was for me (Beginning Excel). I had known I was "falling behind" the pack for the past couple years. My computer skills were antiquated. Your teaching method; a non-threatening atmosphere and your undying desire to help the student learn is why I'll be back to your company. I am still in denial that we learned so much in half the time the others were charging double for.”
Raul D.
FAQ
How much does San Diego Excel training cost? $250 per student per class. Package deals and volume discounts are available.
When are Excel classes available? Most classes meet one time from 9AM-4PM on a weekday. Saturday classes are also available.
Are these Excel classes in-person or on-line?" Most Excel classes meet in-person at our Miramar classroom, although we also offer on-line Zoom classes.
Call 858-578-9476
Computers Etc. Software Training Center, Inc.858-578-9476