Sunday 19 November 2017

Advanced MS Excel






    Advanced MS Excel Training in Bangalore - Live Online & Classroom

    Gain a strong foundational knowledge of Advanced MS Excel and become a certified ProAdvisor. Master the art of managing your clients' books in Advanced MS Excel and customizing it so you're equipped to fulfill the needs of any client. Getting certified in Advanced MS Excel is the best way to enhance your professional profile, showcase your expertise and attract new clients.
    Chapter 1: Getting Started
    Excel Overview
    Excel Ribbon/Menu Commands
    Basic Data Manipulations
    Managing Workbooks & Worksheets
    Formatting Basics
    Excel Hierarchy

    Chapter 2: Functions
    Logical Functions
    Arithmetic Functions
    Date Functions
    Aggregations
    Strings

    Chapter 3: Complex Formulas & Functions
    Lookup Formulas
    1. Vlookup
    2. Hlookup
    3. Nested Vlookup
    Advanced referencing functions
    1. Index
    2. Match
    3. Offset & etc

    Chapter 4: What-if Analysis
    Goal-Seek command
    Using Data Tables
    Scenarios
    Merge scenarios from another worksheet

    Chapter 5: Chart & Layouts
    Creating Charts using chart wizard
    Useful Graphs & Charts
    1. One Axis Graphs
    2. Two Axis Graphs & etc
    Gantt Charts

    Chapter 6: Pivot Tables
    Steps to create Pivot Table
    Arranging fields (Methodology –How & Why)
    Formatting Pivot Table
    Introducing Slicing Tool
    Managing & Formatting Slices

    >> Read more >>



    Posted by at

    6 comments:

    1. ganga pragya29 August 2018 at 05:27

      Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.Rprogramming Training in pune

      Rprogramming Training in

      Bangalore

      Rprogramming Training in btm

      Rprogramming Training in bangalore

      Rprogramming Training in tambaram

      Rprogramming Training in annanagar

      ReplyDelete
    2. sunshineprofe23 November 2018 at 22:38

      Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.
      fire and safety course in chennai

      ReplyDelete
    3. user1237 March 2019 at 22:00

      Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
      Data Science Training in Chennai
      Robotic Process Automation Training in Chennai
      Cloud Computing Training in Chennai
      Data Warehousing Training in Chennai
      Dev Ops Training in Chennai

      ReplyDelete
    4. Unknown17 October 2019 at 00:58

      Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.

      Best PHP Training Institute in Chennai|PHP Course in chennai
      Best .Net Training Institute in Chennai
      Dotnet Training in Chennai
      Dotnet Training in Chennai

      ReplyDelete
    5. Janu30 May 2020 at 03:54

      Thanks for your informative blog!!! Your article helped me to understand the future of .net programming language. Keep on updating your with such awesome information. .net



      Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery


      ReplyDelete
    6. Unknown8 December 2020 at 09:41

      Thank you for sharing the article. The data that you provided in the blog is informative and effective
      Java training in chennai

      python training in chennai

      web designing and development training in chennai

      selenium training in chennai

      digital-marketing training in chennai

      ReplyDelete

    Subscribe to: Post Comments (Atom)