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 Doncaster

Doncaster is a large market town in South Yorkshire, England. The town forms part of the Me tropolitan Borough of Doncaster. Doncaster is about 20 miles from Sheffield, with which it is shares  the Robin Hood Airport Doncaster Sheffield in Finningley.

Aviation

In 1909 Doncaster Racecourse was chosen as the venue for an airshow. During World War I, the fighters were based rom this airstrip. In 1934, Doncaster opened its own aviation center for the purpose of Civil Aviation. During the Second World War, this airstrip was used for War purposes but reverted back to Civil Aviation after the end of the War. The airstrip was closed in 1992.

 Theatre and cinemas

  •  One of the entertainment venues for which Doncaster iis known is the Cast. Cast opened in 2013 and has 620-seat auditorium, various studios that are flexible and a café.
  • The Doncaster Little Theater accommodates 99-seats and puts on-show their own-in-house shows.
  • The Vue is a 7 screen multiplex also in Doncaster

Besides the theater, the people of Doncaster enjoy every moment they can. There are restaurants, pubs and bars for such purposes. The city has more than 40 bars to entertain its crowd.

 Sports

People in Doncaster are found of playing various games that include Rugby, Football, Basketball and even Racing.

  • Racecourse– The Doncaster Gold Cup (established since 1776)
  • Rugby Football – National League One, RFL Chmpionship
  • Football – Doncaster Rovers F.C , Doncaster Rovers Belles
  • Racing – British League Second Division
  • Basketball – Doncaster Danum Eagles, National League Division 2

 

 

More