Advance Excel

Getting Acquainted with excel

  • About Excel
  • The Excel Environment
  • The Title Bar
  • The Ribbon
  • Scroll Bar
  • The Microsoft Office Button
  • The Quick Access Toolbar
  • The Formula Bar
  • The Work Book Window The Work Book View Buttons
  • The Zoom Slider
  • The Mini Toolbar
  • The Keyboard Shortcuts

Creation Basic Work Books

  • Creating New Work Books
  • Saving New Work Books
  • Closing Work Books
  • Opening Work Books
  • Selecting Cells
  • Entering Text Into Cells
  • Number Into Cells
  • Auto Complete
  • Pick From Draft-Down List
  • Using The “Window “Command Group
  • Switching To Full Screen View
  • Renaming Work Books
  • Working With Excel File Formats

Using Ranges

  • Selecting Ranges
  • Ranged Data entry
  • Using AutoFill

Creating Formulas

  • Ranged Formula Syntax
  • Simple Formula Syntax
  • Writing Formulas
  • Using Auto Sum
  • Inserting Functions
  • Editing A Range
  • Formula Auto Correct
  • Auto Calculate

TABLES

  • Creating A Table
  • Adding And Editing Records
  • Inserting Records And Fields
  • Deleting Records And Fields

Copying & Pasting formulas

  • Relative Reference And Absolute Reference
  • Cutting, Copying Pasting Data
  • Auto Filling Cells
  • The Undo Button
  • The Redo Button

Columns And Rows

  • Selecting Columns And Rows
  • Adjust Column And Width Of Row Height
  • Hiding And Unhanding Columns And Rows
  • Inserting And Deleting Columns And Rows

Formatting Worksheets

  • Formatting Cells
  • The Format Cells Dialog Box
  • Clearing All Formatting From Cells
  • Copying All Formatting From Cells To Another Area

Working Sheet Tools

  • Moving Between Work Sheets
  • Selecting Multiple Work Sheets
  • Inserting And Deleting Work Sheets
  • Renaming Work Sheets
  • Coloring Work Sheets Tabs
  • Copying Are Moving Work Sheets

Setting Work Sheets Layout

  • Using Page Break Preview
  • Using The Page Layout View
  • The Page Setup Dialogue Box

Printing Work Sheets

  • Using Print Preview
  • Printing Work Sheets

Creating Work Sheets Charts

  • Creating Charts
  • Gantt Chart
  • Selecting Chart And Chart Elements
  • Moving And Resizing Charts
  • Changing The Chart Type
  • Changing The Data Range
  • Switching And Column And Row Data
  • Choosing A Chart Layout
  • Choosing A Chart Style
  • Printing Charts
  • Deleting Charts

Number Formatting

  • Create Custom Formula
  • The Four Parts Of A Format
  • Scaling Number

Dates And Times

  • How Date Times Are Stored
  • Use Date/Time Function
  • Formatting Date And Time

Conditional Formatting And Cell Styles

  • Conditional Formatting
  • Finding Cell With Conditional Formatting
  • Clearing Conditional Formatting
  • Using Table And Cell Styles

Validation And Protection

  • Setting Cell Validation
  • Protecting Cells/Worksheets
  • Grouping And Outline

Editing And Formatting Charts

  • Formatting Chart Object
  • Inserting Object Into A Chart
  • Changing Chart Tables
  • Changing Axes Display
  • Changing The Chart Back Ground
  • Applying Chart Analysis Lines
  • Naming Charts
  • Applying Word Art Style To Chart Elements
  • Create Gantt Chart

Security Features

  • Unlocking Cells
  • Worksheet Protection
  • Workbook Protection
  • Password Protecting Excel Files

Sorting Data

  • Sorting Data
  • Custom Sort Order

Pivot Tables

  • Creating Pivot Tables
  • Pivot Charts
  • Manipulating A Pivot Table
  • Changing Calculated Value Fields
  • Applying Pivot Tables Style
  • Sorting And Filtering Pivot Table Data
  • Swapping Rows And Columns

If Function

  • If Function
  • Nested If Function

 Lookup And Advance Lookup Function

  • V-Lookup And H Lookup Function
  • Using Match Find The Value
  • Combination Match And Index
  • Using Offset
  • Indirect Function

 Range Names And Absolute Reference

  • Fixed Only Row/Column
  • Create Range Names

Making Macros

  • Recording Macros
  • Running And Deleting Recorded Macros
  • The Personal Macro Work Book
  • Absolute/Relative Recording
  • Assigning Macros To Button

 

STUDENT BENEFITS

  • Job Assistance
  • Pay Fees in Installments / EMI
  • Technical Support after Course Completion
  • Back up Classes Available
  • Attend Demo class
  • Course Complete Certificate
  •  Lab Facility
  • Real Time Project

ADDITIONAL HIGHLIGHTS

  • Total 60  hours Class
  • 1 on 1 Trining
  •  You Get In-Depth Practical Knowledge on each Topic
  • Free Study E-Material, PDFs, Video Trainings
  • Flexible Timimg
  •  Online Trainings provided

For More Information: Call us on +917411000877

Contact us on +917411000877