A Quick Glance

  • black-arrow

    Work efficiently with MS Excel 2016 and its latest features

  • black-arrow

    Find what’s new in MS Excel 2016

  • black-arrow

    Printing of a workbook

  • black-arrow

    Handling with date formats

  • black-arrow

    Review Excel terminologies

  • black-arrow

    How to use VLOOKUP and HLOOKUP

  • black-arrow

    Use cell themes and styles

  • black-arrow

    Use features that will enhance the quality of your work

Microsoft initiated with spreadsheet program called Multiplan in 1982.But Microsoft lost on popularity to LOTUS 1-2-3. This was when Microsoft launched MS Excel for Mac in 1985, and for Windows in 1987. This Intermediate level of MS Excel 2016 course gives you the extra skills delegates required to be more valuable at their jobs. Also, perform the more important task at their workplace.

MS Excel 2016 is part of the MS Office package that is used commercially everywhere in across the worldwide. Now delegates have access to a step-by-step training that empowers you to become a skilled user of MS Excel. Each concept in this course is well explained in detail with visuals.

Who should take this course

  • Sales Manager
  • Investment Banker
  • New Users Microsoft Excel 2016
  • Users wants to update their skills
  • Auditor
  • Credit Counselor
  • Business Analyst
  • Finance Analyst
  • Engineering Graduates
  • Data Scientist
  • Clerk
  • Market Research Analyst
More

Prerequisites

  • It will be beneficial if delegates have knowledge of the appropriate Windows OS.
More

What Will You Learn

  • Learn to use formulas and functions
  • Create and modify charts
  • Convert, filter, sort and manage lists
  • Adding and modify illustrations in a worksheet
  • Working with tables
  • Analysis of data by using functions and conditional formatting
  • Performing calculations in an Excel worksheet
  • Use conditional formatting and styles
  • Managing the workbooks in MS Excel 2016
  • Perform data visualisation, i.e., represent data by using basic charts
  • Build advanced formulas
  • Organise and analyse datasets
  • Customisation of MS Excel environment
  • Modification of an Excel worksheet
  • Importing, fine-tuning, and sharing Excel data
  • Creating, managing, and launching of macros
  • Create spreadsheets using MS Excel 2016
  • Optimisation of worksheets using graphs, templates, and formulas
  • Design complex formulas by nesting of MS Excel functions
  • Make your decisions using PivotTables, Slicers, and PivotCharts
More

What's included

  Course Overview

MS Excel 2016 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. 

Delegates will get skills to analyse large amounts of data, extract useful information from it, and present that information to senior management is the necessity of a successful organisation. This training starts by explaining basic terminologies, tips and tricks of the ribbon, and shortcuts of MS Excel 2016.

It will also teach you about the creation of charts and graphs with data. To handle large datasets available and being build on a nearly continuous basis, as we all know data is becoming more critical and challenging in today's world.

To gain a competitive edge over their competitors, Delegates will need to know how to extract actionable data insights from raw data i.e. when you have any questions; you need to know how to Excel provide you with the answers. It is an aim only to design this course.

 

Uses 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

Advanced Formulas

  • Using Named Ranges in Formulas
  • Naming a Single Cell
  • Naming of a Range of Cells
  • Naming to a Multiple Single Cells Rapidly
  • Use of Formulas That Span Multiple Worksheets
  • IF Function
  • AND/OR Functions
  • SUMIF, AVERAGEIF
  • COUNTIF Functions
  • PMT Function
  • LOOKUP Function
  • Using the VLOOKUP Function
  • HLOOKUP Function
  • UPPER Function
  • LOWER function
  • TRIM Function
  • Using the CONCATENATE Function
  • TRANSPOSE Function
  • PROPER, UPPER, and LOWER Functions
  • LEFT, RIGHT, and MID Functions
  • MID Function
  • Date Functions
  • NOW and TODAY Functions
  • Create Scenarios
  • Utilise the Watch Window
  • Consolidate Data
  • Enable Iterative Calculation
  • Financial Functions

Handling Lists

  • Convert a List into a Table
  • Remove Duplicates from a List
  • Sort Data in a List
  • Filter Data in a List
  • Add Subtotals to a List
  • Group and Ungroup Data in a List

 Handling with Illustrations

  • Working with Clip Art
  • Use Shapes
  • Work with SmartArt

Visualise Your Data

  • Create a Custom Chart Template
  • Insert Charts
  • Adding and Formatting of a Objects
  • Adding a Text Box
  • Creating a Custom Chart Template

Handling Lists

  • Sorting Data
  • Filtering Data
  • Querying Data with Database Functions

Handling Tables

  • Formatting Data in a Table
  • Move between Tables and Ranges
  • Modifying Tables
  • Defining Titles

Advanced Formatting

  • Apply Conditional Formatting
  • Working with Styles
  • Creating and Modifying Templates

Analysing Data

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Use Advanced Conditional Formatting

 

Build Charts in MS Excel 2016

  • Overview to Charts in Excel 2016
  • Inserting Charts in MS Excel and Learn the Various Chart Types
  • Formatting of Excel Charts
  • Creating a Bridge Chart in Excel 2016 - As Easy As It Gets
  • An Easy Way to Create a Treemap
  • Use Sparklines to Show Data Trends

Features New in 2016

  • Overview of Treemap
  • New Charts
  • Sunburst
  • Understand Histogram
  • Study Waterfall
  • Box and Whisker
  • Learn Pareto
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 Intermediate Enquiry

 

Enquire Now


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

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

About Crewe

Crewe is a railway urban and civil community. It lies within the area of Cheshire East and the traditional region of Cheshire, England. The zone has a population of 72,863. Crewe maybe was best known as a large railway connection and home to Crewe Works, for many years a major rail manufacturing ability for industrial and repairing engines, but now much abridged in size. From 1946 until 2002 it was also the home of Rolls-Royce motor car production. The Pym Lane factory on the west of the town now crops Bentley vehicle wholly. Crewe is 158 miles north of London and 35 miles south of Manchester.

Economy:

The railways stationary play a share in local industry at Crewe Works, which conveys out train maintenance and appraisal. It has been controlled by Bombardier Transportation since 2001. There is still an electric engine upkeep yard to the north of the railway station, functioned by DB Schenker Rail. The diesel train upkeep Depot has lately revived as a maintenance facility for a private steam company and has experienced major physical repairs. The Bentley car factory is on Pyms Lane to the west of town. 

Transport:

Crewe railway station is around one mile from Crewe Town Centre. It is one of the central stations in the North West and a major trading station on the West Coast Main Line. It has 12 stages in use and has a direct service to London Euston, Edinburgh, Cardiff, Liverpool, Manchester, Birmingham, Glasgow, Derby, Stoke-on-Trent, Chester, Wrexham and Holyhead for the pass influences to Dublin Port. Many other municipalities and cities also have railway forces to Crewe.

 Culture:

The Grade II-listed Edwardian Lyceum Auditorium is in the centre of Crewe. It was constructed in 1911 and shows drama, ballet, opera, music, comedy and pantomime. The theatre was initially situated on Heath Street from 1882. The Axis Arts Centre is on the Manchester Metropolitan University campus in Crewe. It repositioned from the university's Alsager Campus when it locked. The centre has agenda of touring new presentation and visual artwork. 

More