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

Prerequisites

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

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 Buxton

Buxton is located at an elevation of 960 feet above sea level in Derbyshire, England. Buxton is also famous as the “gateway to the Peak District National Park”.

History

The town is believed to have been settled by the Romans who lived there throughout the occupation. Later, in the 18th century, the town was developed by the Dukes of Devonshire. After about a hundred years Buxton got introduced to the Victorians who developed it for the healing properties of the waters.

Healing Properties of the Water

Buxton has been known for its geothermal springs that emanate from the River Wye. The spring waters rise at a temperature of 28oC constantly. The fifth Duke of Devonshire is said to have developed the town as a spa from his own profits.

Festivals

The Buxton Festival

The Buxton Festival was founded in 1979 and continues for a three weeks period in July. It is an opera and arts festival that runs at various venues including the Opera House. Various programs are included in this festival. During the festival, literary events, concerts and recitals are also held.

The Buxton Festival Fringe

The festival runs just alongside The Buxton Festival and is a warm-up or prelude to the Edinburg Fringe. The Buxton fringe hosts various kinds of cultural events and films in different venues around the town. In 2014 it had featured 600 such events from 150 plus different entrants.

People

Many known names belong to the town of Buxton. They include

  • Robert Stevenson who directed many pictures for Disney
  • John Buxton Hilton – British Crime Writer

Misc

Buxton hosts the Four Four Time music Festival every Feburary. It  features    rock, pop, folk, blues, jazz and world music. Buxton has various museums and art galleries that feature collections of local artefacts. They also display geological and archaeological samples and 19th- and 20th-century paintings. 

More