It has come to our attention that an unauthorized individual is falsely claiming to represent Knowlett Learning LLP / Knowledgewoods and is contacting people through WhatsApp, phone calls, and other channels to offer paid services such as resume writing, training, career guidance, and job assistance using our company’s name. Knowlett Learning LLP has not authorized any such person to collect payments or provide services on our behalf. Such individuals are engaged in fraudulent activities, and anyone dealing with them does so at their own risk. Knowlett Learning LLP / Knowledgewoods will not be responsible for any payments made to unauthorized persons. Do not make any payment to any individual account. Report suspicious activity immediately at: 📞 ‪+91-9540610005‬ / ‪+91-9540610006‬

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.

Invest Two (2) Days in KnowledgeWoods Advanced Microsoft® Excel Training Program:

  • 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
Enroll Now

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

    >

    >