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
Share This Post
Have your say!
0 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>