NEW CASTLE - UK USA CERTIFIED TRAINING PROGRAMS IN LAHORE PAKISTAN - Microsoft Excel 2016 Training Courses


Microsoft Excel 2016 Training Courses Lahore

After completing this Microsoft Excel 2016 training course you will become familiar with spreadsheet terminology and the Excel interface. You will learn to enter and edit text, values, formulas and save and open workbooks. You will also move and copy data, learn about absolute and relative references.

The training is organized in Basic, Intermediate and Advanced levels as described below. 

Microsoft Excel 2016 Training

Module 1: The Basics
Getting Started
Creating a New Workbook
Parts of a Workbook
Saving a Workbook
Opening a Workbook
 
Module 2: Your First Workbook
Selecting Data
Entering and Deleting Data
Using Undo and Redo
Using Cut, Copy, and Paste
 
Module 3: Working with Data
Inserting Rows and Columns
Merging and Splitting Cells
Moving Cells
Using Paste Special
Using Find and Replace
Hiding and Unhiding Cells
 
Module 4: Using Basic Excel Tools
Understanding Cell References and Formulas
Using Basic Formulas
Using Basic Functions
Using Advanced Functions
Using Spell Check
Using Sort and Filter
 
Module 5: Using Timesaving Tools
Using AutoFill
Using Flash Fill
Using AutoSum
Using AutoComplete
Using AutoCalculate
 
Module 6: Formatting Text
Changing the Font Face, Size, and Colour
Applying Text Effects
Applying Borders and Fill
Using the Font Tab of the Format Cells Dialog
Clearing Formatting
Module 7: Formatting Data
Wrapping Text
Changing the Size of Rows and Columns
Adjusting Cell Alignment
Changing Text Direction
Changing Number Format
 
Module 8: Formatting the Workbook
Using Cell Styles
Formatting Data as a Table
Changing the Theme
Inserting Page Breaks
Adding a Background
 
Module 9: Inserting Art and Objects
Inserting SmartArt
Inserting Text Boxes
Inserting Pictures
Inserting Equations
Drawing Shapes
 
Module 10: Charting Data
Creating Sparklines
Inserting Charts
Inserting PivotTables
Inserting PivotCharts
Using Slicers
Creating Timelines
 
Module 11:  Viewing, Printing, and Sharing Your Workbook
Using Views
Saving a Workbook as PDF or XPS
Printing a Workbook
E-Mailing a Workbook
Sharing Your Workbook on SkyDrive
 
Module 12: Customizing the Interface
Changing Ribbon Display Options
Customizing the Quick Access Toolbar
Hiding and Showing Ribbon Tabs
Creating Custom Ribbon Tabs
Resetting Interface Changes

Microsoft Excel 2016 Training

Module 1: Advanced Formula Tasks
Understanding Relative and Absolute Cell References
Using Multiple Cell References
Using 3D References
Using Array Formulas
 
Module 2: Working with Named Ranges
Understanding Named Ranges
Defining Named Ranges
Editing Named Ranges
Deleting Named Ranges
Using Named Ranges in Formulas
 
Module 3: Using Advanced Functions
Using the PMT Function
Using the FV Function
Using VLOOKUP and HLOOKUP Functions
Using IF, AND, OR Functions
Module 4: Sorting, Outlining and Grouping Data
Using Sort and Filter
Outlining Data
Showing and Hiding Outline Details
Grouping Data
Creating Subtotals
Removing Outlining and Grouping
Advanced Filtering
 
Module 5: Managing Data
Consolidating Information
Removing Duplicates
Configuring Data Validation
Transposing Data
Converting Text to Columns
 
Module 6: Charting Data
Creating Sparklines
Inserting Charts
Create a combination chart with a secondary axis
Add a Trend or Moving Average Line

Microsoft Excel 2016 Training

Module 1: Advanced Formula Tasks
Understanding Relative and Absolute Cell References
Using Multiple Cell References
Using 3D References
Using Array Formulas
 
Module 2: Working with Named Ranges
Understanding Named Ranges
Defining Named Ranges
Editing Named Ranges
Deleting Named Ranges
Using Named Ranges in Formulas
 
Module 3: Using Advanced Functions
Using the PMT Function
Using the FV Function
Using VLOOKUP and HLOOKUP Functions
Using IF, AND, OR Functions
 
Module 4: Resolving Formula Errors
Tracing Formula Precedents and Dependents
Showing Formulas
Evaluating Formulas
Setting Error Checking Options
Using Error Option Buttons
Running an Error Check
 
Module 5: Managing Data
Consolidating Information
Removing Duplicates
Configuring Data Validation
Transposing Data
Converting Text to Columns
 
Module 6: Outlining and Grouping Data
Outlining Data
Showing and Hiding Outline Details
Grouping Data
Creating Subtotals
Removing Outlining and Grouping

Module 7: Working with Scenarios
Creating Scenarios
Loading Scenarios
Merging Scenarios
Editing Scenarios
Creating a Scenario Summary Report
Deleting Scenarios

Module 8: Using Solver
Setting up the Worksheet
Running Solver
Generating Reports and Scenarios with Solver
Modifying Constraints
Setting Solver Options
 
Module 9: Analyzing Data
Enabling the Analysis ToolPak
Using Data Analysis Tools
Using Goal Seek
Using Data Tables
 
Module 10: Advanced PivotTable Features
Creating a Basic PivotTable
Creating a Basic PivotChart
Using the PivotTable Fields Pane
Adding Calculated Fields
Sorting Pivoted Data
Filtering Pivoted Data
 
Module 11: Using PowerPivot
Enabling PowerPivot
Importing Access Data
Importing Excel Data
Integrating Data with Relationships
Creating a PivotTable with PowerPivot Data
 
Module 12: Using Macros
Recording a Macro
Writing a Macro using the Visual Basic Editor
Editing a Macro
Running a Macro
Review Questions

   

Microsoft Excel 2016 Benefits

  • Import and explore massive data sets within much expanded spreadsheets.
  • Use charting engine to communicate analysis in great-looking charts.
  • Enjoy improved and powerful support for working with tables.
  • Create and work with interactive PivotTable views with ease.
  • “See” important trends and find exceptions in your data.
  • Reduce size of spreadsheets and improve damaged file recovery.
  • Extend your business intelligence investments because Excel provides full support for Microsoft SQL Server 2005 Analysis Services.
 

 

Our Certified Skills & Trainings are available throughout the year in LAHORE, ISLAMABAD & DUBAI. We provide 100% Practical Skills & Project Based Trainings. Opportunities for internship and job for Select candidates and their placement on international projects.

International Skills