A Quick Glance

  • black-arrow

    Handling the worksheets

  • black-arrow

    Learn the use of templates

  • black-arrow

    Understand hierarchy of calculations and the Order of Operations

  • black-arrow

    Add columns and rows

  • black-arrow

    Formatting and aligning data in worksheets

  • black-arrow

    Use cell themes and styles

  • black-arrow

    Printing of a workbook

  • black-arrow

    Handling with date formats

Microsoft Excel 2016 Introduction course will teach delegates about the core features of MS Excel 2016. Microsoft Excel makes the task easier for the user who deals with the data. Earlier it was so difficult to manage such a large amount of data and represent it to transform that data into decisions. So, Microsoft provides the user with the MS Excel to these task in short span of time. The Microsoft had Multiplan which was launched on 1982, but then they launched the first version of excel for mac and windows released on 1985 and 1987 respectively.

The training of updated version of Microsoft Excel 2016 will provide sufficient amount of time to understand the technical concepts in depth to make sure a complete understanding that delegates will get an expert in them. Experienced professionals of MS Excel have written the course for the introductory part of MS Excel 2016 training. MS Excel is the primary tool required to manage the existing data in working environment.

Who should take this course

  • Engineering/ Management Graduates
  • Managers
  • Accountants

Prerequisites

  • It will be a plus point if delegates have knowledge of the any Windows OS.

What Will You Learn

  • Creation of basic worksheets using MS Excel 2016
  • Performing calculations in an MS Excel worksheet
  • Modify of MS Excel worksheet
  • Importing, fine-tuning, and sharing Excel data
  • Summarise data with MS Excel by formulas, formatting, charts and graphs
  • Optimisation of worksheets using charts, templates, and formulas
  • Managing the MS Excel 2016 workbooks
  • Creating, managing, and launching of macros
  • Use formulas and functions
  • Formatting an Excel Worksheet
  • Modification of an appearance of data within a worksheet
  • Build basic worksheets using MS Excel 2016
  • Modifying the appearance of data within a worksheet
  • Create a basic worksheet
  • Designing of a simple into complex equations by nesting of MS Excel functions
  • Learn how to use helpful features in MS Excel 2016
More

What's included

  Course Overview

In this Introduction to MS Excel training, one will learn to build and edit basic spreadsheets and workbooks. This training is designed for delegates who need to gain the vital skills to build, format, edit, and print MS Excel spreadsheets.

Excel can help delegates in organising, calculating, analysing, revising, updating, and presenting your data in ways that will help the senior management to make a decision in your organisation steer you in the right direction.  It will also help to manage these tasks much easier to accomplish, that too in much less time. Delegates will get tips on creating 3-D workbooks, create links between files, and automate cyclic tasks with macros. This introduction course will teach delegates about Flash Fill, Quick Analysis, and powerful charting capabilities available in latest MS Excel 2016.

This instructor-led training will be conducted on the 2016 version of the software. Our instructor will explain the negligible differences between older versions and updated version of MS Excel. Most common reason that delegates will do this course as it make their job easier and we can also perform the analysis on data. It will also help delegates to represent your data to their seniors with the help of charts and graphs.

 

shortcuts of excel

 

More

  Course Content

Overview:

  • Navigate the user interface of MS Excel
  • Use of Excel Commands
  • Build and Save a Workbook
  • Enter a Cell Data

Creating a Microsoft Excel Workbook

  • Start Microsoft Excel
  • Create a Workbook
  • Save a Workbook
  • Status Bar
  • Add and Delete Worksheets
  • Copy and Move Worksheets
  • Change the order of Worksheets
  • Split the Worksheet window
  • Close a Workbook

 Modifying a Workbook

  • Cut, Copy and Paste Commands
  • Flash Fill
  • AutoFill Options
  • Find and Replace
  • Spelling
  • Undo and Redo
  • Inserting and Deleting Options
  • Modify Column Width and Row Height
  • Hide and Unhide Options

Ribbon

  • Learn Tabs
  • Groups
  • Commands

The Backstage View

  • Overview of Backstage View
  • Open a Workbook
  • New Workbooks and MS Excel Templates
  • Print Worksheets
  • Add your Name to Microsoft Excel
  • Manage Workbook Versions

Format the MS Excel Worksheet

  • Font Group
  • Add Borders and Fill Colors
  • Cell Alignment
  • Formatting of numbers
  • Cell Styles and Galleries

Quick Access Toolbar

  • Add Common Commands
  • Add Additional Commands with the Customisation of a Dialogue Box
  • Add Ribbon Commands or Groups
  • Placement

Enter Data in Excel Worksheets

  • Enter Text
  • Expand Data across Columns
  • Add and Deleting Cells
  • Add an Outline
  • Add a Hyperlink
  • Add WordArt to a Worksheet
  • Using AutoComplete
  • Enter Numbers and Dates
  • Use the Fill Handle

Format Excel Worksheets

  • Select Ranges of Cells
  • Hide Worksheets
  • Add Color Tabs
  • Add Themes
  • Add a Watermark
  • The Font Group
  • Alignment Group
  • Number Group

Using Formulas in Excel

  • Math Operators and the Order of Operations
  • Enter Formulas
  • AutoSum Copying Formulas and Functions
  • Relative and Absolute
  • Mixed Cell References

Printing

  • Print Preview
  • Print Worksheets
  • Page Setup
  • Print Titles
  • Page Layout View
  • Print options
  • Print data
  • Views
  • Page set up dialogue
  • Margins tab
  • Header/Footer tab
  • Latest methods for headers and footers in MS Excel 2016

Rows and Columns

  • Insert Rows and Columns
  • Deletion of Rows and Columns
  • Transpose Rows and Columns
  • Setting Row Height and Column Width
  • Hide and Unhide Rows and Columns
  • Freezing Panes

Editing Worksheets

  • Find
  • Find and Replace
  • Use Clipboard
  • Managing Comments
    • Inserting Comments
    • Working with Comment

Modify a Workbook

  • Cut and Copy Commands
  • Paste Command
  • Flash Fill
  • AutoFill Options
  • Find and Replace
  • Spelling
  • Undo and Redo
  • Insertion and Deletion
  • Column Width and Row Height
  • Hide and Unhide Options

Finalise MS Excel Worksheets

  • Set Margins
  • Page Orientation
  • Print Scaling
  • Headers
  • Footers

Manage Worksheets and Workbooks

  • Managing Worksheets
  • View Worksheets and Workbooks
More

Shortcuts of Excel

Shortcuts for the MS Excel:

To do this

Press

Close a spreadsheet

Ctrl+W

Open a spreadsheet

Ctrl+O

Go to the Home tab

Alt+H

Save a spreadsheet

Ctrl+S

Copy

Ctrl+C

Paste

Ctrl+V

Undo

Ctrl+Z

Remove cell contents

Delete key

Choose a fill color

Alt+H, H

Cut

Ctrl+X

Go to Insert tab

Alt+N

Bold

Ctrl+B

Center align cell contents

Alt+H, A, then C

Go to Page Layout tab

Alt+P

Go to Data tab

Alt+A

Go to View tab

Alt+W

Format a cell from context menu

Shift+F10, or

Context key

Add borders

Alt+H, B

Delete column

Alt+H, D, then C

Go to Formula tab

Alt+M

 

Vlookup(): It helps to search a value in a table and returns a corresponding value.

                                            

Syntax: = LOOKUP( value, lookup_range, [result_range] )

 

HLOOKUP(): The MS Excel HLOOKUP function performs a search for a value in the top row of the table and returns the value in the same column by index_number.

 

HLOOKUP( value, table, index_number, [approximate_match] )



Microsoft Excel 2016 Introduction Enquiry

 

Enquire Now


----- OR -------

Reach us at +44 1344 961530 or info@pentagonit.co.uk for more information.

About Slough

Slough is a big city in Berkshire, England, 20 miles west of central London, 3 miles north of Windsor, 6 miles east of Maidenhead, 12 miles south-east of High Wycombe and 20 miles north-east of Reading. Sedentary at the entry to the Thames Valley and London and at the intersection of the M4, M40 and M25 motorways, it proposals easy road entrance to the rest of the UK. The A4 and the Great Western Main Line pass through the town, which was part of adjacent Buckinghamshire. From 2019, the Elizabeth Line will permit fast journeys to the heart of London.

Geography:

Slough is to the west of Greater London. Nearby cities are Windsor to the south, Maidenhead to the west, Uxbridge to the northeast and Beaconsfield to the north. Mostly Slough areas were anciently part of Buckinghamshire. The town advanced by the growth and merger of communities along the Great West Road. Over the years Marsh has lengthy highly, joining some, unlike villages. 

The urban area syndicates into the neighbouring groups of Burnham, a small area of Taplow near Chippenham, Farnham Royal and Stoke Poges which continue in the region of Buckinghamshire and Datchet which is also in Berkshire. Eton is barely cushioned by the Jubilee River and by green space from part of Slough, and the two areas previously shaped the Eton birth, marriages and deaths registration region.

 

More