Excel – Excel Essentials and Formulas

New Horizons UK

Excel – Excel Essentials and Formulas

65 65 people viewed this event.

Course Overview 

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.

Schedule 

See the source image

Date:

TBD

See the source image

Time:

TBD

See the source image

Duration:

7 hours

See the source image

Price:

GBP 197 + VAT per attendee

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 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
 
 
 
 
 

 

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.

Additional Details

Price - 197

Duration - 7

 

Date And Time


 

Location

 

Venue

Live Online (Zoom)
 

Event Category

On-Demand

Share With Friends