A Quick Glance

  • black-arrow

    Handling the worksheets

  • black-arrow

    Learn the use of templates

  • black-arrow

    Understand hierarchy of calculations and the Order of Operations

  • black-arrow

    Add columns and rows

  • black-arrow

    Formatting and aligning data in worksheets

  • black-arrow

    Use cell themes and styles

  • black-arrow

    Printing of a workbook

  • black-arrow

    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
More

Prerequisites

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

What Will You Learn

  • 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
More

What's included

  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

 

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

 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
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 Introduction Enquiry

 

Enquire Now


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

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

About Nottingham

Nottingham

Nottingham city is located in England and 128 miles north of London. As part of Queen Victoria’s Diamond Jubilee celebration, Nottingham gained its city charter. This town has links with legend of Robin Hood and lace making, tobacco and bicycle industries. Nottingham is a famous tourist destination. Visitors spend a significant amount of money. In 2015, the population of this city was 321,550. The metropolitan economy is the seventh largest in United Kingdom with GDP of $50.9 billion. Globalisation and World Cities Research Network ranked it as a Sufficiency-level world city. Nottingham is a major sporting centre and named as ‘Home of England Sport’ in October 2015. Various traditional centres like National Ice Centre, Trent Bridge and Holme Pierrepont National Watersports Centre are located in Nottingham.  It is also a home for two professional football teams. The city has professional ice hockey, rugby, cricket teams and international tennis tournament for WTA and ATP tours.

UNESCO named the Nottingham “City of Literature” on December 11, 2015. Including Norwich, Prague, Melbourne and Barcelona. This title demonstrates rich literary heritage of Nottingham. Nottingham has two universities named Nottingham Trent University and the University of Nottingham. The University of Nottingham has almost 70,610 students. Around 43,765 students are at Nottingham Trent University.

History

Electric trams started in Nottingham in the year 1901. Nottingham Council began building houses in 1920’s and 1930’s. Many houses have been constructed in new estates in the north of the city. In 1948 Nottingham University was founded. Nottingham developed rapidly in the 20th century. In late 20th century, main industries of Nottingham was tobacco, bicycles, textiles, printing and pharmaceuticals. Today the population of Nottingham is 305,000.

Economy

Nottingham city council announced that s part of the economic strategy of the city. Target sectors include life sciences, financial, business services, low carbon technologies, retail and leisure services.

Nottingham is a home to various companies headquarters. Companies include Pedigree, American clothing VF cooperation, Chinese made automobiles, Chinook Sciences and much more. Nottingham is also the home to Nottingham Building Society that was established in 1849. Other companies include Driving Standards Agency, BBC East Midlands, Government office for East Midlands and HM Revenue and Customs.

In 2005, Nottingham was made one of six science cities of UK. Now Cycle Manufacturing is a major industry in Nottingham. It is also a host to UK’s first and only local authority-owned. In 2015, Nottingham was ranked in top 10 UK cities for job growth. Various new companies started in Nottingham in 2014/2015 than any other city of UK.

 

More