Learners Point

Public Courses


Advanced Excel Enquire Now

Course Summary

  • About the Course

    Formulas, Macros make Excel smarter. without them, MS Excel is just a database. But by using its advanced features like formulas, you can crunch data, analyze  and get simple solutions to most complex questions.

    Who needs the course

    HR Professionals, Payroll professionals, Sales & Marketing Professionals, Finance Professionals and anyone who needs to maintain various cuts of data.

Course Contents

  • Modules

    module 1          Document navigation

    module 2          Using formatting function      

    module 3          Conditional formatting and vlook up function     

    module 4          Using templates and workbook        

    module 5          Working with data        

    module 6          Pivot table           

    module 7          Consolidation of data   

    module 8           Scenarios

    module 9           Trend lines         

    module 10        Macros and auditing workbook       

    module 11        Sharing books and protecting           

    module 12        Data tables and vba variables

    Course Outcome

    The purpose of this course is provide students the necessary skills to use MS Excel in the workplace as an analysis and presentation tool, above and beyond the average skill level of most users  thus making the student  more attractive candidate in the job market.

Apply for jobs @ LearnersPoint