Advanced Excel

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.

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.

Coporate Clients

Contact Us

Suite #101, AL-Tawhidi1 Building, Next to ADCB Bank, Bank Street, Khaled Bin Waleed Road, Bur Dubai - Dubai. U.A.E. P.O.Box: 94743 Dubai, UAEa

Follow Us

News & Events

Professional training on FICO, MM, SD, HR modules covering Basic Inter...

Read More

Join now the advance level courses and get trained with our industry e...

Read More

Do you have desire to work, study or migrate to English Speaking Count...

Read More

Locate Us