Enquiry  |  Admission
+91 9903-17-6470

Course Overview

We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit. Take your Excel skills to the next level with our Advanced Excel course. You’ll soon be crunching data, using advanced formulas, creating impressive graphs and charts like a pro, plus much more. Advanced Excel is used for almost anything that you can imagine: Agendas, Budgets, Calendars, Cards, Charts, and Diagrams, etc. Advanced Excel jobs available in Bengaluru, Karnataka on Indeed.co.in. Data Analyst, MIS Executive, Credit Analyst and more.

Course Features

Session 1: Introduction

  • Introduction
  • Interface
  • Tabs And Ribbons
  • Document Windows
  • Navigation Tips
  • Office Button And Save

Session 2: Entering, Editing and Formatting Data

  • Entering Data
  • Fonts, Fills, and Alignment
  • Cut, Copy, and Paste
  • Paste Special
  • Undo and Redo
  • Moving, Finding, and Replacing a Value
  • Cell Styles
  • Comments

Session 3: Formatting Numbers

  • Currency Format
  • Format Painter
  • Formatting Dates
  • Custom and Special Formats

Session 4: Managing Worksheets

  • Naming and Moving Worksheets
  • Copying Worksheets
  • Adding, Deleting and Hiding Worksheets
  • Grouping Worksheets
  • Moving, Copying, Deleting and Hiding Grouped Worksheets

 

Session 5: Modifying Rows and Columns

  • Inserting and Deleting Columns and Rows
  • Inserting & Deleting Cells
  • Inserting Multiple Columns & Rows
  • Modifying Cell Width and Height
  • Hiding and Unhiding Rows and Columns

Session 6: Understanding Formulas

  • Using Operations
  • Creating Formulas
  • AutoSum
  • Common Formulas
  • Searching for Formulas
  • Copying Formulas
  • Using Relative and Absolute References

Session 7: Changing Views

  • Workbook Views
  • Show/Hide
  • Zoom Features
  • Freeze Panes
  • Split Windows
  • Viewing Multiple Windows
  • Minimize The Ribbon
  • Worksheet Backgrounds
  • Watermarks

Session 8: AutoFill and Custom Lists

  • AutoFill a Series
  • AutoFill Non-Adjacent Cells
  • AutoFill on Multiple Sheets
  • Creating Custom Lists
  • Series Formatting

 

Session 9: Conditional Formatting

  • Highlight Cells Rules
  • Top/Bottom Rules
  • Data Bars
  • Color Scales
  • Custom Formatting Rule

Session 10: Tables

  • Insert a Table and Style Options
  • Add Rows and Columns
  • Perform a Function in a Table
  • Summarise With Pivot Table

Session 11: Data Tools

  • Data Validation
  • Drop-Down Lists
  • Removing Duplicates
  • Text To Columns
  • Goal Seek
  • Scenario Manager

Session 12: Referencing Formulas

  • Multiple Sheet References
  • Consolidating Data - With or Without Links
  • Trace the Precedents and Dependents
  • Using the Watch Window

Session 13: Ranges and Dates

  • Cell Names
  • Named Ranges
  • Formulas with Cell Names
  • Date Formulas

Session 14: Lookups

  • VLOOKUP
  • VLOOKUP Exact Match
  • HLOOKUP
  • HLOOKUP Exact Match

Session 15: Conditional Logic

  • IF Statement
  • Nested IF
  • AND
  • OR
  • NOT
  • IFERROR
  • SUMIF
  • AVERAGEIF
  • COUNTIF & COUNTIFS
  • SUMIFS
  • AVERAGEIFS

Session 16: Text Formulas

  • Case Formulas
  • Fix Number Fields
  • Trim Spaces
  • Substitute Text

Session 17: Introduction to Charts

  • Chart Types
  • Instant Chart
  • Update Chart
  • Column Chart
  • Picture Fill
  • Adjust Chart Size
  • Line Chart
  • Scatter Chart

 

Session 18: Formatting Charts

  • Chart Styles
  • Chart Layouts
  • Add Labels
  • Axis Options
  • Chart Title
  • Legends
  • Data Labels

Session 19: Adding Graphics to Spreadsheets

  • Insert Pictures
  • Modifying Pictures
  • Insert Shapes
  • Insert SmartArt
  • Apply Themes
  • Arrange

Session 20: Outline, Sort, Filter, and Subtotal

  • Group and Ungroup
  • Sort Data
  • Sort Multiple Levels
  • Filter Data
  • Advanced Filter
  • Conditional Sorting and Filtering
  • Sorting with Custom Lists
  • Subtotal

Session 21: PivotTables

  • Creating PivotTables
  • Choosing Fields
  • PivotTable Layout
  • Filtering PivotTables
  • Modifying PivotTable Data
  • PivotCharts

Session 22: Protecting Data

  • Workbook Passwords
  • Protecting Workbooks
  • Unlocking Cells

Session 23: Collaboration

  • Document Properties
  • Inserting Hyperlinks
  • Sharing a Workbook
  • Track Changes
  • Accept/Reject Changes
  • Mark as Final

Session 24: Printing

  • Page Orientation
  • Page Breaks
  • Print Area
  • Margins
  • Print Titles
  • Headers and Footers
  • Scaling
  • Sheet Options

Session 25: Saving a Workbook

  • Save As the Previous Version
  • AutoRecover Save Options
  • Templates
  • Save As PDF
  • Save As Web Page
  • Macro-Enabled Workbook

Session 26: Macros

  • Macro Security
  • Recording a Macro
  • Assign a Macro to a Button or Shape
  • Run a Macro upon Opening a Workbook
  • How to Inspect and Modify a Macro

Course Eligibility

There is not a professional or academic qualification to be able to apply for the MS Excel Certification. The applicants are just needed to have the latest software to be installed on their computer/laptop for ready to run through the online exam.

Frequently Asked Questions

We are almost ready with your Frequently Asked Questions. Already we answered all question please check below may i will help to you.

Get A Quote

Get quote easily just fill the below form and our one agent will contact you in 24 hours.

Top