Course Includes
- Recorded Lessons: 89
- Recorded Hours: 7
- Duration: 7 days (Avg)
Course Features
- Access on mobile
- TDP Assessment Test
- 3 Jobs Available
Top Skills Covered
Overview
Course Description
Welcome to Microsoft Excel Zero to Hero: The Complete Excel Course, With its latest version, this course teaches every essential concept of an Excel essential formula and regular office functional examples in a single course, allowing you to start your Excel course journey step by step.
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, XLookup, VLookup, HLookup, charts, 3D maps, and a programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office 365 suite of software.
Microsoft Excel is used for:
Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key to unlocking all that potential is the grid of cells. Cells can contain numbers, text, formulas, or sparklines from small charts.
Learn Excel, The first step in learning Excel for success in Excel application development is to ensure that it is simple to learn and comprehend. Our online Microsoft Office 365 Excel Zero to Hero: The Complete Excel Course Training course is designed for you, with all of the advanced topics covered. Mr. Sudha Sekhar will simplify and teach you even complex topics so that even beginners can understand them using real-life examples.
Create a solid foundation in Excel Concepts by utilizing Microsoft Excel or Office 365 software packages.
Once you master Excel's advanced concepts, you'll have lots of options in front of you. If you prefer, you can begin developing more Excel apps or change careers and work as an Excel analytics engineer or an Excel data engineer. As long as you know the basic, and advanced concepts pretty well, switching to different analysis stacks should be very easy for you.
Knowing these advanced techniques in Microsoft Excel will allow you to easily switch over to any other data analytics tool to start learning and implementing the Excel concepts.
Top Reasons for Choosing This Excel Course:
A well-designed curriculum teaches you only the most used functionalities of Microsoft Excel in a business environment.
Concise: You can complete this Microsoft Excel course within one weekend.
Business-related examples, data analysis, and case studies solved using Advanced Excel
You will learn various data analysis techniques using Microsoft Excel.
Data analysis practice exercises in MS Excel are required. more
Downloadable resources comprising important MS Excel techniques and functionalities
How can I learn Microsoft Excel quickly?
1. Start learning the basics of Microsoft Excel. The first two sections of the course cover the basics.
2. Once you've mastered the fundamentals, experiment with MS Excel. The next sections cover advanced Excel topics.
3. Sections will assist you in learning the most recent new Microsoft Excel tricks.
4. Practice your learning on the Excel exercise provided for you.
What is the difference between the basic and advanced levels of Excel?
At the basic level of MS Excel, a learner
Anyone can build Excel formulas using: SUM, IF, AVERAGE, COUNT, and ROUND.
Comfortable writing Excel formulas to manipulate text and dates
Identify the data formats and features of Microsoft Excel.
Easily create basic charts like line charts, bar charts, and pie charts.
At the advanced level of MS Excel, a learner
Data validation and how to clean data: applying duplicate removal
Import data from TXT,.CSV, PDF, websites, and other sources; clean and load the data for analysis.
Easily implement Excel lookup formulas like XLOOKUP, VLOOKUP, HLOOKUP, Index, and Match.
Apply conditional and logical formulas like IF, SUMIF, COUNTIF, OR, AND, etc.
Knows what a Pivot table is and how to build one for data aggregation results.
You can create advanced charts in Microsoft Excel, like a stock, waterfall, or surface chart.
Can create and solve analytics problems using excel solver
Named ranges for drop-down options and an index match
Make an impression. Charts for business analysis, geospatial data, and 3D maps
Start working proficiently on Microsoft Excel and increase your office productivity.
The authors of this Microsoft Excel course have several years of corporate experience and, hence, have curated the course material keeping in mind the requirement for advanced MS Excel in today's corporate world.
Learn from real-world experts.
By learning these Excel skills, you will be eager to learn other analytical skills very quickly, which will lead you to become a successful Excel developer.
If you really want to learn Excel and improve your analytical techniques, this Excel Advanced Course is for you. It will help you develop your skills more than others and become strong in Excel app formulas and chart development.
Check out the free preview videos for more information!
By the end of this course, you will be fluent in Microsoft Excel course and ready to work with any excel application you can dream of.
Sign up today, and look forward to:
HD Video Lectures
Excel Challenges and Exercises
Lovely real-world dynamic examples
About Your Instructor
Sekhar Metla is a software engineer with 20+ years of professional experience. He is the author of several online-selling courses with more than 40,000+ students in many countries. He has a Master of Science in Computer Applications in Software Engineering. His students describe him as passionate, pragmatic, and motivational in his teaching.
Who this course is for:
- Anyone curious to master excel from beginner to Advanced in short span of time
- Anyone interested in learning the Advanced Excel concepts
- Anyone who wants to grasp the concept with real-world examples of Data Analytics
- Anyone who wants to become a proficient Excel charts
What you'll learn
- Learn one of the most powerful Microsoft Excel that exists today
- Learn to apply Excel data formatting for your real-world data
- Create eye catching visual charts using Bar charts, scatter plots, pie etc.
- Estimate project timelines and budget chart preparations
- Learn Trending XLOOKUP and wildcard match formulas to improve results for analytics
- Import data from TXT, .CSV, PFD and from Website to Excel spreadsheet
- Learn to Apply Named ranges and indirect named range functions
- Master on essential Excel formulas for data analysis
- Aggregation results by applying Pivot table creations for analysis
- Develop skills on real-world functionality on Excel formulas on your sheet
- Master Excel's most popular functions such as VLOOKUP, HLOOKUP, index and match
- How to handle #N/A errors to approximate and match case
- Implement Business and Geo-charts for Business needs: stock, radar, surface charts etc..
Requirements
- You will need a PC with any version of Excel installed
- No prior technical experience is required! All you need a computer!
Course Content
80 Lessons | 9 Downloadable material | 7:00 Total hours
Getting Started
-
Introduction
00:03:16 -
Course Curriculum
00:04:20 -
Getting started on Windows, macOS, Android, and IOS
00:01:11 -
How to ask great questions
00:01:31 -
FAQ’s
00:01:21 -
Starting Excel
00:03:41
Excel Basics
-
Introduction
00:01:58 -
Worksheet basics
00:21:51 -
Entering values and formulas
00:12:03 -
Data formats
00:09:39 -
Data handling basics – cut copy and paste
00:06:39 -
Save and print in excel
00:10:15 -
Excel Ranges
00:04:48
Excel essential functions
-
Introduction
00:01:15 -
Basic formula operations
00:06:15 -
Mathematical functions level1
00:19:55 -
Mathematical functions level2
00:12:23 -
Text functions level1
00:09:08 -
Text functions level2
00:12:57 -
Logical functions
00:11:04 -
Date time functions
00:06:21 -
V Lookup formula
00:12:13 -
HLookup formula
00:04:08 -
HLookup + Match formula
00:08:35 -
Match + Index formula
00:05:22
XLookup only for Excel 2021 and Office 365
-
Introduction
00:02:01 -
XLookup
00:07:40 -
Handling #NA and Approximates match in XLookup
00:10:31 -
Wildcard matching in XLookup
00:06:12
Get Data and tools
-
Introduction
00:01:45 -
Split Text into columns
00:07:04 -
Flash Fill
00:07:03 -
Remove Duplicates
00:07:47 -
Data Validation
00:06:34 -
Get- import Data from Text
00:05:39 -
Get - import Data from CSV
00:03:23
Formatting data and tables
-
Introduction
00:01:23 -
Formatting Font
00:04:16 -
Formatting Alignment
00:06:04 -
Formatting Number
00:04:37 -
Formatting Date
00:03:29 -
Formatting tables
00:05:13
Pivot Tables
-
Introduction
00:01:09 -
Creating Pivot Table
00:06:44 -
Value field settings
00:04:06 -
Number format
00:02:28 -
Pivot Table Design
00:03:21 -
Excel Exercise
00:01:30 -
Solution for Excel Exercise
00:01:33
Excel Charts
-
Introduction
00:01:13 -
Excel Charts – Categories
00:02:31 -
Elements of a chart
00:04:12 -
Easy way to create charts
00:01:56 -
Column or Bar charts
00:04:22 -
Formatting charts
00:03:38 -
Line charts
00:02:13 -
Area charts
00:02:04 -
Pie and Doughnut charts
00:03:47 -
Format AreaPlot or XY chart
00:07:34 -
Scatter or bubble charts
00:02:08
Advanced Excel charts
-
Introduction
00:00:52 -
Frequency Distribution and Histograms
00:03:44 -
Waterfall charts
00:01:51 -
Hierarchy charts: sunburst and tree map
00:02:47 -
Combination charts
00:02:20 -
Sparklines
00:04:58
Pivot Charts
-
Pivot charts
Maps Chart above 2019
-
Maps chart
00:03:54 -
3D Maps chart
00:02:37
Business-Geo charts
-
Introduction
00:00:50 -
Stock charts
00:01:56 -
Radar charts
00:01:35 -
Surface charts
00:01:54 -
Heat maps
00:03:32
Named Ranges
-
Named ranges
00:05:03 -
Indirect Name range Function
00:06:14
Import Data into Excel
-
Import Data table from PDF file – Excel 2021
00:03:50 -
Import Data from Website – Excel 2019 above
00:08:49
Advanced Excel
-
Project: Sales forecast tracker
00:06:40 -
Product Sale Tax invoice: Tax Calculations
00:04:38
Reference files and projects
-
Excel Course Notes
-
Pivot Table - Exercise
-
Pivot Table
-
Product Sale Tax invoice
-
Sales forecast tracker small business
sample data
-
sample data
-
file_example_XLSX_100
-
file_example_XLSX_100
-
FromWeb
About the instructor
Sekhar Metla
Instructor
45 Courses
13+ Lesson
1260 Students enrolled
Sekhar Metla is a software engineer with 15 years of professional experience. He is the author of several best-selling TeacherDada courses with more than 26,000+ students in 192 countries. He has a Master of Science in Computer Applications as Software Engineering and is also Microsoft Certified Professional. His students describe him as passionate, pragmatic, and motivational in his teaching.