Advanced Excel Training – WEEKEND Classes in Al Nahda-Call us, Sharjah

  • Listed: October 15, 2016 2:44 pm
  • Expires: This ad has expired
  • Mobile: 0503034197
  • Street: Office #802, Sahara tower 2, Near Sahara Centre, Al Nahda Street. Sharjah. UAE, 67804 Sharjah, United Arab Emirates, 67804 Sharjah, United Arab Emirates
  • Land Mark: Sahara Centre
  • Emirates: Sharjah
  • Country: United Arab Emirates
  • Phone: 0503034197
  • Website: http://www.almihadit.com

Description

Looking for an Excel course/Training for beginners to experts? This online course/Training 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

Other Courses/Training : Microsoft Office | Advanced Excel | Graphics Designing | Web Designing |Tally Erp 9 | Quickbooks | Peachtree | MCSA | MCSE | CCNA | CCNP | CCIE | AUTOCAD | REVIT | 3DS MAX | Interior Designing Please Contact us : 050 30 34 197 / 06 530 999 2 or email us : info@almihadit.com for the detailed information and table of contents / course outline

Share with Friends

Mention that you found this ad on Bibango.com when you Call or Message.

Listing ID: 9985801e3044d179

Report problem

Processing your request, Please wait....