Advanced Excel Training - Get 30% off on Ramadan Special offer

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 : [email protected] for the detailed information and table of contents / course outline