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 London

Capital of the most populous city of England, London, is located on River Thames in the south east island of Great Britain. London came into being as Londonium in AD 43 when the Romans invaded it. However, it lasted only for 18 years before being burnt down by Queen Boudica. Londonium, prospered in AD 100 as the capital of the Roman province of Brittania. After the collapse of the Romans in the 5th Century, London was no more a capital city. However, passing through different ages, London had become the largest town of England by the 11th Century. In the modern times, London shot to fame becoming the world's biggest city during 1831 to 1925.

 Tourism

 London, known to be one of the best tourist spots the worldover, is ranked the most visited city in 2015 with over 65 million visitors. It also ranks among the top places in the world as far as cross-border spending is concerned. The total expenditure is estimated at US$20.23 billion as in 2015. Tourism is one of London's prime industries. It employed around 350,000 full-time workers in 2003, and the city accounts for 54% of all inbound visitor spending in the UK. As of 2016, London is the world top city destination as ranked by TripAdvisor users

In 2015, the top most-visited attractions in UK were all in London. The top 10 most visited attractions were:

  • Tate Modern
  • The British Museum
  • Tower of London
  • The National Gallery
  • Southbank Centre
  • Victoria and Albert Museum (South Kensington)
  • Natural History Museum (South Kensington)
  • Science Museum
  • Somerset House
  • National Portrait Gallery

The number of hotel rooms which has been growing every year stood at 138,769 in 2015.

Transport

 Airports

  • London Heathrow Airport
  • Gatwick Airport
  • Stansted Airport
  • London City Airport
  • London Southend Airport

 Rail

  • The London Underground, or the Tube, is the oldest and second longest metro system in the world.
  • The Docklands Light Railway  which opened in 1987 is a local metro system. It makes use of small  tram-type vehicles which happen to serve the Docklands, Greenwich and 

Education

Primary and Secondary

The majority of primary as well as high schools are controlled by London boroughs. So are the  further-education colleges in London. Some are also  state-funded. London is also having a number of private schools and colleges.

Tertiary Education

London is known as a  centre of higher education teaching and research. According to studies and research, London has the maximum number of higher education institutes in Europe. London was ranked as having the greatest concentration of top class universities in the world for the years 2015-16. London has an international student population of around 110,000 which is deemed to be larger than any other city in the world. Pricewaterhouse Coopers report termed London as the global capital of higher education.

 

More