*VIRTUAL* – MS Excel 2016 – Level 1

Request info

Online Microsoft Excel Training

Course Duration: 1 day

Course

In this virtual, Instructor-Led course you will create and edit basic Microsoft Excel 2016 worksheets and workbooks.  You will learn all the basics you need to start entering your data and building organised workbooks.

Course Aim

Enable delegates to examine the basic components of Excel 2016 and learn how to create and use formulas.

Target Student:  Anyone requiring basic knowledge of Excel 2016.

Prerequisites: Delegates should be familiar using a computer/laptop within a Windows environment.

Objectives:

  • explore the Excel Environment
  • create a basic worksheet
  • modify a workbook/worksheet
  • use basic formulas and functions
  • format an Excel worksheet
  • manage worksheets and workbooks
  • set up printing options

Getting Started with Excel 2016

  • Excel and the Excel Environment
  • Back Stage view and Themes
  • Navigate and Select in Worksheets
  • Create a Basic Workbook
  • Open, Save and Close Workbooks
  • Use Tell Me and Smart Lookup

Modifying a Workbook

  • Cut, Copy and Paste Commands
  • Flash Fill
  • AutoFill Options and AutoComplete
  • Find and Replace
  • Spelling
  • Undo and Redo
  • Insert and Delete Options
  • Column Width and Row Height
  • Hide and Unhide Options

Formatting an Excel Worksheet

  • Font Group
  • Add Borders and Fill Colours
  • Cell Alignment
  • Number Formatting
  • Cell Styles and Galleries

Using Formulas and Functions

  • Create Relative Formulas
  • Mixed Cell References
  • AutoCalculate
  • Inserting Functions
  • Use AutoSum
  • Copy Formulas
  • Create Absolute Formulas

Managing Worksheets and Workbooks

  • Manage Worksheets
  • View Worksheets and Workbooks

Printing Options

  • Print Pane
  • Print Worksheets and Workbooks
  • Page Setup
  • Print Layout View

Cost: £150 + Vat

 

 

 

Live Virtual Excel 2016 Training

Online Excel 2016 Training Course

Excel 2016 virtual training course.

Excel 2016 Online Training course.

MS Excel 2016 training

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2021-12-03' ) ) AND wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (18012) AND wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC

Scheduled Courses:

    2022
    DateCourse NameLocationPrice (Excluding VAT)Book
    25 Jan*VIRTUAL* – MS Excel 2016 – Level 1Online - Remote£175Enquire Now
    21 Sep*VIRTUAL* – MS Excel 2016 – Level 1Online - Remote£175Enquire Now
    2
    2018: