• Home
  • 3D Plans
  • 3D Sketch
  • About Us
  • Admission Form
  • Advanced Excel Course
  • Auto CAD Mech.
    • AutoCAD mechanical
  • AutoCAD
  • AutoCAD Civil or Architecture Drawings
  • AutoCAD Exam Test
  • AUTOCAD EXAM2
  • AutoCAD Note Download
  • Contact Us
  • Courses
  • Download
  • DTP (Desktop Publication)
  • Exam Form
  • form 7
  • Graphic Design Advance
  • Graphic Design Work
  • Inquiry Form
  • MS-Office
  • Print Receipt
  • Receipt
  • SketchUP 3D
  • SketchUP 3D Exam Test
  • SketchUp 3D Work
  • Tally ERP9 GST
  • Tally Exam Test
  • test
  • Web Page Designing
Best CAD Classes in Aurangabad city
Class Opening Hours Mon to Fri - 08.00 AM to 08.30 PM Sun - 10.00 AM to 06.00 PM
Call Us +91 9168550888
+91 8888622096
SMS Us www.tallyaurangabad.com
www.bperfect.in
Menu
  • Home
  • About Us
  • Inquiry
    • Inquiry Form
    • Admission Form
    • Exam Form
  • Exam Form
  • Courses
    • AutoCAD
      • AutoCAD Civil or Architecture Drawings
    • Auto CAD Mech.
      • AutoCAD mechanical
    • DTP (Desktop Publication)
    • Graphic Design Advance
    • MS-Office
    • SketchUP 3D
    • Tally ERP9 GST
    • Web Page Designing
  • Student’s Work
    • Photography Work
    • Graphic Design Work
    • 3D Sketch
    • 3D Plans

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

4. 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

Contact Form

1 + 3 =

Testimonials

Mahesh Gagare
Student Hi ! This is Mahesh, I have done my training on Auto CAD and Advanced Excel training from Perfect training center in Aurangabad. The environment was outstanding, I like those days of my training.
Address B Perfect Computer Institute, 2nd floor, Opp. Ludhiyana Cycles Roxy Corner, Paithan Gate Aurangabad 431001.
Call Us +91 9168550888
+91 8888622096
SMS Us www.tallyaurangabad.com
www.bperfect.in
About Us

Vivamus sodales ipsum orci, vel bibendum nulla cursus id. Donec auctor egestas ligula nec lobortis. Aliquam tempus vehicula ligula, in tempor ex tempor vitae. Nam congue et quam sit amet finibus. In non justo a ligula condimentum tempus vel in leo. Sed ut efficitur tortor, ac viverra nibh.

Nunc nunc enim, lobortis nec nunc hendrerit, molestie rhoncus sem. In consequat, purus non tempor ultrices, eros sem faucibus massa, iaculis eleifend nisi erat at ante.

Practice Areas
  • Home
  • 3D Plans
  • 3D Sketch
  • About Us
  • Admission Form
  • Advanced Excel Course
  • Auto CAD Mech.
    • AutoCAD mechanical
  • AutoCAD
  • AutoCAD Civil or Architecture Drawings
  • AutoCAD Exam Test
  • AUTOCAD EXAM2
  • AutoCAD Note Download
  • Contact Us
  • Courses
  • Download
  • DTP (Desktop Publication)
  • Exam Form
  • form 7
  • Graphic Design Advance
  • Graphic Design Work
  • Inquiry Form
  • MS-Office
  • Print Receipt
  • Receipt
  • SketchUP 3D
  • SketchUP 3D Exam Test
  • SketchUp 3D Work
  • Tally ERP9 GST
  • Tally Exam Test
  • test
  • Web Page Designing
Office Hours

Monday --------------------------------------- 8.00AM to 8.00PM

Tuesday ---------------------------------------8.00AM to 8.00PM

Wednesday -----------------------------------8.00AM to 8.00PM

Thursday --------------------------------------8.00AM to 8.00PM

Friday ------------------------------------------8.00AM to 8.00PM

Saturday---------------------------------------10.00AM to 6.00PM

Sunday ----------------------------------------Closed

© 2016 B Perfect Training All Rights Reserved
Design by B Perfect Aurangabad