Excel - Excel Essentials and Formulas

This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organize, calculate, analyze, revise, update, and present your data.

Excel - Excel Essentials and Formulas

Skip to Available Dates

Learning Objectives

Upon successful completion of this course, you will be able to create and develop Excel 2016 worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organization.


Course Details

Course Outline

1 - Getting Started with Excel 2016
  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter and Edit Cell Data
  • Fill Cells with Series of Data (AutoFill and Flash Fill)
  • Use Excel Help
  • 2 - Performing Calculations
  • Create Worksheet Formulas
  • Insert Functions and use Autocomplete
  • Reuse Formulas and Functions
  • Create an Absolute Reference
  • 3 - Modifying a Worksheet
  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Move and Copy Data between Cells
  • Search for and Replace Data
  • Use Spellcheck and Proofing
  • 4 - Formatting a Worksheet
  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply and Copy Cell Styles
  • Apply Basic Conditional Formatting
  • 5 - Printing Workbooks
  • Preview and Print a Workbook
  • Controlling Page Layout
  • Adding Headers and Footers
  • Set Print Titles and Print Ranges
  • 6 - Managing Workbooks
  • Manage Worksheets
  • Insert and Delete Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties
  • Actual course outline may vary depending on offering center. Contact your sales representative for more information.

    Who is it For?

    Target Audience

    To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows 10 environment and be able to manage information on their computers.

    Excel - Excel Essentials and Formulas

    Course Length : 1 Day

    1. Choose a Date | 2. Click Enroll Now [G2R=Guaranteed to Run]

    Search All Dates

    Next 4 available dates:

    ... More Dates
    Need Help Picking the Right Course? Give us a call! 01 8898700