Microsoft Excel training in Dubai
- March 14, 2016
- Posted by: safi
- Category: Blog
Microsoft Excel training in Dubai, Uae is just what you’ll need to increase excel skills and experiences to prepare best excel report, excel for confidence and take your current excel skills to the advance level!
Benefits of Microsoft excel advanced training:
Excel training advance skills you’ll gain in this one week is more practical in less time to use at your work place. Microsoft Excel training Courses provides you to work with hands-on exercises without wasting your valuable time.
ADVANCED EXCEL COURSES IN DUBAI
MICROSOFT EXCEL 2003/ 2007 / 2010 / 2013
FOR OFFICE PURPOSE Excel Courses
- Introduction to the Excel
- Understanding the Excel interface, using the Ribbon, tabs and Excel OPTIONS
- Formula building, and Advanced formulas, Nesting formulas
- Debugging formulas using various techniques
- Data Extracting Techniques and Data Mining techniques
- Data Validation and linking with formulas
- Advanced Filters, AutoFilters, Named Ranges
- Using Tables , Using Subtotals, Vlookups & Hlookups
- How to extract duplicate entries where vlookup doesn’t work..
- Pivot tables and Pivot charts
- Advanced Charts and Dynamic Charts, Automatic updating Charts, waterfall chart
- Basic Macros & VBA understanding
- Protection, Shared Workbooks, Track Changes, Merging Workbooks
- Goal Seek and Data Tables
- Custom Views, Freeze panes, Watch Window, Using Save workspace
- Using Hyperlinks, Comments, Using Pictures in Comments
- Advanced VLOOKUP, Advanced use of Index & Match
- Advanced use of INDEX, OFFSET, INDIRECT
- Advanced use of IF STATEMENS
- Using DATES and Time Functions, Using Find and Replace
- Introduction to Excel Dashboards and reporting for MANAGERS
- LEARNING KEYBOARD Shortcuts to speed up…….
- Conditional Formatting
- Using the New sparklines features and Slicers in Excel 2010 & Excel 2013
- Using Themes & cell styles
- Data Consolidation and Merging workbooks
So looking for Microsoft Excel Training Courses in UAE, or worried about how to learn Microsoft Excel come and Join us at Safi Training Center and get qualified for Job in Dubai.