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 Luton

Luton is a large town in Bedfordshire, England. It is 20 miles east of Aylesbury, 14 miles (20 km) west of Stevenage, 30 miles (50 km) north-west of London, and 22 miles (40 km) south-east of Milton Keynes.

London Luton Airport, opened in 1938, is one of Britain's major airports. The University of Bedfordshire is also founded in the town.

Luton Carnival, usually held on the Whitsun May bank holiday, is the largest one-day festival in Europe.

The town was for many years well-known for hat-making, and also had a large Vauxhall Motors factory. Car production at the plant instigated in 1905 and sustained until 2002. Production of profitable vehicles lasts, and the head office of Vauxhall Motors is static in the town.

Governance:

Luton is a huge city in Bedfordshire, England. It is 20 miles east of Aylesbury, 14 miles west of Stevenage, 30 miles north-west of London, and 22 miles south-east of Milton Keynes.

London Luton Airport is one of Britain's major airports, opened in 1938. The Bedfordshire University is also founded in the town. Luton Carnival, usually detained on the Whitsun May bank holiday, is one of the largest carnivals in Europe.

The city was for known for hat-making, and also had a large Vauxhall Motors factory. Car manufacture at the plant initiated in 1905 and sustained until 2002. Manufacturer of commercial vehicles lasts, and the head office of Vauxhall Motors is static in the town.

Climate:

Luton has a temperate marine weather, like much of the British Isles, with usually light precipitation through the year. The climate is variable, and the warming up effect of the Gulf Brook makes the region mild for its leeway. The normal total annual rainfall is 698 mm with rain falling on 117 days of the year. Snow buildup over the Chiltern Hills during October 2008 snowfall, Luton is meant by the yellow dot.

More