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 Doncaster

Doncaster is a large market town in South Yorkshire, England. The town forms part of the Me tropolitan Borough of Doncaster. Doncaster is about 20 miles from Sheffield, with which it is shares  the Robin Hood Airport Doncaster Sheffield in Finningley.

Aviation

In 1909 Doncaster Racecourse was chosen as the venue for an airshow. During World War I, the fighters were based rom this airstrip. In 1934, Doncaster opened its own aviation center for the purpose of Civil Aviation. During the Second World War, this airstrip was used for War purposes but reverted back to Civil Aviation after the end of the War. The airstrip was closed in 1992.

 Theatre and cinemas

  •  One of the entertainment venues for which Doncaster iis known is the Cast. Cast opened in 2013 and has 620-seat auditorium, various studios that are flexible and a café.
  • The Doncaster Little Theater accommodates 99-seats and puts on-show their own-in-house shows.
  • The Vue is a 7 screen multiplex also in Doncaster

Besides the theater, the people of Doncaster enjoy every moment they can. There are restaurants, pubs and bars for such purposes. The city has more than 40 bars to entertain its crowd.

 Sports

People in Doncaster are found of playing various games that include Rugby, Football, Basketball and even Racing.

  • Racecourse– The Doncaster Gold Cup (established since 1776)
  • Rugby Football – National League One, RFL Chmpionship
  • Football – Doncaster Rovers F.C , Doncaster Rovers Belles
  • Racing – British League Second Division
  • Basketball – Doncaster Danum Eagles, National League Division 2

 

 

More