PC/Windows Users: Excel 2010-2013-2016-365
Course Materials: FREE
Certificate of Completion (optional): $5
Course Length: One Day
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.
CALCULATE WITH 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.
-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)
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.
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).
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.
Transpose data (switch columns and rows), fill in word patterns, date patterns, and number patterns, etc.