0 student
  • Full 2 Days interactive classroom training
  • Copyrighted Approach
  • Dedicated, Toll-Free, Post Training Support & MSP Query Handling Facility over E-mail Lunch, Tea, Snacks etc. during the Training/Workshop
  • Proven Learning Model based on Bloom’s Taxonomy
  • Hands on Exercises for each Module
  • Training Sessions delivered by Microsoft® Certified Trainers
  • Best-in-Class Workshop Deliverables
  • Comprehensive Participant Feedback Mechanism
  • Option to Attend Classroom & Live Learning
Description The Microsoft® Excel is a spreadsheet application that is primarily used for dealing with complex data manipulation and analysis related tasks. The application effectively helps in turning vast amounts of raw data into well-organized meaningful information in minimal timeframes, thereby expediting the overall quality and delivery of work.   Appropriate knowledge about the optimal use of the Microsoft® Excel software considerably adds to one’s productivity at the workplace, and this is why advanced level training on Microsoft® Excel 2013 is considered to be the need of today for professionals involving Microsoft® Excel as a part of their daily work routine.   Here is YOUR chance to Learn the Microsoft® Excel Tools and Techniques by enrolling in our Hands-on Advanced Microsoft®Excel Training workshops where you get to learn the Microsoft® Excel formulas, shortcuts, macros and much more that help raise your efficiency and effectiveness at work.   Invest Two (2) Days in Knowlettwoods Advanced Microsoft® Excel Training Program:
Important Microsoft® Excel features and functionalities to unlock the full potential of the software! With significant updates, Microsoft® Excel allows you to:
  • Enhance your productivity and efficiency at work
  • Manipulate large amounts of data with minimal requirements of time
  • Perform the most complex of calculations with much ease
  • Easily connect and share information with other people across the world
When participants attend KnowledgeWoods Advanced Microsoft® Excel Training, they learn to leverage the maximum potential of the application that helps raise their productivity as well as accuracy at work. As such, with Advanced Microsoft® Excel Training, professionals gain a better understanding of:
  • Microsoft®Excel Formulas and Macros
  • Data Analysis and Manipulation using Excel tools and techniques
  • Sharing and Collaborating information with other users


Knowlettwoods is an established name in the Training and Education industry of India, and has been successfully delivering world class hands-on training programs for an array of Microsoft® Courses including Microsoft® Dynamics CRM 2011, Microsoft® SharePoint Server 2013, Microsoft® Project 2013, Microsoft® Project Server 2013, etc. to name a few.   We have a dedicated team of skilled and experienced Microsoft® Certified Trainers (MCTs) who have been consistently helping participants to gain practical understanding of the key fundamentals, concepts and applications that aid in unlocking the potential of Microsoft® Excel 2013 software.   Candidates registering for our Advanced Level Microsoft® Excel Training Program are provided with a set of high quality, easy-to-comprehend reference material and practice questions that facilitate deeper and better understanding of the concepts taught during the training.   Register Now for our Advanced Microsoft® Excel 2013 Training and Prepare to Advance High in your Career Ahead!   Attend our Advanced Microsoft® Excel 2013 Training Program and you will learn:
  • How to customize the Excel workspace
  • The best practices for designing and managing worksheets
  • How to create formulas and functions
  • How to perform statistical, what-if, and other data analysis
  • Core to advanced charting techniques
  • How to manage databases and tables
  • How to automate excel with macros and custom functions
  • How to collaborate in Excel online and in cloud
 Course Content
Modules Topics
Excel Fundamentals ·         Statistics, Rows, Columns, Sheets, and Cells ·         Data Presentation Techniques ·         Understanding Range Names ·         Working with Multiple files at ease
Advanced Formulas and Functions ·         If with And/Or/Not, SumIf, CountIf, CountBlank, CountA, Concatenate, VLookup, HLookup, Match, Round, Search, Find, Replace, and Substitute ·         Consolidate Sum (3D Sum) ·         Understanding error messages like #Value, #NA ·         Handling Error Values ·         Formula Auditing
Custom Formats and Layouts ·         Conditional Formatting ·         Format following Maximum/Minimum value ·         Remote Controlled Formatting ·         Graph with Conditional Formatting
Advanced Charts and Tables ·         Drawing Pivot Table from data entered ·         Multi-page display ·         Multi-function ·         Virtual Column Creation ·         Grouping ·         Using Outline features ·         Copying only visible cells
Managing Data ·         Defining Pre-set filters ·         Creating Unique Data List ·         Custom Sorting ·         Creating Unique Validation List ·         Protection ·         Goal Seek, Solver ·         Smart Copy/Paste features
Working with Macros ·         Recording Macros ·         Understanding recorded macros ·         Writing macros ·         Creating mini solutions


Curriculum is empty

0.00 average based on 0 ratings

5 Star
4 Star
3 Star
2 Star
1 Star

Course Features

  • Lectures 0
  • Quizzes 0
  • Students 0
  • Assessments Yes

Leave a Comment

Your email address will not be published. Required fields are marked *