Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
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
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
What you'll learn?
- Everything you need from excel to be expert
Course Overview
Are you looking to master Microsoft Excel, one of the most indispensable tools in the modern workplace? Whether you're a complete beginner or have some experience with Excel, this comprehensive course will take you from zero to hero, equipping you with the skills and knowledge needed to excel in data management, analysis, and reporting.
Course Overview:
This Microsoft Excel course is designed to empower individuals with little to no prior Excel experience, as well as those who want to enhance their existing skills. By the end of this course, you will have the confidence and expertise to handle Excel tasks with ease, from basic data entry to advanced data analysis.
Key Learning Objectives:
-
Excel Fundamentals: Start from the ground up by exploring Excel's interface, basic functions, and fundamental concepts.
-
Data Entry and Formatting: Learn how to input, edit, and format data efficiently to create polished and professional-looking spreadsheets.
-
Formulas and Functions: Master Excel's powerful formula and function capabilities to perform calculations, automate tasks, and analyze data effectively.
-
Data Visualization: Create compelling charts and graphs to visually represent data and enhance your reports.
-
Data Analysis: Dive into data analysis techniques, including sorting, filtering, and pivot tables, to gain valuable insights from your data.
-
Data Validation and Protection: Ensure data accuracy and security by implementing validation rules and protecting your worksheets and workbooks.
-
Time-Saving Tips and Tricks: Discover shortcuts, tips, and tricks that will boost your productivity and efficiency when working with Excel.
-
Advanced Excel Features: Explore advanced features such as conditional formatting, advanced functions, and macros to streamline complex tasks.
-
Collaboration and Sharing: Learn how to collaborate with others in real-time using Excel's sharing and online collaboration features.
-
Practical Projects: Apply your skills to real-world scenarios and projects, reinforcing your understanding and building a portfolio of Excel work.
Pre-requisites
- No Requirement this course is for absolute beginners
Target Audience
- Anyone want to gain very valuable skills in Excel
Curriculum 56 Lectures
-
Section 1 : Course Introduction
-
Section 2 : Excel Essential Skills
- Lecture 1 :
- Basic data entry
- Lecture 2 :
- Excel Basic Formula
- Lecture 3 :
- Relative References
- Lecture 4 :
- Order of Operations
- Lecture 5 :
- Working with ranges
- Lecture 6 :
- Working with freez panes
- Lecture 7 :
- Working with split screen
- Lecture 8 :
- Working with print titles
- Lecture 9 :
- Working with comments and notes
- Lecture 10 :
- Copy cut past operations
-
Section 3 : Excel Med Skills
- Lecture 1 :
- 3d formula
- Lecture 2 :
- sheet basic operations
- Lecture 3 :
- Boarder and Shading
- Lecture 4 :
- Data validation
- Lecture 5 :
- Fill Handle and custom list
- Lecture 6 :
- Formatting numbers
- Lecture 7 :
- remove duplicate
- Lecture 8 :
- Search in sheet and workbook
- Lecture 9 :
- sheet format-format painter
- Lecture 10 :
- sheet format-alignment
- Lecture 11 :
- sheet format-font
- Lecture 12 :
- sheet format styles and cell
- Lecture 13 :
- sheet sorting
- Lecture 14 :
- sheet protection
- Lecture 15 :
- sheet sorting
- Lecture 16 :
- working with tables
- Lecture 17 :
- working with range names
- Lecture 18 :
- watch window
- Lecture 19 :
- working with charts
- Lecture 20 :
- pivot table and pivot chart
- Lecture 21 :
- working with slicer and time lines
-
Section 4 : Excel Functions and formula
- Lecture 1 :
- count functions
- Lecture 2 :
- Sum Functions
- Lecture 3 :
- IF function
- Lecture 4 :
- AND-OR Functions
- Lecture 5 :
- IFs Function
- Lecture 6 :
- Date if function
- Lecture 7 :
- Date and time Functions
- Lecture 8 :
- age calculation in Excel
- Lecture 9 :
- VLOOKUP-exact match
- Lecture 10 :
- VLOOKUP-approximate match
- Lecture 11 :
- Forecast Function
- Lecture 12 :
- Maxifs and Minifs Function
- Lecture 13 :
- Mode Function
- Lecture 14 :
- Standard Deviation Function
- Lecture 15 :
- Rank and Rank Average Functions
- Lecture 16 :
- Rand and Rand Between Functions
- Lecture 17 :
- Text Functions
- Lecture 18 :
- Average and Average if Functions
- Lecture 19 :
- Weekday and Network Functions
-
Section 5 : Special Skills
- Lecture 1 :
- Download Barcode font in Excel
- Lecture 2 :
- Install Barcode font in Excel
- Lecture 3 :
- Create Barcode in Excel
- Lecture 4 :
- Auto Functions
- Lecture 5 :
- Add Chatbot in Excel
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
885 Course Views
2 Courses
.png?crop=smart&width=600&height=400)
