tally course Banner

ADVANCED MS – EXCEL - Training

45 days
Daily 2 Hours
Certification
Download Course Material
image1

Advanced Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel 2013, Advanced Excel is designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve complex data. It will help all those readers who use MS-Excel regularly to analyze data.

Course Fees Rs 3500
Course objectives:
ADVANCED MS – EXCEL 2007/2010/2013
  • INTRODUCTION TO MS- EXCEL
  • USES OF EXCEL
  • BASICS OF EXCEL SHEET
  • VIEWS OF EXCEL SHEET
  • SPREED SHEET
  • WORKSHEET CALCULATION
MENU TABS:
  • OFFICE BOTTON/FILE
  • HOME
  • INSERT
  • PAGE LAYOUT
  • FORMULAS
  • DATA
  • REVIEW
  • VIEW
  • PICTURE TOOLS
  • DRAWINGS TOOLS
  • DESINGINGTOOL
FUNCTIONS IN EXCEL:
  • GENERAL FUNCTIONS.
  • SUM FUNCTIONS.
  • LOGICAL FUNCTIONS.
  • MATHEMATICAL FUNCTIONS.
  • STATISTICAL FUNCTIONS.
  • TEXT FUNCTIONS.
  • DATE &TIME FUNCTIONS.
    • DATEDIF FUNCTIONS.
    • STRING MANIPUCATIONS
  • LOOKUPS
  • V LOOKUP
  • V LOOKUP MATCH.
  • V LOOKUP SHEET TO SHEET.
  • VLOOKUPSHEETTO SHEET MATCH.
  • V LOOKUP BOOK TO BOOK.
  • VLOOKUPBOOK TO BOOK MATCH.
  • H LOOK UP
    • H LOOKUP MATCH
    • H LOOKUP SHEET TO SHEET.
    • H LOOKUP SHEET TO SHEET MATCH.
    • H LOOKUP BOOK TO BOOK.
    • HLOOKUP BOOKTO BOOK MATCH.
    • OFFSET
    • RIGHT LOOKUPS
    • DOUBLE LOOKUPS
    • CONDITIONAL LOOKUP
    • INDIRECT
    • INDEX
    • PAYROLL CREATION
    • REPORTING
    • ADD INS
    • DYNAMIC CHARTS
    • MISREPORTING&DASHBOARD PREPARATION
    • TEMPLATES CREATION

Coming Soon

Idea Computers Tally Academy Certification Process:

At the end of your course, you will work on a real time Project. You will receive a Problem Statement along with a data-set to work. Once you are successfully through the project (Reviewed by an expert), you will be awarded a certificate with a performance-based grading. If your project is not approved in 1st attempt, you can take extra assistance for any of your doubts to understand the concepts better and reattempt the Project free of cost.
90 hours training by working professionals on the same platform.
Course completion certificate will be issued.

Upcoming Batches


Mon

7:00 AM - 9:00 PM IST


Wed

7:00 AM - 9:00 PM IST




About The Instructor

Joshua Munoz
Tally Instructor