Microsoft Excel 2016 Level 1Courses > Microsoft Office Training > Microsoft Office 2016 > Microsoft Excel 2016 Level 1

  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Declaration of views_handler_argument::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_argument.inc on line 917.
  • strict warning: Declaration of views_handler_argument::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_argument.inc on line 917.
  • strict warning: Declaration of views_handler_sort::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.
  • strict warning: Declaration of views_handler_sort::options_submit() should be compatible with views_handler::options_submit($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.
  • strict warning: Declaration of views_handler_sort::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.
  • strict warning: Declaration of views_handler_filter::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_filter.inc on line 587.
  • strict warning: Declaration of views_handler_filter::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_filter.inc on line 587.
  • strict warning: Declaration of views_handler_filter_node_status::operator_form() should be compatible with views_handler_filter::operator_form(&$form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/modules/node/views_handler_filter_node_status.inc on line 13.
  • strict warning: Declaration of views_plugin_argument_validate::options_submit() should be compatible with views_plugin::options_submit($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/plugins/views_plugin_argument_validate.inc on line 87.
  • strict warning: Declaration of views_plugin_argument_validate_taxonomy_term::options_submit() should be compatible with views_plugin_argument_validate::options_submit(&$form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/modules/taxonomy/views_plugin_argument_validate_taxonomy_term.inc on line 165.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
Duration: 
1 day - £249
Course ID: 
n/a

Microsoft Excel 2016 combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Delegates will learn the basics of creating, editing, and saving worksheets in our Essentials level class. They will work with formulas and functions to calculate and return values.  Delegates will learn to change the appearance of a page, including adding headers and footers, format data and create charts.

 

Microsoft Excel 2016 Level 1
 
 
Duration
 
1 day
 
 
Course Overview
 
Microsoft Excel 2016 combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Delegates will learn the basics of creating, editing, and saving worksheets in our Essentials level class. They will work with formulas and functions to calculate and return values.  Delegates will learn to change the appearance of a page, including adding headers and footers, format data and create charts.
 
 
Course Objectives
 
Upon successful completion of this course, students will have the skills necessary to:
•   Identify basic worksheet and workbook concepts and terms
•   Enter & edit data
•   Modify the worksheet
•   Use functions to calculate and return values
•   Format cells to enhance the appearance of your worksheet
•   Use drawing features and other enhancements
•   Change the page set-up to define how the printed worksheet appears
 
 
Prerequisites
 
Delegates should have an understanding of any of the following operating systems: Windows 98/NT/2000/ME/XP/VISTA/7/8/10
 
 
Course Contents

Excel Essentials
Starting Excel
What is a Worksheet?
What is a Workbook?
Identifying Parts of the Screen
Identifying the ribbon Components
Getting Help
Using Selection Techniques
Selecting a Range of Cells
Selecting Nonadjacent Cells and Ranges
Selecting an Entire Worksheet
Entering Data
Entering Text Data into a Cell
Entering Values
Entering Data into a Range
Quickly Adjusting a Column Width
Finishing a Workbook
Saving a Named Workbook
Saving the Workbook in HTML Format
Printing a Worksheet
Closing a Workbook and Exiting from Excel

Formatting Text & Printing a Document
Opening a Workbook
Creating a New Workbook
Opening a Recently Used Workbook
Creating Simple Formulas
Creating a Formula by Pointing
Using Functions
Using the AutoSum Button
Using the Formula Palette
Editing Data on the Worksheet
Editing the Data in a Cell
Editing a Formula
Clearing the Contents from a Cell or Range
Using Undo and Redo

Managing the Worksheet
Navigating in a Worksheet
Using the Scroll Bars and Boxes
Changing Worksheets
Using Go To
Changing the Worksheet Structure
Deleting Cells, Rows, and Columns
Performing a Simple Sort
Creating and Using Named Ranges
Automatically Naming Ranges
Navigating with Named Ranges
Using Range Names in Formulas
Pasting a List of Named Ranges
Deleting and Editing Range Names
Creating Named Constants

Formatting the Worksheet
Moving and Copying Data
Copying Data
Copying Data with AutoFill
Creating a Series with AutoFill
Defining Relative, Mixed, and Absolute References
Copying Formulas
Changing the Appearance of Data
Changing Row Height
Applying Fonts
Adding Enhancements
Aligning Data in Cells
Merging and Centering Cells
Rotating and Indenting Text
Adding Borders and Shading
Using Drawing Tools
Creating Graphic Objects
Editing a Graphic Object
Creating and Editing 3-D Objects 
Using Other Drawing Tool

Printing the Worksheet/book
Printing a Single Worksheet
Using Print Preview 
Creating Headers and Footers
Removing the Grid
Printing a Selection
Printing a Selection
Using Print Areas
Using Advanced Printing Techniques
Aligning the Printout
Fitting a Document onto a Desired Number of Pages 
Working with Page Breaks 
Working with Page Breaks in Normal View
Setting Print Titles
Removing Print Titles

Course dates

From: 
Wednesday, 10 July 2019
Venue: 
Glasgow
From: 
Monday, 12 August 2019
Venue: 
Glasgow
From: 
Monday, 14 October 2019
Venue: 
Glasgow