MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Excel for All: Beginner to Experts

Course Summary

All round use of Excel Explained with examples

  • +

    Course Syllabus

    • Intro
      • Intro Lecture
    • MS Excel: Offload your Work
      • What you will learn
      • Get to know Excel in 20 minutes
    • Data Cleaning
      • How you can clean Data
      • Customize a list
      • Format numbers
      • Coloring cells the smarter way
      • Going beyond a simple Paste
      • Going beyond a smple Find
      • Using Shortcuts
    • Organizing Data in Excel
      • How to organize data in Excel
      • Is your data readable?
      • Deciding what others enter
      • Creating Totals per segment
      • Consolidating Tables
    • Writing Smart Functions in Excel
      • How Functions can help you
      • Learn tricks to self explore Excel Functions
      • What a function needs, to deliver the required output
      • Difference b/w a Summary and a self learning Template
      • Convert a count summary to a Template
      • How to choose what to Count
      • Using Text Functions for Data Cleaning'
    • Segmenting Data in Excel
      • How to segment your Data
      • Dividing Data into meaningful segments
      • Dividing data using multiple conditions
    • Why create Reports the tedious way
      • How Pivot make data meaningul
      • Introduction to Pivots
      • Generating reports without getting into the technicalities
      • Slicing reports with Pivots
      • Working with dates in Pivots
    • Showcasing your data with Excel
      • Using Dashboards to make Data look good
      • How to Create a Dashboard
      • Different ways to present Data
      • Creating a Dashboard Template
      • Making Templates smarter
      • Converting templates to a Dashboard
      • Making Dashboard user friendly
    • Test Case Study
      • Revenue Report
    • Visual Basic For Applications: Automating your Work
      • Vocabulary
        • Introduction to VBA Programming
        • OOPS
        • Hierarchy as a vocabulary of the language
        • Communication among objects
        • Examples to justify the communication techniques
        • Introducing: Intangible Hierarchy
      • Grammar
        • Sentence Creation: Connections in Excel
        • Rules of Writing the sentenses in VBA
      • Learn More With Hands On
        • Introducing the Platform to write and Automate
          • Introducing the Platform: VBA Window
        • Small Exercises to connect our learning so far
          • Applying Functions in VBA
          • Basic Error Debugging & Recording
          • Applying Methods in VBA
          • Various ways of executing a macro
        • Case Study: Real Implementation
          • Explaining the case study for hands on learning
          • Understanding the IF Statements
          • Converting Constants to variables
          • Understanding Loops: FOR-NEXT
          • Understanding Loops: DO-LOOP
          • Recording a Macro: Handholding / On job training to macros
          • Trailing multiple macros one after another
        • Functions and Events Can also be customized
          • Events to self execute the Macros
          • Creating your own functions in Excel
        • Data Visualization
          • Why Data Visualization
            • Snapshot of the Course
            • Dynamic Charts through checkboxes
            • Creating Dynamic Charts
          • Data Visualization using CheckBoxes
            • Trailer: Battery Charts
            • Creating: Battery Charts
            • Creating: Applying motion to the battery Charts
          • Speedometer charts
            • Trailer: Speedometer Charts
            • Creating: Speedometer Charts
            • Creating: Moving Speedometer Charts
          • Introduction to Excel Apps using Userforms
            • Why Userforms
            • Snapshot of the Courses
          • Step By Step Approach to creating an App in Excel
            • Creating an Empty userform in Excel
            • Creating Controls in the userforms
            • Connecting Text Box and ComboBox to Execute the Submission at relevant Events
            • Adding Values in the Combobox
            • Connecting Radio Buttons to Excel data
            • Connecting CheckBoxes to Excel data
            • Making the Excel Connection Inteligent & Dynamic
            • Testing the form
          • Getting your App to interact with the user
            • Why should an app Interact with the user
            • Understanding the Property Window & Events
            • Creating validations
            • Creating conditional labesl on While Writing Event
          • Create your own app
            • Project - Create your own App

        Course Fee:
        USD 149

        Course Type:


        Course Status:



        1 - 4 hours / week

        This course is listed under Development & Implementations and Data & Information Management Community

        Related Posts:

        Attended this course?

        Back to Top

        Awards & Accolades for MyTechLogy
        Winner of
        Top 100 Asia
        Finalist at SiTF Awards 2014 under the category Best Social & Community Product
        Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
        Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
        Hidden Image Url

        Back to Top