Microsoft Excel 2016 Introduction

Call Us

+44 1344 961530

E-Mail Us

info@pentagonit.co.uk

Introduction
Course Details
Course Content
Enquire

A Quick Glance

Handling the worksheets
Learn the use of templates
Understand hierarchy of calculations and the Order of Operations
Add columns and rows
Formatting and aligning data in worksheets
Use cell themes and styles
Printing of a workbook
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

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

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

Tutor Support

Certificate

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

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

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 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.