Advance Excel

Advance Excel

Microsoft Excel is a spreadsheet program. It’s highly used in companies for data manipulation and formation. It is extremely used for the creation of reports and maintain data in a proper way. Excel is widely used to perform Formulation of data, pictorial representation, logical and conditional operations on data in all valuable organization & their departments like finance, HR, operation, purchase, sales, banking, insurance etc.
It has special features like Lookup, Vlookup, H lookup, point table, point chart, Macros, filters, data validation, consolidation etc. with the help of these features user creates attendance sheet, payroll management, consolidate report, quotation, budget plans, financial reports, income and expenditure report, especially for MIS report.
At Genext we provide practical training on excel with the help of real-time examples. More than 100 formulas & their live practice on different sheets & assignment will make you confident to operate excel thoroughly in your field.

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