Advanced Microsoft Excel

Evanson Training

Add to wishlist

Price: AED 1,800

Location: Knowledge Village - Dubai
Duration: 2 Days
Timings: Full Time, 9:00am - 4:00pm

Call: +971 4 4542450

Course details

By attending this course, you will learn how to apply data analysis techniques to improve your operational and project based work. You will be able to review a range of tools and choose the right ones for the particular application and produce analyses and diagrams that make your reports and business cases easier to read and more effective.
What will I learn?

Unit 1: Conditional Formatting
Unit 2: Sorting Data
Unit 3: Filtering Data
Unit 4: Filling Data
Unit 5: PivotTables
Unit 6: Dynamic table (New feature)
Unit 7: Charting Techniques
Unit 8: Creating Charts
Unit 9: Advance Validation
Unit 10: Text options
Unit 11: Macros
Unit 12: File / Data Security
Unit 13: Formulas
Unit 14: Formula Referencing

Target Audience:
This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks.
Students should have already completed Excel 2010 Level 1 course or know how to create and save an excel workbook, enter simple formulas and print and chart data. Updated on 28 August, 2018

Course Location

Show map Location Knowledge Village - Dubai

About Evanson Training

Who we are?
We help organisations and individuals achieve results in the areas of Finance, Accounts, Reports, Audit, Work Management and Operational Efficiencies.
What we do?
Our team of experts can help you select the right initiatives, deeply customize our training solutions to fit your world, and excel at delivering your training through our network of top-rated facilitators, who have frontline industry experience.
How we do it?

We take the time to listen and understand your needs and your situation. And then we define training objectives.
Careful need analysis helps us develop training solutions in the context of addressing your specific objectives.
After successful completion of training we direct you towards productivity and performance, under guidance of industry experts in our network.

See all Evanson Training courses

Ask Laimoon

View more similar courses

See all current Microsoft Excel jobs in UAE

Courses you can instantly connect with... Do an online course on Microsoft Excel starting now.