Microsoft Excel- Beginner to Advanced Course

Solid understanding From Basics to Advanced Level

Created by : Rated :4.7 5956 views

Last Updated: 2023-12-20 12:12:20 English Course Type: Self Learning

Core Excel
Conditional Formatting
Core Excel Formulas and Functions
Core Pivot
Excel Tables
Excel Shortcuts

Weak Excel muscles can impair your performance, sap your energy, and even hinder your career. In a world flooded with data, you need strong Excel skills to survive and thrive. In just one course, Microsoft Excel- Complete Master Program in MS Excel [2021] will teach you how to use a spreadsheet with ease and confidence, and transform your flabby Excel skills into a sturdy Expert you can build on.

What you'll learn

An accelerated, step-by-step program to give you a strong foundation to Expert Level Skills

Core Excel

Weak Excel muscles can impair your performance, sap your energy, and even hinder your career. In a world flooded with data, you need strong Excel skills to survive and thrive. In just one course, Core Excel will teach you how to use a spreadsheet with ease and confidence, and transform your flabby Excel skills into a sturdy foundation you can build on.

Core Excel Formulas and Functions

Formulas are the key to getting work done in Excel. In this accelerated video course, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn powerful skills to troubleshoot, trace errors, and fix problems. This is the formula training you should have had to begin with. End your frustration with Excel formulas and Functions today.

No prior experience required: beginners and experts will learn a lot from the course
Microsoft Excel installed, preferably version 2016 or higher

Financial, business, data analysts who are looking to drastically improve their workflow and master MS Excel

Section 1 : Microsoft Excel- Basics 14 Lectures 00:23:28
Lecture 1 :
Excel- Overview Preview
Lecture 2 :
Open and Close Excel Appilication
Lecture 3 :
Window Controls To Minimize, Maximize and Restore Excel Window
Lecture 4 :
Resize and Move Excel Window
Lecture 5 :
Components of Excel Workbook Interface
Lecture 6 :
Customize Excel Ribbon
Lecture 7 :
Quick Access Tool Bar
Lecture 8 :
Configure password for Excel File
Lecture 9 :
Row, Column and Cell in Excel
Lecture 10 :
Change Row Height in Excel
Lecture 11 :
Change Column width in Excel
Lecture 12 :
Insert Rows, Columns in Excel
Lecture 13 :
Hide and Unhide Rows, Columns in Excel
Lecture 14 :
Delete Rows and Columns in Excel
Section 2 : Microsoft Excel- Worksheets 3 Lectures 00:04:01
Lecture 1 :
Insert, Rename and Delete Worksheets
Lecture 2 :
Hide and Unhide Worksheets in Excel
Lecture 3 :
Freeze Panes at Rows, Columns in Worksheets
Section 3 : Microsoft Excel- Entering Data 8 Lectures 00:08:46
Lecture 1 :
Enter Data in Excel
Lecture 2 :
Edit Data in Excel
Lecture 3 :
Enter Data with Fill handler
Lecture 4 :
Enter Data with Custom Patterns
Lecture 5 :
Move Data in Excel
Lecture 6 :
Duplicate Data in Excel
Lecture 7 :
Delete Data in Excel
Lecture 8 :
Use Drag and Drop in Excel
Section 4 : Microsoft Excel- Find and Replace 5 Lectures 00:03:26
Lecture 1 :
Find a Value in Excel
Lecture 2 :
Find a Formatted Value in Excel
Lecture 3 :
Find All Matches at Once
Lecture 4 :
Find and Replace a Value
Lecture 5 :
Find and Replace a Formatted Value
Section 5 : Microsoft Excel- Cell References 6 Lectures 00:13:43
Lecture 1 :
What is Cell Reference
Lecture 2 :
Relative Reference in Excel
Lecture 3 :
Relative Reference Examples
Lecture 4 :
Absolute Reference
Lecture 5 :
Absolute Reference Example
Lecture 6 :
Mixed Reference in Excel
Section 6 : Microsoft Excel- Font Formatting 7 Lectures 00:15:59
Lecture 1 :
Format Font and Font Size
Lecture 2 :
Bold ,Italic and Underlining Styles
Lecture 3 :
Change Font Colour
Lecture 4 :
Different Underlining Options
Lecture 5 :
Apply superscript, subscript and Strikethrough
Lecture 6 :
Insert Symbols and Special Characters
Lecture 7 :
Format Individual Characters
Section 7 : Microsoft Excel- Borders and Fills 4 Lectures 00:10:21
Lecture 1 :
Apply Border to a cell
Lecture 2 :
Draw Border and Border Grids
Lecture 3 :
Apply Border using Border Presists
Lecture 4 :
Remove Existing Borders
Section 8 : Microsoft Excel- Name Range 4 Lectures 00:00:00
Lecture 1 :
Create Name Range
Lecture 2 :
Name Range Constant
Lecture 3 :
Dynamic Name Range
Lecture 4 :
Dynamic Name Range with Table
Section 9 : Microsoft Excel- Formulas and Functions 3 Lectures 00:18:21
Lecture 1 :
What is Formula and Function in Excel
Lecture 2 :
Arithmetic Operations in Excel
Lecture 3 :
Order of Operations in Excel
Section 10 : Date and Time Functions 6 Lectures 00:13:26
Lecture 1 :
Create Full Date using DATE() Function
Lecture 2 :
Extract Year, Day, Month values using YEAR, MONTH, DAY functions
Lecture 3 :
Generate Time Using HOUR,MINUTE,SECOND and TIME Functions
Lecture 4 :
get time between dates in years, months, or days using DATEDIF and YEARFRAC
Lecture 5 :
Generate past, future and end dates using EDATE() and EOMONTH() Function
Lecture 6 :
Generate weekday and week number using WEEKDAY() and WEEKNUM() functions
Section 11 : Information Function 1 Lectures 00:03:51
Lecture 1 :
Information Functions -ISNUMBER, ISTEXT, ISBLANK, ISERROR
Section 12 : Microsoft Excel- Logical Functions 4 Lectures 00:10:52
Lecture 1 :
Logical Functions - AND () Function
Lecture 2 :
Logical Functions - OR () Function
Lecture 3 :
Logical Functions - NOT() Function
Lecture 4 :
Logical Functions - IF and IFS functions
Section 13 : Microsoft Excel- Statistical Functions 6 Lectures 00:11:22
Lecture 1 :
Count Items using COUNT () Function
Lecture 2 :
Count items based on criteria using COUNTIF() Function
Lecture 3 :
Find Total using SUM () Function
Lecture 4 :
Find Total based on conditions using SUMIF () Function
Lecture 5 :
Find Minimum and Maximum values using MIN () and MAX () Function
Lecture 6 :
Generate averages using AVERAGE () Function
Section 14 : Microsoft Excel- Text Functions 4 Lectures 00:06:54
Lecture 1 :
TEXT Functions---> LEFT, RIGHT, MID () Functions
Lecture 2 :
TEXT Functions -----> LEN () Function
Lecture 3 :
TEXT FUNCTIONS -----> TRIM, CLEAN() Functions
Lecture 4 :
TEXT Functions ------> UPPER, LOWER, PROPER() Functions

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Rajesh Vydhala,

125173 Course Views

3 Courses

Hello Everyone, I'm having 8+yrs experience in IT industry especially in software development and Quality Engineering.Worked with various Top CMM Level organizations. Experience in various domains like Banking, insurance, telecom,CRM,data security. Expertise in Agile and scrum process environments.