Microsoft Excel 2016

Course Overview

WeOffer

  • Instructor Led classroom based training
  • Hands on Training
  • Free study material
  • Lab Exercises
  • Unlimited lab access
  • 100 % passing guarantee
    or Free Re-training

courseinformation

  • Fast Track
    Days: Monday-Wednesday
    Duration: 2 days
  • Slow Track
    Days: Saturday/Sunday Only
    Duration: 2 Weeks
Study Modes:
  • Classroom
  • Live Virtual

Other Training Packages:

MS(Word) + MS(Excel)
£500

MicrosoftExcel 2016

Interest Free Available

For More information call us on

02085347556

Dates & prices

Start Date Timing Days Duration Mode Of Training Price
16/09/2019
Places available
10:00 – 18:00M,T2 DaysClassroom Based350
21/10/2019
Places available
10:00 – 18:00M,T2 DaysClassroom Based350
18/11/2019
Places available
10:00 – 18:00M,T2 DaysClassroom Based350
16/12/2019
Places available
10:00 – 18:00M,T2 DaysClassroom Based350

Course Insight

Microsoft is well renown and widely used all over the world as office application. All the office needs to create a spread sheet to manage their accounts. Therefore, due to high demand and popularity, individual required a skill in Microsoft Excel and enhance their skillset. Microsoft Excel tool allow organization to monitor financial performance and take business decisions on the basis of accounts figure. It also help to plan future projects and financial requirement for the project.

In Excel, delegate can learn some programming and formulas to calculate different value and create different accounts. The short key usage and Macros are the key element in Microsoft Excel.

Career Prospect

Office Administration, Daily Office Work, 1st Line IT support

Learning Facilities

Our lab is fully equipped with physical devices students can learn and practice all the skills with real world scenarios.

General Facilities

We also provide Free Wifi Internet, Refreshment, Water, Tea and Coffee Facilities.

Course Contents

1. Exploring Excel

  • Finding and using commands
  • Moving around a worksheet
  • Navigating the workbook

2. Basic Workbook Skills

  • Creating a workbook
  • Selecting cells and ranges
  • Opening, closing and saving workbooks
  • Entering data into cells
  • Entering values into ranges

3. Creating Simple Formulas

  • Writing formulas in cells
  • Using the Formula Bar
  • AutoSum and other basic functions
  • The Paste Function tool Automatic calculation

4. Copying and Moving Data

  • Copying and cutting data
  • Absolute cell references Filling cells
  • Using drag-and-drop
  • Undo and Redo
  • Find and Replace

5. Managing Worksheets

  • Naming worksheets
  • Copying and moving worksheets
  • Grouping worksheets
  • Moving data between sheets
  • Adding and deleting worksheets
  • Creating 3-D formulas

6. Printing

  • Choosing what to print
  • Previewing and printing
  • Page Setup
  • Margins and page orientation
  • Headers and footers
  • Repeating column/row headings
  • Page Break Preview
  • Printing gridlines

7. Formatting Data and Cells

  • Formatting numbers
  • Formatting text
  • Colouring data and cells
  • Wrapping and shrinking text
  • Merging cells
  • Using indents
  • Applying borders to cells
  • The Format Painter
  • Conditional formatting

8. Working with Columns and Rows

  • Selecting columns and rows
  • Changing column width and row height
  • Hiding and unhiding
  • Inserting and deleting

9 Using Large Spreadsheets

  • Changing the magnification
  • Full Screen view
  • Splitting the window
  • Using Freeze Panes

10. Named Ranges

  • Naming a range of cells
  • Jumping to a named range
  • Using range names in formulas
  • Re-defining and deleting range names

11. Working with Data Series

  • Creating a linear series
  • Working with Date series
  • Using Autofill

Skills Gained

  • Configure and manage the essential features of Palo Alto Networks next-generation firewalls
  • Configure and manage GlobalProtect to protect systems that are located outside of the data center perimeter
  • Configure and manage firewall high availability
  • Monitor network traffic using the interactive web interface and firewall reports

Training Offers & Packages

1st Line IT Support Engineer

package1
£ 2000 Save: £800
  • CompTIA A+
  • MCMDAA Windows 10
  • MCP Server 2012

1st/2nd Line IT Support Engineer

package3
£ 2500 Save: £1150
  • CompTIA A+
  • CompTIA Network+
  • MCMDAA Windows10
  • MCP Server 2012

1st/2nd Line IT Support Engineer

package3
£ 2500 Save: £1150
  • CompTIA A+
  • CompTIA Network+
  • MCMDAA Windows10
  • MCP Server 2012

Enquire Now