• Home
  • About Us
  • Courses
    • Excel Learning
    • PowerPoint Learning
    • Power Tool Powerpoint
    • MS Excel: Beginners to Pro
    • Email Writing: Nuts & Bolts of Professional Email
  • Blog
  • Free Resources
  • Contact
    • RegisterLogin
RVM Learning
  • Home
  • About Us
  • Courses
    • Excel Learning
    • PowerPoint Learning
    • Power Tool Powerpoint
    • MS Excel: Beginners to Pro
    • Email Writing: Nuts & Bolts of Professional Email
  • Blog
  • Free Resources
  • Contact
    • RegisterLogin

Course

  • Home
  • All courses
  • MS Excel: Beginners to Pro
CoursesMS Excel: Beginners to Pro
  • Section 1:Introduction
    15
    • Lecture1.1
      Excel Intro & Resource Use
    • Lecture1.2
      Excel _ Structure
    • Lecture1.3
      Shortcuts & Ribbon Tab
    • Lecture1.4
      Working with Excel _ Structure
    • Lecture1.5
      Removing Formats from Online Data
    • Lecture1.6
      Formatting – Putting Years in Formula
    • Lecture1.7
      Filling Data & Auto Fill
    • Lecture1.8
      Auto-Fill Alphanumerical in Excel
    • Lecture1.9
      Formatting – Cleaning All Formats
    • Lecture1.10
      Sorting & Filtering in Excel
    • Lecture1.11
      Data Navigation & Selection
    • Lecture1.12
      Goto Dialogue Box
    • Lecture1.13
      Conditional Data Formatting with Filter
    • Lecture1.14
      Paste Special & Usage
    • Quiz1.1
      Test Your Knowledge 0 question
  • Section 2:Formulas and Functions
    21
    • Lecture2.1
      Introduction to Formula & Functions
    • Lecture2.2
      Arithmetic Functions
    • Lecture2.3
      Arithmetic Continued
    • Lecture2.4
      Error Handling in Excel
    • Lecture2.5
      Error Handling – Data Validation
    • Lecture2.6
      Handling Single Condition in Excel
    • Lecture2.7
      Multiple Criteria
    • Lecture2.8
      Text Functions and Real time Application
    • Lecture2.9
      Handling Logics in Excel
    • Lecture2.10
      If with AND, OR and Nested IFS
    • Lecture2.11
      Date Function in Excel
    • Lecture2.12
      Project: Finding NSE Working Days
    • Lecture2.13
      Look Up Functions – Vlookup
    • Lecture2.14
      Vlookup on Multiple Conditions
    • Lecture2.15
      Index Match
    • Lecture2.16
      Multidimensional Lookup Using Index Match
    • Lecture2.17
      Vlookup and Choose
    • Lecture2.18
      Tables in Excel
    • Lecture2.19
      Pivot Tables
    • Lecture2.20
      Data Handling with Slicers
    • Lecture2.21
      Project: NSE 100 Stocks Industry Bifurcation
  • Section 3:Charts
    9
    • Lecture3.1
      Plotting Basic Chart
    • Lecture3.2
      Adding Elements to Charts
    • Lecture3.3
      2-Axis Charts
    • Lecture3.4
      Pie Chart
    • Lecture3.5
      XY and Scattered Plot with Trendlines
    • Lecture3.6
      Basic Dashboard Chart Using Multi Dimension Lookup
    • Lecture3.7
      Customized Pie in Pie Chart
    • Lecture3.8
      Dashboard Chart using Doughnut Chart
    • Lecture3.9
      Real Time Application of Charts
    This content is protected, please login and enroll course to view this content!
    Prev Customized Pie in Pie Chart
    Next Real Time Application of Charts

    Leave A Reply Cancel reply

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

    Finance courses

    Every course on RVM follow the global standard in online and digital learning. A trusted quality place for e-learning platform. Learn at your ease.

    admin@rvmlearning.com

    • Finance courses

    Quick Links

    • About Us
    • Courses
    • Contact Us
    • Blog
    • Become a Teacher

    Courses

    • MS Excel: Beginners to Pro
    • Email Writing: Nuts & Bolts of Professional Email
    • PowerPoint Learning
    • Excel Test
    • English Test

    Copyright © 2011 - 2021 RVM Finishing School | All Rights Reserved.

    • Privacy
    • Terms

    Become An Instructor?

    Join thousand of instructors and earn money hassle free!

    Start teaching today

    Login with your site account

    Login with your Social ID
    Lost your password?

    Not a member yet? Register now

    Register a new account

    Login with your Social ID

    Are you a member? Login now

    Modal title

    Message modal