Advanced Excel Training

Advanced Excel Training

image

Description

Microsoft Office Online Training Course covers in-depth training for Microsoft Office including Advanced Excel, PowerPoint and Word Tutorial with Practical Examples and Live Documents. After completing this course, you will be able to work faster and smarter with Advanced Excel and will improve your overall Office Productivity.

What you'll learn

  • Excel User Interface
  • Auto Series
  • Addition and Subtraction
  • Multiply and Divide
  • Conditional Formula – IF
  • Complex Conditional Formula IF
  • AND OR Function
  • Fix Reference
  • Working with Date
  • Working with Time
  • Cell Formats
  • Conditional Formatting
  • Paste Special
  • Charts and Graphs
  • Filter and Sorting
  • Pivot Table
  • Slicer and Timeline Filters
  • Sparklines
  • Power View
  • Freeze Pane
  • Protecting Sheets
  • Data Validation
  • Removing Duplications
  • V and H Lookup
  • Importing Data
  • Navigating
  • Working with Sheets
  • Excel Contingency Table
  • Printing Sheets
  • Page Break
  • Flash Fill
  • Loan EMIs (PMT)
  • Fixed Deposits (FV)
  • Recurring Deposits (FV)
  • Investment (PV)
  • Interest Rate
  • Goal Seek
  • Min and Max
  • Average Function
  • Count Function
  • Misc. Functions
  • Navigation Shortcuts
  • Powerful Tricks
  • Macros in Excel

Frequently Asked Questions :

How will I get Training ?

Once you make Fees Payment, we will send you Download Link within 24 working hours. You can download all Contents and access it offline. We will also courier you DVD on your registered address within 7 to 15 days depending upon geography. Shipment of DVD is done in India only.

How can I join MS Office Online Training Course ?

You can join this Course by making ONLINE PAYMENT HERE. You can also deposit Cash / Cheque / NEFT to below account :-

Account Name:SD WEB SOLUTIONS
Bank Name:ICICI Bank
Account Type:Current
Account Number: 102005001617
Branch: Ekta Nagar Bareilly
Pin Code:243001
IFSC Code:ICIC0001020

If you are residing OUTSIDE INDIA, then you can make payment through PAYPAL or INSTALMOJO.

Is it difficult to learn ?

Absolutely NOT. Topics are explained through step by step process in a very simple language which is easy for students to understand and learn. You just need to have basic knowledge of computers.

What is the duration of Course ?

Generally it takes 30 to 45 days to complete entire MS Office Course. However you can access entire course till 1 year. DVD and Download Link Contents come with Serial Key protection with 1 year validity on 1 computer.

What about Doubts and Queries ?

We provide Email Support till 1 year for doubts and queries.

What about Exams and Certification ?

Once you complete your course, you can appear for Online Exams which are in MCQ format. On passing exams, you will be awarded with MS Office Expert Course. Passing Marks 60% and you will get 3 attempts.

Will I get Practice Files ?

Yes we have created Practice Files that contains Professional and Live Documents for each and every session that you will learn. This will help you to focus on the Topic you want to learn in a more Practical Way.