Categories

 

 

Request More Info

Seeking details for:

Myself
My team/Organization
Corporate/Customized Training

Advanced Microsoft� Excel 2013

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.

Enroll in the KnowledgeWoods Advanced Microsoft® Excel Training Program where you will:

  • LEARN
  • UNDERSTAND
  • PRACTICE &
  • APPLY

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

Program Outline

ModulesTopics
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

 

     

     

    Request More Info

    Seeking details for:

    Myself
    My team/Organization