Microsoft Excel - Beginner to Advanced - A Master Pro Course
Created by Urs Ravi & Vedanta Educational Academy, Last Updated 08-Sep-2020, Language:English
Microsoft Excel - Beginner to Advanced - A Master Pro Course
Learn by doing in small, easy to understand I Excel with this A-Z MS Excel Course. Microsoft Excel 2010, 2013, 2019
Created by Urs Ravi & Vedanta Educational Academy, Last Updated 08-Sep-2020, Language:English
What Will I Get ?
- Microsoft Excel - Beginner To Advanced - A Master Pro Course
- 100+ Lectures
- Certificate of Completion
- Downloadable Material
- Downloadable Practice Templates
Requirements
- A Desire to learn a Valuable Skills
Description
Do you want to learn how to work with Excel ?
Even if you don’t have any prior experience?
If so, then this is the right course for you!
A Certificate of Completion is presented to all students who complete this course.
Microsoft Excel 2019 is here, and it promises to be one of the greatest versions that we’ve seen so far.
However, it’s essential that you learn how to work with it effectively.
If you want to become any of the following…
Executive Assistant
Office Clerk
Auditor
Accountant
Business Analyst
Financial Analyst
Credit Counselor
Sales Representative
Sales Manager
Financial Manager
Investment Banker
Real Estate Agent
Market Research Analyst
Financial Advisor
Business Operations Manager
Entrepreneur
Someone who is involved with a business and would like to be successful
Then you simply have to learn Microsoft Excel . There is no way around it.
But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle?
Microsoft Excel 2019 Beginners & Intermediate Excel Training is here for you. One of the best Excel courses available on Udemy, it includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will serve you well throughout your career.
What makes this course different from the rest of the Excel courses out there?
High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!)
Knowledgeable instructor (experience in Big 4 Accounting + Commercial Finance)
Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.)
Extensive Case Studies that will help you reinforce everything that you’ve learned
Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 24 hours
Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course
How come Microsoft Excel is so important?
Every large company uses it, right? So if you want to learn a new skill that is highly valued by all employers, you should start here.
Here are 5 more reasons why you should take this course and learn Excel:
Jobs. A solid understanding of Excel opens the door for a number of career paths
Promotions. Top Excel users are promoted very easily inside large corporations
Bill Gates knows how to work with Excel
Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment
Girls dig guys who are proficient in Excel! Guys who can use VLOOKUP are proven to be the most popular with women - Kacward
This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling.
Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch.
This course is perfect for University students, Entry-level Finance, Business and Marketing professionals who would like to grow faster than their peers.
What you'll learn
Microsoft Excel Basics, Advanced & Pro
An Introduction to Microsoft Excel
How to Open MS Excel, What is Menus, Tools, Sheets, Columns, Rows & Cells
MS Excel - Copy Cells, Move Cells
Learn How to Create Tabs, Groups and add Toll to it in MS Excel
MS Excel - Home Tab - Group Clipboard Features Functions Explained
MS Excel - Home Tab - Font Group Explained - Font Size, Font Face Style, Bold
Home Tab - Alignment Group Explained - Merge, Wrap Text, Alignments & more
MS Excel - Characteristics of Cell
Speak Cells - on Enter, by Rows, By Columns, Stop Speaking Cells I Microsoft
MS Excel - Fill Series - with formatting, without formatting & more
Fill Series - Advance Fill - Numbers, Months, Days, Custom List Edit & Add
Fill Series - Flash Fill
Excel - Editing Data I over writing I Go to I find & replace I undo & redo
MS Excel - Text to Columns
MS Excel - Comments - add, edit, delete & Show all
MS Excel - How to Hide and Unhide Rows, Columns, Sheets
Freeze Panes - Top Row, Columns & Multiple Rows & Columns
MS Excel - Filters - Learn How to Use Filter to analyse Big Data
MS Excel - Split Sheet Window
MS Excel - How to Insert & Delete Cells, Rows, Columns
MS Excel - Working with Sheets
MS Excel - Format Multiple Sheets at a time I Sheet Formatting
MS Excel - View Sheets Side by Side from One Excel File
MS Excel - Workbook Protection - Learn how to setup a Password to open Excel
MS Excel - Sheet & Cells Protection
MS Excel - Conditional Formatting - Highlight Cells Via Number, Text & more
Concatenate - Join Multiple Text Strings into ONE
MS Excel - Trim Functions - Remove unnecessary Elements from strings
MS Excel - Print Formulas Left, Right, Middle
MS Excel - Date Related Formulas
MS Excel - Hyper Links - Cell to Sheet, Website, Existing File, Create New
MS Excel - Page Header & Footer I Add Page Numbers, Logo, Report Name, Date
MS Excel - Print, Page Setup, Margins, Size, Excel to PDF
MS Excel - Create & Remove Drop Down List
Introduction to Data Validation - Time limitation
Data Validation - Restrict Cells, Input & Error Message, Drop Down List...
Data Validation - Part-2 - Circle Invalid data, Error, Stop, Warning, Inform-
Data Validation - Dependent - Multiple Drop Down Lists
MS Excel - Bar Code I Install Bar code font I Generate Bar Codes
MS Excel - Import Data from Websites - Live Data
MS Excel - Import Data from Text Document - with Auto Refresh
MS Excel - Import - Text, Word, PPT, JPEG, Video, PDF & More Objects
MS Excel - Charts - Pie Charts - Create & Customize I Chart Elements
MS Excel - Charts - Columnar, Bar, Line Charts
Logical Functions - Logical Test I Boolean Expression I TRUE or FALSE I
Logical Test - IF Function
Logical Functions - Nested IF - Learn How to work with Nested if Formula
Logical Functions - AND function
Logical Function - Not & IF ERROR
MS - Excel Commonly Used Formulas I Sum I Subtraction I Avg I Percentage I Mu
Statistical Formulas - Sum, Sumif, Sumifs, Count, Countif, Countifs, Avg, Av
MS Excel - 3D Sum I Calculate Multiple Sheet Data at a time
MS Excel - Consolidate ( 3d Sum extension)
Show Formula, Trace Dependents, Trace Precedents, Evaluate Formula, Formula
Formulas - sumproduct, mround, floor, ceiling
Index Formula - Find a Position of the Value, and Call cells references
Match Formula - Find Position of the Value
MS Excel - Age Calculator in Multiple Ways - Exclusive formula
Student Mark Sheet Calculation - Sum, Average, Rank, Grade, Pass-Fail, Status
V Lookup - Introduction
V Lookup - Formula, Functionality, Rules, Approximate & Exact Match & more
H Lookup - Formula, Functionality, Rules, Approximate & Exact Match & more
X Lookup - Introduction
Download, Add & use X Lookup New Formula in MS Excel
X Lookup New Formula in MS Excel
Pivot Table Introduction & Basics of Pivot Table
Create a Pivot Chart from Table & Pivot Table
Pivot Table - Use slicers to filter data
Pivot Table, Charts, Progress Dashboard
MS Excel Calculate EMI I Prepare Loan Statement I Principal I Interest
Working with Tables
Create & Maintain Registers - Using GroupSheets, Drop Down Lists, Date Valid
Share a workbook with Co Authors, Employees or with Anyone
Commission Calculation in MS Excel
Attendance Sheet Preparation in MS Excel
Salary Calculation with CA, DA, Commission, Advance, PF, ESI & more
Excel to SMS
Macros & more topcis for MIS Reports (Kindly Check Curriculum)
Enroll today and let's start this journey together!
Course Content
-
Microsoft Excel - Launch - Basics
10 Lectures 00:45:53-
An Introduction to Microsoft Excel
Preview00:02:39 -
Open-Create-Save-Close of Microsoft Excel
Preview00:01:28 -
How to Open MS Excel, What is Menus, Tools, Sheets, Columns, Rows & Ce
Preview00:06:26 -
MS Excel - Copy Cells, Move Cells
Preview00:01:19 -
Learn How to Create Tabs, Groups and add Toll to it in MS Excel
00:05:16 -
MS Excel - Home Tab - Group Clipboard Features Functions Explained
00:09:33 -
MS Excel - Home Tab - Font Group Explained - Font Size, Font Face Style, Bold
00:08:46 -
Home Tab - Alignment Group Explained - Merge, Wrap Text, Alignments & more
00:05:34 -
MS Excel - Characteristics of Cell
00:01:11 -
Speak Cells - on Enter, by Rows, By Columns, Stop Speaking Cells I Microsoft
00:03:41
-
-
MS Excel - Fill Series & Advanced Filling
3 Lectures 00:13:45-
MS Excel - Fill Series - with formatting, without formatting & more
Preview00:02:46 -
Fill Series - Advance Fill - Numbers, Months, Days, Custom List Edit & Add,
00:07:11 -
Fill Series - Flash Fill
00:03:48
-
-
MS Excel Editing Data
3 Lectures 00:14:39-
Excel - Editing Data I over writing I Go to I find & replace I undo & redo
00:05:45 -
MS Excel - Text to Columns
00:05:34 -
MS Excel - Comments - add, edit, delete & Show all
00:03:20
-
-
MS Excel - Working with Sheets
8 Lectures 00:47:36-
MS Excel - How to Hide and Unhide Rows, Columns, Sheets
00:06:06 -
Freeze Panes - Top Row, Columns & Multiple Rows & Columns
00:07:00 -
MS Excel - Filters - Learn How to Use Filter to analyse Big Data
00:07:54 -
MS Excel - Split Sheet Window
00:03:12 -
MS Excel - How to Insert & Delete Cells, Rows, Columns
00:07:27 -
MS Excel - Working with Sheets
00:06:50 -
MS Excel - Format Multiple Sheets at a time I Sheet Formatting
00:04:52 -
MS Excel - View Sheets Side by Side from One Excel File
00:04:15
-
-
MS Excel - Protection
2 Lectures 00:08:47-
MS Excel - Workbook Protection - Learn how to setup a Password to open Excel
00:03:35 -
MS Excel - Sheet & Cells Protection
00:05:12
-
-
MS Excel - Data Formatting, Page Setup, Printing, Links & more functions
8 Lectures 00:39:41-
MS Excel - Conditional Formatting - Highlight Cells Via Number, Text & more
00:05:16 -
Concatenate - Join Multiple Text Strings into ONE
00:01:15 -
MS Excel - Trim Functions - Remove unnecessary Elements from strings
00:01:33 -
MS Excel - Print Formulas Left, Right, Middle
00:03:26 -
MS Excel - Date Related Formulas
00:03:07 -
MS Excel - Hyper Links - Cell to Sheet, Website, Existing File, Create New
00:09:54 -
MS Excel - Page Header & Footer I Add Page Numbers, Logo, Report Name, Date
00:06:28 -
MS Excel - Print, Page Setup, Margins, Size, Excel to PDF
00:08:42
-
-
MS Excel - Data Validation & DropDown Lists
5 Lectures 00:35:36-
MS Excel - Create & Remove Drop Down List
Preview00:08:42 -
Introduction to Data Validation - Time limitation
00:01:16 -
Data Validation - Restrict Cells, Input & Error Message, Drop Down List...
00:13:22 -
Data Validation - Part2 - Circle Invalid data, Error, Stop, Warning, Inform-
00:06:06 -
Data Validation - Dependent - Multiple Drop Down Lists
00:06:10
-
-
MS Excel - Bar Code Creation
1 Lectures 00:05:33-
MS Excel - Bar Code I Install Bar code font I Generate Bar Codes
Preview00:05:33
-
-
MS Excel - Importing Data & Objects
3 Lectures 00:17:56-
MS Excel - Import Data from Websites - Live Data
00:05:24 -
MS Excel - Import Data from Text Document - with Auto Refresh
00:03:14 -
MS Excel - Import - Text, Word, PPT, JPEG, Video, PDF & More Objects
00:09:18
-
-
MS Excel - Charts
2 Lectures 00:17:26-
MS Excel - Charts - Pie Charts - Create & Customize I Chart Elements
00:08:24 -
MS Excel - Charts - Columnar, Bar, Line Charts
00:09:02
-
-
MS Excel Formulars - Logical Formulas
6 Lectures 00:31:17-
Logical Functions - Logical Test I Boolean Expression I TRUE or FALSE I
Preview00:03:41 -
Logical Test - IF Function
Preview00:10:12 -
Logical Functions - Nested IF - Learn How to work with Nested if Formula
00:05:10 -
Logical Functions - AND function
00:04:57 -
Logical Function - Not & IFERROR
00:02:13 -
MS Excel - Age Calculator in Multiple Ways - Exclusive formula
Preview00:05:04
-
-
MS Excel - Commonly used formulas
9 Lectures 01:13:54-
MS - Excel Commonly Used Formulas I Sum I Subtraction I Avg I Percentage I Multiplication
00:10:50 -
Statistical Formulas - Sum, Sumif, Sumifs, Count, Countif, Countifs, Avg, Avgifs
Preview00:15:53 -
MS Excel - 3D Sum I Calculate Multiple Sheet Data at a time
00:03:56 -
MS Excel - Consolidate ( 3d Sum extension)
00:04:08 -
Show Formula, Trace Dependents, Trace Precedents, Evaluate Formula, Formula
00:09:16 -
Formulas - sumproduct, mround, floor, ceiling
00:08:48 -
Index Formula - Find a Position of the Value, and Call cells references
00:08:36 -
Match Formula - Find Position of the Value
00:01:37 -
StudentMark Sheet Calculation - Sum, Average, Rank, Grade, Pass-Fail, Status
00:10:50
-
-
MS Excel - Lookups - V Lookup, H Lookup & X Lookup
6 Lectures 00:19:26-
V Lookup - Introduction
Preview00:01:09 -
V Lookup - Formula, Functionality, Rules, Approximate & Exact Match & more
00:03:36 -
H Lookup - Formula, Functionality, Rules, Approximate & Exact Match & more
00:03:36 -
X Lookup - Introduction
Preview00:01:06 -
Download, Add & use X Lookup New Formula in MS Excel
00:03:44 -
X Lookup New Formula in MS Excel
00:06:15
-
-
Pivot Tables
4 Lectures 00:30:25-
Pivot Table Introduction & Basics of Pivot Table
00:02:12 -
Create a Pivot Chart from Table & Pivot Table
00:01:01 -
Pivot Table - Use slicers to filter data
00:01:07 -
Pivot Table, Charts, Progress Dashboard
00:26:05
-
-
MS Excel Bonus Topics & Newly Updated Formulas, Features & Requested Topics
9 Lectures 01:33:21-
MS Excel Calculate EMI I Prepare Loan Statement I Principal I Interest
Preview00:18:49 -
Working with Tables
00:05:48 -
Create & Maintain Registers - Using GroupSheets, Drop Down Lists, Date Valid
00:26:58 -
Share a workbook with Co Authors, Employees or with Anyone
00:00:51 -
Commission Calculation in MS Excel
Preview00:06:39 -
Attendance Sheet Preparation in MS Excel
00:09:59 -
Salary Calculation with CA, DA, Commission, Advance, PF, ESI
00:06:21 -
Creating Professional Invoice in Excel
00:13:21 -
Excel to SMS
00:04:35
-

Urs Ravi & Vedanta Educational Academy
Tally & GST Guru I Microsoft Office Expert
UrsRaviTelugu Chief Faculty at Tally Institute of Learning
Ravi Telugu is a Corporate Trainer with 6 Years of Training Experience on various technologies. He specializes in MS Office Tools, Tally, Focus, Wings, SAP, GST, Income Tax, TDS.
Ravi Telugu, Cheif Executive officer at @ Vedanta Educational Academy.
Authorized partner @ Tally Solutions and also Tally Education
Instructor at Tally Institute of Learning for last 3yrs.
Signed up Top 11 Colleges for Tally & GST(more than 10,000 students)
Speaker at OU Tally & GST awareness program.
Having 4yrs experience in Tally Training center/worked as faculty in Top Institutes.
Working as accounts admin for Valam Foods Pvt LTD. Sri Varun Scales, Digitam Intellect Pvt LTD etc.