• 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 If with AND, OR and Nested IFS
    Next Project: Finding NSE Working Days

    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