Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
Get Unlimited Learning Access
$29
2 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.
2 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?
- 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
-
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
1575 Course Views
3 Courses
Lemmy Kawonga is a highly skilled and accomplished Chartered Accountant with a strong background in financial management and analysis. With over 10 years of experience in the field, Lemmy has established a reputation for delivering exceptional financial services and strategic guidance to clients.
Throughout Lemmy's career, he has demonstrated a comprehensive understanding of accounting principles, tax regulations, and financial reporting standards. His expertise extends to financial planning, budgeting, risk management, and audit procedures. Lemmy is well-versed in utilizing advanced accounting software and technology to streamline processes and enhance efficiency.
As a Chartered Accountant and a MSc (Professional Accountancy) holder with Merit from University of London, Lemmy has worked with a diverse range of clients, including individuals, small businesses, and multinational NGOs. He has provided valuable insights and recommendations to help clients optimize their financial performance, minimize risks, and make informed business decisions.
With a strong commitment to professionalism and integrity, Lemmy consistently upholds the highest ethical standards in all financial dealings. He prioritizes building long-term relationships with clients, striving to understand their unique needs and tailoring solutions accordingly.
View More...
