Advanced Excel Workshop – Trained people perform better than the rest - Sharjah

Looking for an Excel course for beginners to experts? This online course has something for everyone, covering beginner, intermediate and advanced lessons in Excel.
• Beginner’s Introduction to Excel
• Basic Formatting Techniques
• Absolute and Relative Cell Referencing
• Conditional Formatting
• Naming Ranges and Cells
• Auto-Filter and Advanced Data Filtering
• Advanced Pivot Tables
• Creating and Designing Charts (including Sparklines)
• Data Validation
• Formula Auditing & Formula Evaluation
• Protecting and Hiding Information and Formulas
• Advanced VLOOKUP Examples
• Advanced INDEX & MATCH Lookup Examples
• Macros
• What-If Analysis (Guest Lesson)
• Grouping and Ungrouping Rows / Columns
• How to Write Complex Custom Formulas Using Multiple (i.e. nested) Functions
• Protecting and Hiding Information & Formulas
• Advice on Setting Up Models, Worksheets, and Intelligent Data Structure
• What-If Analysis (Data Table, Goal Seek, etc) and the Solver Add-In
• Setting Up Useful Templates to Help Automate Work
• Additional Functionality & Advanced Usage of Pivot Tables
• Presentation Options For Data / Information
• Copying / Pasting Functionality (values, transpose, formatting, constants, links, etc.)
• Introduction to PowerPivot
• Additional Macro Walkthroughs and Advanced Training in VBA Programming
• Creating User Defined Functions in Excel
• Creating your own personal Macro Workbook that you can use on any active workbook.

We offer a variety of Excel training courses covering all aspects of spreadsheet use including using Excel in financial and decision model.

What's Included in your Excel Training
• Pre-Course Assessment
• Hands-On Instructor Led Training
• Assignments and Real time excercises
• Post Training Support (On Job)
• Free Study material pdf

Have we convinced you yet? If so the next step is to give us a quick phone call on : 06 530 9992 / 050 30 34 197 or email us : [email protected] for your training requirements.
 

Posted on : 7 years ago, #46676, 1 views, Edit

It is NOT ok to contact this poster with other commercial interests.

Promote this ad QR code Report as inappropriate