This plan includes
- Limited free courses access
- Play & Pause Course Videos
- Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Email & Chat Support
What you'll learn?
- Excel Fundamentals: Start your journey by building a solid foundation in Excel.
- Formula Magic: Dive into the world of Excel formulas and functions. Understand the logic behind calculations, create dynamic formulas, and leverage functions.
- Data Analysis and Visualization: Explore advanced data analysis techniques using Excel's powerful tools. Learn to create pivot tables, sort and filter data.
- Clean Data Using Power Query
- How to Work with Tabular Data
- Conditional Formatting
- IF Functions, Nested IF Functions
- Charts, Pivot Charts
- V-Lookup, H-Lookup, X-Lookup
- Data Validation
- Flash Fill
- Auditing an Excel Worksheet
- Pivot Tables
Course Overview
Unlock the full potential of Microsoft Excel with my comprehensive course designed for learners at all levels. Whether you're a complete novice or an intermediate user looking to enhance your skills, "Microsoft Excel Mastery: From Beginner to Advanced Level" is your ultimate guide to mastering this powerful spreadsheet software.
What You'll Learn:
-
Excel Fundamentals: Start your journey by building a solid foundation in Excel. Learn how to navigate the interface, enter and format data, and use essential functions. Master the basics of cells, rows, and columns to lay the groundwork for more advanced techniques.
-
Formula Magic: Dive into the world of Excel formulas and functions. Understand the logic behind calculations, create dynamic formulas, and leverage functions like SUM, VLOOKUP, and IF statements. Gain the skills to automate tasks and streamline your workflow.
-
Data Analysis and Visualization: Explore advanced data analysis techniques using Excel's powerful tools. Learn to create pivot tables, sort and filter data, and generate insightful charts and graphs. Uncover hidden trends and patterns within your datasets.
-
Advanced Data Management: Take control of large datasets with advanced data management features. Master techniques for data validation, conditional formatting, and custom sorting. Organize and clean your data like a pro.
Why Take This Course?
-
Practical Application: Each module includes real-world examples and hands-on exercises to reinforce your learning and ensure practical application.
-
Lifetime Access: Gain unlimited access to course materials, updates, and resources. Continue learning at your own pace, anytime, anywhere.
-
Expert Instruction: Benefit from the expertise of a seasoned Excel professional who will guide you through each step of the learning process.
Pre-requisites
- No Requirements
Target Audience
- Beginners: Individuals with little to no experience in using Microsoft Excel will benefit from the foundational content that covers the basics of navigating the interface, entering data, and understanding fundamental functions.
- Intermediate Users: Those who have a basic understanding of Excel but want to enhance their skills and delve into more advanced features, such as formulas, data analysis, and visualization, will find valuable insights and practical exercises.
- Students: Students studying business, finance, or any field that involves data analysis will find the course beneficial in developing practical Excel skills that are widely used in academia and the professional world.
- Anyone Seeking Excel Mastery: Whether you're looking to boost your resume, improve your productivity, or simply want to become proficient in Excel for personal or professional reasons, this course provides a comprehensive journey from beginner to advanced levels.
Curriculum 85 Lectures 00:35:50
Section 1 : FUNDAMENTALS
- Lecture 2 :
- Saving & Opening a Workbook
- Lecture 3 :
- Ribbon, Tabs
- Lecture 4 :
- Navigating a Worksheet
- Lecture 5 :
- Test Your Understanding
Section 2 : ENTERING & EDITING WORKSHEET DATA
- Lecture 1 :
- Data Types
- Lecture 2 :
- Entering Text
- Lecture 3 :
- Entering a Formula
- Lecture 4 :
- Entering Dates
- Lecture 5 :
- Inserting Charts
- Lecture 6 :
- Inserting Objects, Pictures
- Lecture 7 :
- Modifying Cell Contents
- Lecture 8 :
- Practice Data
Section 3 : WORKING WITH EXCEL WORKSHEETS
- Lecture 1 :
- Deleting & Naming a Worksheet
- Lecture 2 :
- Adding a Worksheet, Tab Colour
- Lecture 3 :
- Hiding Rows & Columns, Zoom in and Out
Section 4 : FORMATTING & ALIGNING DATA
- Lecture 1 :
- Formatting Data 1
- Lecture 2 :
- Formatting Data 2
Section 5 : WORKING WITH CELLS & RANGES
- Lecture 1 :
- Define Cells & Ranges
- Lecture 2 :
- Selecting Cells & Ranges
- Lecture 3 :
- Adding Comments to Cells
Section 6 : PRINTING YOUR WORK IN EXCEL
- Lecture 1 :
- Printing Navigation 1
- Lecture 2 :
- Printing Navigation 2
- Lecture 3 :
- Converting Excel Worksheet to PDF
- Lecture 4 :
- Page Breaks
- Lecture 5 :
- Manual Page Breaks
Section 7 : WORKING WITH TABLES
- Lecture 1 :
- Define & Create Tables, Examples
- Lecture 2 :
- Filter & Sort Data in a Table
- Lecture 3 :
- Sorting Continued
- Lecture 4 :
- Formatting a table
- Lecture 5 :
- Sorting Tabular Data Revisited
- Lecture 6 :
- Practice Data
- Lecture 7 :
- Practice Data
Section 8 : PROTECTING YOUR WORKBOOK & WORKSHEET
- Lecture 1 :
- Protecting a Workbook 1
- Lecture 2 :
- Protecting a Workbook 2
- Lecture 3 :
- Protecting Parts of a Worksheet
- Lecture 4 :
- Practice Data
- Lecture 5 :
- Practice Data 2
- Lecture 6 :
- Practice Data 3
Section 9 : WORKING WITH FORMULAS & FUNCTIONS
- Lecture 1 :
- Add, Subtract, Multiply, Divide
- Lecture 2 :
- Relative & Absolute Reference
- Lecture 3 :
- V-Lookup
- Lecture 4 :
- V-Lookup Application
- Lecture 5 :
- H-Lookup
- Lecture 6 :
- X-Lookup
- Lecture 7 :
- Sum, Min, Max, Average
- Lecture 8 :
- SumIF, CountIF, Aggregate
- Lecture 9 :
- Practice
- Lecture 10 :
- Concatenate, Text Join
- Lecture 11 :
- Trim, Right, Left
- Lecture 12 :
- Upper, Lower, Proper
- Lecture 13 :
- Practice Data
- Lecture 14 :
- Date Formulas: Now, Today, Days, Networking Days
- Lecture 15 :
- Date Formulas: Working Day
- Lecture 16 :
- Date Formulas: Year, Month, Day
- Lecture 17 :
- Practice Data
- Lecture 18 :
- Basic IF Function
- Lecture 19 :
- Nested IF Function
- Lecture 20 :
- IF Error
- Lecture 21 :
- IF AND, IF OR
- Lecture 22 :
- Practice Data
- Lecture 23 :
- Pivot Tables: Definition, Examples
- Lecture 24 :
- Pivot Tables Examples
- Lecture 25 :
- Practice Data
- Lecture 26 :
- Practice Data 2
- Lecture 27 :
- Power Querry- Defintion
- Lecture 28 :
- Power Querry- Getting Data from Excel, PDF, WEB
- Lecture 29 :
- Power Querry- Cleaning Data
- Lecture 30 :
- Power Querry: Connecting Power Querry to the WEB
- Lecture 31 :
- Power Querry- Consolidate, Merge Data from Different Workbooks
- Lecture 32 :
- Practice Data
Section 10 : EXCEL CHARTS
- Lecture 1 :
- Definition, Types & Examples
- Lecture 2 :
- Example, Pie Chart, Customisation, Formatting
- Lecture 3 :
- Practice Data
- Lecture 4 :
- Practice Data 2
Section 11 : PIVOT CHART
- Lecture 1 :
- Definition, Example
- Lecture 2 :
- Practice Data
Section 12 : CONDITIONAL FORMATTING
- Lecture 1 :
- Definition, Example
- Lecture 2 :
- Practice Data
Section 13 : DATA VALIDATION
- Lecture 1 :
- Definition, Example
- Lecture 2 :
- Practice Data
Section 14 : AUDITING AN EXCEL WORKSHEET
- Lecture 1 :
- Definition, Navigation
- Lecture 2 :
- Practice Data
- Lecture 3 :
- Definition, Example
- Lecture 4 :
- Practice Data
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
3065 Course Views
3 Courses