• Training

    Other

    Cyber Security
    Trending
    Ethical Hacking
    Vedic maths
    New
    Advance Excel
    Trending
    C Language
    C++ Language
    Data Structure
    AutoCAD
    Trending
    VBA Macro
    Trending

    Python

    Python
    Data Science
    Trending
    Machine Learning
    NEW
    Deep Learning
    Artificial Intelligence
    Trending
    Python Django
    R Language

    Java

    Core JAVA Training
    Advance Java Training
    Angular js
    NEW
    Node js

    Automation

    PLC
    Trending
    Solar Installation
    NEW
    SCADA
    Panel Designing
    AC Drive
    HMI
    Electrical CADD
    Trending
    Panel Designing
    IOT
    Robotics
    Raspberry Pi
    Embedded Systems

    Web Development

    Digital Marketing
    Trending
    CSS – Bootstrap Training
    HTML Training
    SEO Training
    Trending
    SMO Training
    Python Full Stack
    Java Full Stack
    PHP Full Stack
  • Workshop
  • Tutorial
    • Trending Courses
      • Cyber Security & Ethical Hacking Training
      • Digital Marketing Training
      • Sales Force Training
    • Data Science & Analytics
      • Data Science with Python
      • Python Machine Learning Training
      • Deep Learning Training
      • Python Certification
      • Python Django Training
      • R Language
      • Hadoop Training
      • Big Data Training
      • IOT Training
    • Java Technologies
      • Core JAVA Training
      • Advance Java Training
      • Java Spring Framework
      • Java Struts Framework
      • Java Hibernate Framework
      • Angular js
      • Node js
      • Java Script Training
    • Python Programming
      • Python Certification
      • Python Django Training
      • Data Science with Python
      • Python Machine Learning Training
      • Deep Learning Training
    • Automation (Electrical & Electronics)
      • PLC Training
      • SCADA Training
      • HMI Training
      • AC Drive Training
      • Solar Installation Training
      • AutoCADD Electrical
      • Panel Designing with ElectricalCADD
      • Arduino Training
      • Raspberry pi
      • Robotics Training
      • IOT Training
    • CAD / CAM / CAE
      • Civil
        • AutoCADD – Civil Training
        • Stadd Pro Training
        • 3Ds Max Training
        • Revit Training
      • Mechanical
        • AutoCADD – Mechanical Training
        • Catia Training
        • Creo Training
        • Ansys Training
      • Electrical
        • AutoCADD Electrical
    • Programming Language
      • C Programming Training
      • C++ Programming
      • Data Structures
      • SQL Certification Course
      • Java Technologies
      • Python Programming
    • Web Designing & Development
      • Website Designing Training
        • HTML Training
        • CSS – Bootstrap Training
        • My SQL Training
        • Java Script Training
        • Ajax Training
        • PHP Training
      • WordPress Training
      • Node js
      • Python Django Training
    • Microsoft Courses
      • MS Excel Beginner Training
      • Advance Excel Training
      • Excel VBA Macro Training
      • MS PowerPoint & Presentation Skills
      • MS Access Training
      • MS Project
    Data Science – Artificial Intelligence with Python

    Data Science – Artificial Intelligence with Python

    ₹18,000.00 ₹15,000.00
    Read More
  • Pay Online
  • About
    • Contact
    • FAQs
    • Gallery
    • Become a Teacher
    Have any question?
    +919413240301
    +919413240301
    [email protected]
    Pay Online
    Login
    Seldom India
    • Training

      Other

      Cyber Security
      Trending
      Ethical Hacking
      Vedic maths
      New
      Advance Excel
      Trending
      C Language
      C++ Language
      Data Structure
      AutoCAD
      Trending
      VBA Macro
      Trending

      Python

      Python
      Data Science
      Trending
      Machine Learning
      NEW
      Deep Learning
      Artificial Intelligence
      Trending
      Python Django
      R Language

      Java

      Core JAVA Training
      Advance Java Training
      Angular js
      NEW
      Node js

      Automation

      PLC
      Trending
      Solar Installation
      NEW
      SCADA
      Panel Designing
      AC Drive
      HMI
      Electrical CADD
      Trending
      Panel Designing
      IOT
      Robotics
      Raspberry Pi
      Embedded Systems

      Web Development

      Digital Marketing
      Trending
      CSS – Bootstrap Training
      HTML Training
      SEO Training
      Trending
      SMO Training
      Python Full Stack
      Java Full Stack
      PHP Full Stack
    • Workshop
    • Tutorial
      • Trending Courses
        • Cyber Security & Ethical Hacking Training
        • Digital Marketing Training
        • Sales Force Training
      • Data Science & Analytics
        • Data Science with Python
        • Python Machine Learning Training
        • Deep Learning Training
        • Python Certification
        • Python Django Training
        • R Language
        • Hadoop Training
        • Big Data Training
        • IOT Training
      • Java Technologies
        • Core JAVA Training
        • Advance Java Training
        • Java Spring Framework
        • Java Struts Framework
        • Java Hibernate Framework
        • Angular js
        • Node js
        • Java Script Training
      • Python Programming
        • Python Certification
        • Python Django Training
        • Data Science with Python
        • Python Machine Learning Training
        • Deep Learning Training
      • Automation (Electrical & Electronics)
        • PLC Training
        • SCADA Training
        • HMI Training
        • AC Drive Training
        • Solar Installation Training
        • AutoCADD Electrical
        • Panel Designing with ElectricalCADD
        • Arduino Training
        • Raspberry pi
        • Robotics Training
        • IOT Training
      • CAD / CAM / CAE
        • Civil
          • AutoCADD – Civil Training
          • Stadd Pro Training
          • 3Ds Max Training
          • Revit Training
        • Mechanical
          • AutoCADD – Mechanical Training
          • Catia Training
          • Creo Training
          • Ansys Training
        • Electrical
          • AutoCADD Electrical
      • Programming Language
        • C Programming Training
        • C++ Programming
        • Data Structures
        • SQL Certification Course
        • Java Technologies
        • Python Programming
      • Web Designing & Development
        • Website Designing Training
          • HTML Training
          • CSS – Bootstrap Training
          • My SQL Training
          • Java Script Training
          • Ajax Training
          • PHP Training
        • WordPress Training
        • Node js
        • Python Django Training
      • Microsoft Courses
        • MS Excel Beginner Training
        • Advance Excel Training
        • Excel VBA Macro Training
        • MS PowerPoint & Presentation Skills
        • MS Access Training
        • MS Project
      Data Science – Artificial Intelligence with Python

      Data Science – Artificial Intelligence with Python

      ₹18,000.00 ₹15,000.00
      Read More
    • Pay Online
    • About
      • Contact
      • FAQs
      • Gallery
      • Become a Teacher

      Microsoft Courses

      Home » Courses » Advance Excel » Advance Excel Training

      Advance Excel Training

      User Avatar
      Seldom India
      Microsoft Courses
      ₹6,000.00 ₹4,500.00
      Advance Excel Training
      • Overview
      • Curriculum
      • Instructor

      About Advance Excel Training

      Microsoft Excel is one of the greatest, most powerful, most important software applications of all time. Learning about the tips n tricks will be the main focus of Advance Excel Training Program. It provides enormous capacity to do quantitative analysis, letting you do anything from statistical analysis of databases with hundreds of thousands of records to complex estimation tools with user-friendly front ends.

      Forwards in Advanced MS Excel

      Excel is everywhere you look in the business world especially in areas where people are adding up numbers a lot, like marketing, business development, sales, and, of course finance. Weather it is about extracting data from back-end systems and shoving it around in Excel spreadsheets, r compiling data from the field, it is there everywhere.

      Ask any working professionals, person unaware of excel is just treated as Second Grade Citizen. In-spite of having all the experience you have gathered in the decades, or the degrees you have earned over the years or of the matter of the fact all the awards lying in your showcase, all are worth less. if you do not know speedy work on your workstation.

      Reporting is the new dragon of the corporate world, no matter in which position you work, you have to report, may be to your boss, or to your stake holders, or to your clients, but have to report. No one allows you to sleep without reporting. this is part of the MS Excel Course Trilogy which includes MS Excel Beginner,  Advance Excel & Excel VB Macros.

      Learning Outcomes from Advance Excel Training:

      • Speedy data analysis
      • Better Understanding of MIS Reporting
      • Time Saving in Office Work
      • Reaching deep into data and seeing the unseen truth of your business.
      • Learn to Create Smart Solution for your daily office work

      Live Online Class:

      Batch 1: 09:00 – 12:00 AM (24 – 29 March)
      Batch 2: 04:00 – 07:00 PM (26 – 31 Mrach)

      Course Features

      • Lectures 41
      • Quizzes 0
      • Duration 20 Hours
      • Skill level All levels
      • Language English
      • Students 0
      • Assessments Yes
      CoursesMicrosoft CoursesAdvance Excel Training
      • MS Excel Training Course - Lesson 1: Excel Basics
        3
        • Lecture1.1
          Formatting & Managing your Worksheet & workbook
        • Lecture1.2
          Basic Formulas, Number Formats & Working
        • Lecture1.3
          Working with Menus Tabs & Excel Advance Options
      • MS Excel Training Course - Lesson 2: Formats, Conditional Formatting & Sorting
        5
        • Lecture2.1
          Cell Formatting
        • Lecture2.2
          Conditional Formatting Data Bars, Colour Scales & Icon Sets,
        • Lecture2.3
          Conditional formatting with formulas,
        • Lecture2.4
          Sorting basic & advance
        • Lecture2.5
          Filters Basic & Advance
      • MS Excel Training Course - Lesson 3: Data Management
        2
        • Lecture3.1
          Data from other Sources
        • Lecture3.2
          Data Validation and dealing with Invalid Data
      • MS Excel Training Course - Lesson 4: Formulas & Functions
        6
        • Lecture4.1
          Text Formulas : Exact, Find, Upper, Proper, Left, Right, Mid & many more
        • Lecture4.2
          Lookup Formulas : Vlookup, Hlookup, Lookup, Match etc..
        • Lecture4.3
          Logical Formulas: If, AND, OR, NOR etc…
        • Lecture4.4
          Date & Time Formulas : Today, Now, Years, etc..
        • Lecture4.5
          Financial, Math ,Trig , Index, Formulas etc..
        • Lecture4.6
          How & when to apply Nested Functions
      • MS Excel Training Course - Lesson 5 Chart & Graphs
        5
        • Lecture5.1
          Chart Basics: What, When & How
        • Lecture5.2
          Why to use Line Chart
        • Lecture5.3
          Most Commonly used: Column Chart
        • Lecture5.4
          Typical Spark lines
        • Lecture5.5
          Special Charts : Progress Chart, Gantt Chart, Pareto Chart
      • MS Excel Training Course - Lesson 6 Data Analysis
        9
        • Lecture6.1
          Creating a PivotTable,
        • Lecture6.2
          Specifying the Data a PivotTable Analyzes
        • Lecture6.3
          Changing a PivotTable’s Calculation
        • Lecture6.4
          Selecting What Appears in a PivotTable
        • Lecture6.5
          Grouping Dates in a PivotTable,
        • Lecture6.6
          Updating a PivotTable
        • Lecture6.7
          Formatting and Charting a PivotTable
        • Lecture6.8
          Scenario Modelling
        • Lecture6.9
          Goal Seek
      • MS Excel Training Course - Lesson 7: Automating your Work
        11
        • Lecture7.1
          Introduction to Form Controls,
        • Lecture7.2
          Macros: Introduction to Form Controls,
        • Lecture7.3
          Macros, Create and Edit a Macro.
        • Lecture7.4
          Automating Tasks with Macros
        • Lecture7.5
          Recording a Macro
        • Lecture7.6
          Playing a Macro and Assigning a Macro a Shortcut Key
        • Lecture7.7
          Adding a Macro to a Toolbar
        • Lecture7.8
          Working with Other Programs
        • Lecture7.9
          Inserting an Excel Worksheet into a Word Document
        • Lecture7.10
          Modifying an Inserted Excel Worksheet
        • Lecture7.11
          Inserting a Linked Excel Chart in a Word Document
      author avatar
      Seldom India
      • Overview
      • Curriculum
      • Instructor
      ₹6,000.00 ₹4,500.00
      • Share:

      Leave A Reply Cancel reply

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

      This site uses Akismet to reduce spam. Learn how your comment data is processed.

      All Courses

      • Automation
      • CAD / CAM / CAE
      • Data Science & Analytics
      • Java Technologies
      • Microsoft Courses
      • Python Programming
      • Trending Courses
      • Web Designing & Development

      Latest Courses

      Data Science – Artificial Intelligence with Python

      Data Science – Artificial Intelligence with Python

      ₹18,000.00 ₹15,000.00

      Live QA Session

      ₹2,500.00 ₹1,500.00
      PLC Training

      PLC Training

      ₹7,000.00 ₹5,500.00

      Contact US

      Whatsapp +919413240301

      Call: +91 9413240301

      Email: [email protected]

      Address: 27 Kailash Puri,
      Near Khandaka Hospital Tonk Road
      Jaipur, Rajasthan 302018

      Company

      • About Us
      • Blog
      • Contact
      • Become a Teacher

      Links

      • Courses
      • Events
      • Gallery
      • FAQs

      Support

      • Privacy
      • Terms
      • Sitemap
      • Purchase

      Recommend

      • Summer Training in Jaipur
      • Winter Internship Training
      • Corporate Training
      • Campus In-house Training

      Powered by Seldom India.

      Connect with:

      Login with Facebook

      logo

      Login with your site account

      Connect with:

      Login with Facebook

      logo


      Lost your password?

      Call Now
      Map
      Whatsapp Chat
      Modal title

      Message modal