EXCEL 2013 – 2016 – 2019 BASIC COURSE – ONE DAY

Prerequisites

Basic Computer knowledge- No excel experience needed

Course overview

Students will gain the knowledge the skills and the confidence to create, format, enhance and print simple spreadsheets.

Instruction will be personalized by version. Students have the option to progress through the course using Microsoft Excel 2010, Microsoft Excel 2013, or Microsoft Excel 2016.

Goal

Become Familiar & Friendly with Excel, enter and format data, create charts, print a worksheet

Excel Basic Topics

1. What is Excel?
2. OpenExcelSampleFiles
3. ExcelInterface
4. Adding Buttons to QAT
5. Customizing the Ribbon
6. OpenWorkbook(New-Existing-Temp)
7. Saving a workbook
8. Data Selection & Navigation
9. Dealing with Columns & Rows
10. Dealing with Worksheets
11. Split & Freeze
12. Enter, Edit & Delete (5 methods for entering data)
13. Find, Replace, Proofing
14. Copy, Cut & Paste (Perform calculations by pasting)
15. Formatting (4 different types of Formatting in Excel)
16. Styles & Themes
17. Conditional Formatting
18. Basic Formulas
19. Basic Charting
20. Printing: Page Layout – Header
21. Page Break Preview
22. Getting Help with Excel