Advance Excel 2010

  • Overview

    Microsoft Excel is one the most useful tools of Microsoft Office Suite. After completing this course, students will be able to create and manage worksheets and workbooks, create cells and ranges, create tables, apply formulas and functions, and create charts and objects. This course will let students comprehend programming using the Visual Basic programming language.

    Course Objectives


    • Creating elaborate worksheets and workbooks to display data in an effective way
    • Using formulas and functions
    • Using PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports and explore how PowerPivot workbooks can be integrated with SharePoint 2010
    • Comprehend programming using the Visual Basic programming language
    • Use Microsoft Visual Basic for Applications to control Microsoft Excel programmatically

    Course Details / Exam(s)

    Schedule for Advance Excel 2010
    Course # Course Contents Exam # Regular Track (days) Fast Track (days)
    50544A Microsoft Office Excel 2010 , Step by Step Level 1 77-882 1 0.5
    50545A Microsoft Office Excel 2010 , Step by Step Level 2 1 0.5
    50546A Microsoft Office Excel 2010 , Step by Step Level 3 1 1
    50551A Useful Formulas and Functions(Microsoft Excel 2010) 1 0.5
    50448B Maximizing PivotTable (Microsoft Excel 2010) 1 0.5
    50432A Excel Programming using Visual Basic for Applications 4 2
    Total 9 5
    • Basic Computer Knowledge.
    • Basic File Management Skills like navigate to Folders and files on Windows OS.
    • Good to have programming aptitude for VBA.
    Give an edge to your career with technical certifications and training courses. Students can join the classes for Advance Excel 2010 at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.
  • Students Reviews
    Mir Uzairuddin Ansari Koenig IT Training Student

    I came to Koenig Delhi for training on Microsoft Office Advance Excel Skills. I found this course through my colleagues and Koenig website. I thank Koenig Delhi administration for good services...

    Read MoreMir Uzairuddin AnsariAfghanistan
    Abubakar Hajara Manga, Abubakar Shehu Ambursa, Aishatu Abdullahi And Aishatu Abdullahi Jega  Koenig IT Training Student

    We want to express deep pleasure in attending training with Koenig Solutions, Delhi. We are impressed by its standard and quality. The first class facilities speak volumes about the heights attained...

    Read MoreAbubakar Hajara Manga, Abubakar Shehu Ambursa, Aishatu Abdullahi And Aishatu Abdullahi Jega Nigeria
    Mark Hamlyn  Koenig IT Training Student

    Before coming to Koenig Solutions, I had no experience and have limited knowledge in the industry. I decided to come to Koenig Delhi after some self-paced training on Windows 7 but when things...

    Read MoreMark Hamlyn Australia
    Michelle J Slator  Koenig IT Training Student

    I was being sponsored by my company to do the MCAS (Microsoft Certified Application Specialist) course for Office 2007 and Windows Vista, so when it came to organising the course and preparing...

    Read MoreMichelle J Slator United Kingdom
    Adigun Oluyumibo Henry  Koenig IT Training Student

    My names are OLUWAYOMIBO ADIGUN HENRY from Lagos – Nigeria (West Africa)- I have attended Microsoft Office Specialist Course in Goa Training Center of Koenig- Solutions.My trip to Koenig was as...

    Read MoreAdigun Oluyumibo Henry Nigeria
    View All Testimonials
  • Schedule & Course Fees
  • Enquire Now