Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
Get Unlimited Learning Access
$29
6 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
6 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
$29
What you'll learn?
- Core Excel
- Conditional Formatting
- Core Excel Formulas and Functions
- Core Pivot
- Excel Tables
- Excel Shortcuts
Course Overview
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.
Pre-requisites
- No prior experience required: beginners and experts will learn a lot from the course
- Microsoft Excel installed, preferably version 2016 or higher
Target Audience
- Financial, business, data analysts who are looking to drastically improve their workflow and master MS Excel
Curriculum 75 Lectures 02:24:30
-
Section 1 : Microsoft Excel- Basics
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Lecture 1 :
- Information Functions -ISNUMBER, ISTEXT, ISBLANK, ISERROR
-
Section 12 : Microsoft Excel- Logical Functions
- 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
- 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
- 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
Our learners work at
Frequently Asked Questions
-
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?
Instructor
122257 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.
View More...
