Microsoft Excel 2016 Intermediate

Call Us

+44 1344 961530

E-Mail Us

info@pentagonit.co.uk

Introduction
Course Details
Course Content
Enquire

A Quick Glance

Work efficiently with MS Excel 2016 and its latest features
Find what’s new in MS Excel 2016
Printing of a workbook
Handling with date formats
Review Excel terminologies
How to use VLOOKUP and HLOOKUP
Use cell themes and styles
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

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

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

Certificate

Manual

Tutor Support

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

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

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 Wakefield

Wakefield

In West Yorkshire, England, Wakefield is located. Wakefield is on the River Calder and Pennines eastern edge. In 2001 Wakefield had a population of around 77,512. It increased for five Wakefield wards called East, North, South, West and Rural to 77,512 according to 2011 census. Wakefield is also dubbed as ‘ Merrie City’ in Middle Ages. John Leland in 1538 described it as ‘ A quick market town and large and meately large. It is also a well-served market of fish and flesh from sea and rivers so that vital is good and cheap there. Wakefield Battle took place in Wars of the Roses. Wakefield became a famous centre for wool and a market town. In the 18th century, Wakefield made a trade in corn and textiles. In 1888 parish church of Wakefield acquired Cathedral status. It also became a county town of West Riding of Yorkshire. It was the seat of West Riding County Council from 1889 till 1974.

History

Along with railroad, many streams and lakes also played a significant role in economic growth of Wakefield. There were many damn and around twenty mill sites that include fulling mills, gristmills and carding mills along these waterways. Due to this development growing population expanded in seven separate villages, East Wakefield, South Wakefield, North Wakefield, Burleyville Wakefield corner, Sanbornville and Union. Sanbornville villages are now the primary business centre in Wakefield. The new town hall was constructed in Sanbornville in 1895. From Lovell lake , ice was shipped and harvested by two companies with the help of 16 to 20 train carloads to Boston and beyond it every day. At the beginning of 1900’s railroading was to the extreme with 25 trains in and out of Sanbornville every day.

In 1911, due to fire various rail yard buildings burned and operations centre shifted to Dover. After the emergence of electrification, need for ice reduced. The Later popularity of automobiles further reduced the need for rail travel. Finally, in 1969, Snow train which was a passenger train, made its final run.

During Second half of 20th century, a major industry in Wakefield was the development of 11 lakes. Development of summer homes and services needed to be provided. This helped later to provide incomes to many Wakefield residents. It helped to retain the rural character of Wakefield for which Wakefield is known.

Education

Oldest school Surviving in Wakefield is Queen Elizabeth Grammar School, a boys school established in 1591 by Queen Elizabeth by Royal Charter. The original building is in Brook Street that is now the Elizabethan Gallery. In 1854, QEGS school was moved to Northgate. The school was administered by Governors of Wakefield Charities who also opened Wakefield Girls High School ( WGHS) located at Wentworth-street in 1878. Church of England opened National Schools that include St Mary’s in the 1840s and St Johns in 1861. Original St Austin’s Catholic School was opened in 1838. In 1846 Methodist School was opened on Thornhill Street. Eastmoor School previously Pinders Primary School is only opened by Education Act 1870 which is still open.

Wakefield College has origins in School of Art and Craft of 1868. It is today the primary provider of 6th form and further education in the area with around 10,00 part-time and 3000 full-time students. It has campuses in the surrounding towns as well as in the city. In 2007 Wakefield College and Wakefield City Council announced plans to create a University Centre of Wakefield but bid for funding failed in 2009. Other schools with sixth forms include QEGS, Cathedral High School which is now an Arts College for age 11 to 18 and Wakefield High Girls School.