Microsoft Excel Beginner to Advanced - A Master Pro Course
Master Excel with this A-Z MS Excel course. Hands-on Microsoft Excel 2010, 2013, and 2019 training
Lectures -80
Resources -38
Duration -8 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Microsoft Excel Beginners to Advanced Training is one of the best Excel courses available at Tutorialspoint, 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.
Microsoft Excel - Beginner To Advanced Course Overview
Below are the reasons to learn 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?
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
The training is appropriate for those who have never used Excel before. Starting from the very beginning, we will progressively get to some of the most advanced features, including pivot tables, custom formatting, Excel 2016 charts, lookup functions, functions with conditions, goal seek, and other tools that are frequently used for financial modeling.
The course also offers real-world case studies to help you apply what you've learned. Building a complete profit and loss statement from the beginning is one of the exercises we'll do in the course.
For university students and newly hired professionals in finance, business, and marketing who want to advance more quickly than their contemporaries, this course is ideal.
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 topics for MIS Reports (Kindly Check Curriculum)
Who is this course for?
- 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
Goals
What will you learn in this course:
- Microsoft Excel - Beginner To Advanced - A Master Pro Course
- 100+ Lectures
- Certificate of Completion
- Downloadable Material
- Downloadable Practice Templates
Prerequisites
What are the prerequisites for this course?
- A desire to learn valuable skills
Curriculum
Check out the detailed breakdown of what’s inside the course
Microsoft Excel - Launch - Basics
10 Lectures
- An Introduction to Microsoft Excel 02:39 02:39
- Open-Create-Save-Close of Microsoft Excel 01:28 01:28
- How to Open MS Excel, What is Menus, Tools, Sheets, Columns, Rows & Ce 06:26 06:26
- MS Excel - Copy Cells, Move Cells 01:19 01:19
- Learn How to Create Tabs, Groups and add Toll to it in MS Excel 05:16 05:16
- MS Excel - Home Tab - Group Clipboard Features Functions Explained 09:33 09:33
- MS Excel - Home Tab - Font Group Explained - Font Size, Font Face Style, Bold 08:46 08:46
- Home Tab - Alignment Group Explained - Merge, Wrap Text, Alignments & more 05:34 05:34
- MS Excel - Characteristics of Cell 01:11 01:11
- Speak Cells - on Enter, by Rows, By Columns, Stop Speaking Cells I Microsoft 03:41 03:41
MS Excel - Fill Series & Advanced Filling
3 Lectures
MS Excel Editing Data
3 Lectures
MS Excel - Working with Sheets
8 Lectures
MS Excel - Protection
2 Lectures
MS Excel - Data Formatting, Page Setup, Printing, Links & more functions
8 Lectures
MS Excel - Data Validation & DropDown Lists
5 Lectures
MS Excel - Bar Code Creation
1 Lectures
MS Excel - Importing Data & Objects
3 Lectures
MS Excel - Charts
2 Lectures
MS Excel Formulars - Logical Formulas
6 Lectures
MS Excel - Commonly used formulas
9 Lectures
MS Excel - Lookups - V Lookup, H Lookup & X Lookup
6 Lectures
Pivot Tables
4 Lectures
MS Excel Bonus Topics & Newly Updated Formulas, Features & Requested Topics
9 Lectures
Instructor Details
Urs Ravi & Vedanta Educational Academy
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now