Microsoft Excel Mastery: From Beginner to Expert

Microsoft Excel from Beginner to Expert

Excel Basics

Created by : Rated :4.5 805 views

Last Updated: 2024-01-12 07:01:29 English Course Type: Self Learning

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

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.

No Requirements

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.

Section 1 : FUNDAMENTALS 5 Lectures 00:24:45
Lecture 1 :
Introduction Preview
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 8 Lectures 00:11:05
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 3 Lectures 00:00:00
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 2 Lectures 00:00:00
Lecture 1 :
Formatting Data 1
Lecture 2 :
Formatting Data 2
Section 5 : WORKING WITH CELLS & RANGES 3 Lectures 00:00:00
Lecture 1 :
Define Cells & Ranges
Lecture 2 :
Selecting Cells & Ranges
Lecture 3 :
Adding Comments to Cells
Section 6 : PRINTING YOUR WORK IN EXCEL 5 Lectures 00:00:00
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 7 Lectures 00:00:00
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 6 Lectures 00:00:00
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 32 Lectures 00:00:00
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 4 Lectures 00:00:00
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 2 Lectures 00:00:00
Lecture 1 :
Definition, Example
Lecture 2 :
Practice Data
Section 12 : CONDITIONAL FORMATTING 2 Lectures 00:00:00
Lecture 1 :
Definition, Example
Lecture 2 :
Practice Data
Section 13 : DATA VALIDATION 2 Lectures 00:00:00
Lecture 1 :
Definition, Example
Lecture 2 :
Practice Data
Section 14 : AUDITING AN EXCEL WORKSHEET 4 Lectures 00:00:00
Lecture 1 :
Definition, Navigation
Lecture 2 :
Practice Data
Lecture 3 :
Definition, Example
Lecture 4 :
Practice Data

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?

LEMMY FRANCISCO KAWONGA ,

3073 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.