advance-Excel-courses

Advance Excel is a Software which is introduced by Microsoft.It is not free version of the Software family. This Software helps people to anaylze and maintain data in graphs which helps you to analyze the on and off of data.

Learning this software potential is more important t o the people who are working in a company and analyze the data. This course is best for B.com student who wants to grow thier journey in calculation data.

What You Get During Session :

  • Get Better Session.
  • Therotical Session.
  • Pradctical Session.
  • Portfolia

Career Gate :

  • Graphic Designer
  • Design Manager
  • Web Designer
  • Logo Designers

Course Curriculum

  • Introduction
  • Interface
  • Tabs and Ribbons
  • Document Windows
  • Navigation Tips
  • Office Button and Save
  • 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
  • Introduction
  • Currency Format
  •  Format Painter
  • Formatting Dates
  •  Custom Special Formats
  • Introduction
  • Naming and Moving Worksheets
  • Copying Worksheets
  • Adding, Deleting and Hiding Worksheets
  • Grouping Worksheets
  • Moving, Copying, Deleting and Hiding Grouped Worksheets
  • 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
  • Introduction
  • Using Operations
  • Creating Formulas
  • AutoSum
  • Common Formulas
  • Searching for Formulas
  • Copying Formulas
  • Using Relative and Absolute References
  • Introduction
  • Workbook Views
  • Show/Hide
  • Zoom Features
  • Freeze Panes
  • Split Windows
  • Viewing Multiple Windows
  • Minimize The Ribbon
  • Worksheet
  • Backgrounds
  • Watermarks
  • Introduction
  • AutoFill a Series
  • AutoFill Non-Adjacent Cells
  • AutoFill on Multiple Sheets
  • Creating Custom Lists
  • Series Formatting
  • Introduction
  • Highlight Cells Rules
  • Top/Bottom Rules
  • Data Bars
  • Color Scales
  • Custom Formatting Rule
  • Introduction
  • Insert a Table and Style Options
  • Add Rows and Columns
  • Perform a Function in a Table
  • Summaries With Pivot Table
  • Introduction
  • Data Validation
  • Drop-Down Lists
  • Removing Duplicates
  • Text To Columns
  • Goal Seek
  • Scenario Manager
  • Introduction
  • Multiple Sheet References
  • Consolidating Data – With or Without Links
  • Trace the Precedents and Dependents
  • Using the Watch Window
  • Introduction
  • Cell Names
  • Named Ranges
  • Formulas with Cell Names
  • Date Formulas
  • Introduction
  • VLOOKUP
  • VLOOKUP Exact Match
  • HLOOKUP
  • HLOOKUP Exact Match
  • Introduction
  • IF Statement
  • Nested IF
  • AND
  • OR
  • NOT
  • IFERROR
  • SUMIF
  • AVERAGEIF
  • COUNTIF & COUNTIFS
  • SUMIFS
  • AVERAGEIFS
  • Introduction
  • Case Formulas
  • Fix Number Fields
  • Trim Spaces
  • Substitute Text
  • Introduction
  • Chart Types
  • Instant Chart
  • Update Chart
  • Column Chart
  • Picture Fill
  • Adjust Chart Size
  • Line Chart
  • Scatter Chart
  • Introduction
  • Chart Styles
  • Chart Layouts
  • Add Labels
  • Axis Options
  • Chart Title
  • Legends
  • Data Labels
  • Introduction
  • Insert Pictures
  • Modifying Pictures
  • Insert Shapes
  • Insert SmartArt
  • Apply Themes
  • Arrange
  • Introduction
  • Group and Ungroup
  • Sort Data
  • Sort Multiple Levels
  • Filter Data
  • Advanced Filter
  • Conditional Sorting and Filtering
  • Sorting with Custom Lists
  • Subtotal
  • Introduction
  • Creating Pivot Tables
  • Choosing Fields
  • Pivot Table Layout
  • Filtering Pivot Tables
  • Modifying Pivot Table Data
  • Pivot Charts
  • Introduction
  • Workbook Passwords
  • Protecting Workbooks
  • Unlocking Cells
  • Introduction
  • Document Properties
  • Inserting Hyperlinks
  • Sharing a Workbook
  • Track Changes
  • Accept/Reject Changes
  • Mark as Final
  • Introduction
  • Page Orientation
  • Page Breaks
  • Print Area
  • Margins
  • Print Titles
  • Headers and Footers
  • Scaling
  • Sheet Options
  • Introduction
  • Save As Previous Version
  • Auto Recover Save Options
  • Templates
  • Save As PDF
  • Save As Web Page
  • Macro-Enabled Workbook
  • Introduction and Macro Security
  • Recording a Macro

About Our Company

Our Organization Established in 2010 .For Many year we are serving In Education Field .We prepare a full module course to prepare for the specific target. We Have Different Course Module which ever helps you to learn .Our Organization gave you the certificate Which is government authorized.The Certificate is valued when it work everywhere. Our Company is certified with ISO 9001:2015. Centre Is under guidance of Group Captain Rajesh Pandey which really very keen about the serving people in education Field.