+91 9168550888 www.tallyaurangabad.com

Advanced Excel Course

 1 Module Advanced Excel 

  • Introduction of Excel
  • Home, Insert, Page Layout,
  • Formulas, Data, Review, View
  • Format Tabs with Basic
  • Pivot Table, & Charts
  • Data Validation
  • with Slice mode Active
  • Introduction of Excelx`
  • Startup with Basic Excel
  • Home Insert Page Layout with Advanced Tab
  • Format Data, review, & View with Advanced Tab
  • Auto Fill Advanced Command
  • Auto Text Proofing Option
  • making Sheet and Format
  • Conditional Formatting
  • VLookup, HLookup
  • Pivot Table,& Charts
  • Slice Mode Active
  • Data Validation,
  • Custom List
  • Protect Worksheet
  • Advanced Sheet Security
  • Data Security Password
  • Freeze Panes Data Tools
  • Micros Work (Auto)
  • Add-Ins Advanced save

2 Module Professional Excel 

  • SmartArt Graphic
  • Illustrations
  • Auto Current Text
  • Customize Ribbon Form Fill
  • Name Manager
  • Auto Fill Filter Setting
  • With 40 Formulas
  • IF+DatedIF Formulas
  • Data Connection
  • Multi Sheet Link with there Data
  • Folder Sheet Connection
  • Online Excel Line
  • Connection with Email ID
  • Online Sharing Excel Sheet
  • Printing and Page Setup
  • Advanced Project in Excel
  • Advanced Custom List Maximum
  • Sheets Work
  • (Result Sheet, Salary Sheet,
  • VLookup, HLookup
  • Pivot Table,& Charts
  • Slice Mode Active
  • Data Validation,
  • Protect Worksheet
  • Freeze Panes Data Tools
  • Micros Work (Auto)
  • Name Manager
  • Auto Fill Filter Setting
  • With 40 Fromulas
  • Data Connection
  • Sheet Link
  • File Line Connection
  • Advanced Costume List Maximum

3 Module Real Work in Excel 

  • Sheets Work
  • (Result Sheet, Salary Sheet, Sales Report Sheet, Expenses Sheet)
  • Production Sheet, Attendance
  • Sheet, Expenses Sheet, Annual Report)
  • Advance Project in Excel
  • Production Sheet, Attendance
  • Sheet, Expenses Sheet, Annual Report)
  • Advance Project in Excel
  • Sheet Print using Mail Merge
  • MS-World Link with Excel List

Module Online Excel 

  • Online Excel With Google
  • on Gmail Mail Sharing Sheet or Data
  • Online Manage Excel Data
  • Teem work on Excel Sheet
  • one sheet may user
  • Online Excel Sheet Access
  • Online Sheet download