Advance Excel Course Training in Chandigarh Mohali - ThinkNEXT
  78374-01000, 78374-02000, 78374-03000      
Whatsapp 78374-04000
Toll Free : 1800-200-6147
  info@thinknext.co.in           Locate Us
PayTM 7837433597
    *Applications are invited for Free 6 Months/6 Weeks Industrial Training. Email your resume at information@thinknext.co.in (Limited Seats).    
Applications are invited for Free 6 Months/6 Weeks Industrial Training. Email your resume at information@thinknext.co.in (Limited Seats).    
Members Members
Stipend based Industrial Training in Chandigarh Mohali

Advance Excel Course Training in Chandigarh Mohali

ThinkNEXT Technologies Private Limited is the best company for Advanced Excel MIS VBA Access Course Training in Mohali & Chandigarh.

Microsoft Excel is a spreadsheet establish by Microsoft for Windows, macOS, Android and iOS. Its main function is calculation, graphing tools, pivot tables, and a macro programming language.

Excel has the same basic features as every spreadsheet, which use a collection of cells arranged into rows and columns to organize data manipulation. They also display data as charts, histograms and line graphs.

Learn the expert features and functions in Microsoft Excel, alongside our expert trainers, we help you & get you beyond the basics and have advanced-level proficiency within the Excel, here join the best offerings with brand ThinkNEXT.

In this course we’ll cover all the basic & advanced concepts of Excel, including SUM, MIN, MAX and other conditional statements, we will quickly move onto more advanced-level topics including VLOOKUP and HLOOKUP, IF statements, Sparklines, Pivot Tables and Charts, Macro Operations. Suitable for beginners with Microsoft Excel but also for those who wish to cover the advanced topics in Excel, which will enable you to use Excel expertly within in a personal or commercial environment.

What is going to be covered in this best Advanced Excel Access Training in Mohali

  Using advanced graphs and presentation techniques to maximize impact.
  How macros and VBA automate your spreadsheets and increase interactivity.
  How superpower functions can solve complex problems.
  Using PivotTables and PowerPivots to turn raw data into clear information that supports key decisions.

Session 1: Introduction

  Introduction
  Interface
  Tabs and Ribbons
  Document Windows
  Navigation Tips
  Office Button and Save

Session 2:

  Entering, Editing and Formatting Data
  Introduction
  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

  Introduction
  Currency Format
  Format Painter
  Formatting Dates
  Custom and Special Formats

Session 4: Managing Worksheets

  Introduction
  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

  Introduction
  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

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

Session 7: Changing Views

  Introduction
  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

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

Session 9: Conditional Formatting

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

Session 10: Tables

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

Session 11: Data Tools

  Introduction
  Data Validation
  Drop-Down Lists
  Removing Duplicates
  Text to Columns
  Goal Seek
  Scenario Manager

Session 12: Referencing Formulas

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

Session 13: Ranges and Dates

  Introduction
  Cell Names
  Named Ranges
  Formulas with Cell Names
  Date Formulas

Session 14: Lookups

  Introduction
  VLOOKUP
  VLOOKUP Exact Match
  HLOOKUP
  HLOOKUP Exact Match

Session 15: Conditional Logic

  Introduction
  IF Statement
  Nested IF
  AND
  OR
  NOT
  IFERROR
  SUM IF
  AVERAGE IF
  COUNT IF & COUNT IFS
  SUMIFS
  AVERAGE IFS

Session 16: Text Formulas

  Introduction
  Case Formulas
  Fix Number Fields
  Trim Spaces
  Substitute Text
  Session 17: Introduction to Charts
  Introduction
  Chart Types
  Instant Chart
  Update Chart
  Column Chart
  Picture Fill
  Adjust Chart Size
  Line Chart
  Scatter Chart

Session 18: Formatting Charts

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

Session 19: Adding Graphics to Spreadsheets

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

Session 20: Outline, Sort, Filter, and Subtotal

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

Session 21: PivotTables

  Introduction
  Creating PivotTables
  Choosing Fields
  PivotTable Layout
  Filtering PivotTables
  Modifying PivotTable Data
  Pivot Charts

Session 22:

  Protecting Data
  Introduction
  Workbook Passwords
  Protecting Workbooks
  Unlocking Cells

Session 23: Collaboration

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

Session 24: Printing

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

Session 25: Saving a Workbook

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

Session 26: Macros

  Introduction and 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



Book My Free Demo Class Now!