Microsoft Excel Mastery: From Beginner to Expert- 2024

Focused View

Lemmy Kawonga BAcc. ACCA. MSc (Accountancy)

12:46:05

10 View

1. Introduction

1. Introduction.mp4

06:38

2. Definitions.mp4

12:35

3. Saving & Opening a WorkBook.mp4

06:48

4.1 Fundamentals.pptx

4.2 Test Your Understanding.xlsx

4. Navigating the Worksheet.mp4

04:45

5. Ribbon, Tabs.mp4

06:19

2. Entering & Editing Worksheet Data

1.1 Entering & Editing Worksheet Data.pptx

1.2 WLD RTFP country 2023-10-02.csv

1. Data Types.mp4

10:57

2. Entering Text.mp4

11:09

3. Entering a Formula.mp4

04:55

4. Entering Dates.mp4

07:50

5. Inserting Charts.mp4

16:20

6. Inserting Objects & Pictures.mp4

05:49

7. Modifying Cell Contents.mp4

11:22

3. Working with Worksheets

1.1 Modifying an Excel Worksheet.pptx

1. Delete & Name a Worksheet.mp4

10:33

2. Add a Worksheet, Change a Tab Colour.mp4

08:04

3. Hiding Rows & Columns, Zoom In & Zoom Out.mp4

22:00

4. Formatting & Aligning Data

1.1 Formatting and Aligning Data.pptx

1. Formatting Data 1.mp4

14:06

2. Formatting Data 2.mp4

11:37

5. Working with Cells & Ranges

1.1 Working with Cells & Ranges.pptx

1. Define Cells & Ranges.mp4

11:19

2. Selecting Cells & Ranges.mp4

17:57

3. Adding Comments to Cells.mp4

12:52

6. Printing Your Work in Excel

1. Printing Navigation 1.mp4

08:04

2. Printing Navigation 2.mp4

06:55

3. Convert Excel Worksheet to PDF.mp4

04:42

4. Page Breaks.mp4

07:50

5. Manual Page Breaks.mp4

05:37

7. Working with Tables in Excel

1.1 Tables.pptx

1. Define & Create Tables, Examples.mp4

24:33

2. Filter & Sort Data in an Excel Table.mp4

15:45

3. Sorting Continued.mp4

03:05

4. Formatting a Table.mp4

05:10

5. Formatting a Table.mp4

03:48

8. Protecting Your Worksheet & Workbook

1.1 Credit Notes.xlsx

1.2 Protecting a Workbook.xlsx

1.3 Protecting a Worksheet.xlsx

1. Protect a Workbook 1.mp4

05:41

2. Protecting a Workbook 2.mp4

03:25

3. Protecting a Worksheet.mp4

18:32

9. Working with Formulas & Functions

1. Add, Subtract, Multiply, Devide.mp4

22:52

2. Relative & Absolute References.mp4

10:23

3. V-Lookup.mp4

18:56

4. V-Lookup Application.mp4

17:47

5. H-Lookup.mp4

07:40

6. X-Lookup.mp4

13:36

7. SUM, MAX, MIN, AVERAGE.mp4

20:52

8.1 Practice Data Set.csv

8. SUMIF, COUNTIF, AGGREGATE.mp4

24:17

9. CONCANTENATE & TEXT JOIN.mp4

10:50

10. TRIM, LEFT, RIGHT.mp4

11:49

11.1 student math clean.csv

11. UPPER, LOWER, PROPER.mp4

08:34

12.1 1.1 Examples.xlsx

12. Date Formulas NOW, TODAY, DAYS, NETWORKING DAYS.mp4

14:56

13. Date Formulas WORKING DAY.mp4

04:38

14. Date Formulas YEAR, MONTH, DAY.mp4

07:39

15.1 DATA.xlsx

15. IF FUNCTIONS BASIC IF FUNCTION.mp4

11:29

16. IF FUNCTION NESTED IF FUNCTION.mp4

09:08

17. IF FUNCTION IF ERROR.mp4

07:16

18. IF FUNCTION IF AND, IF OR.mp4

12:48

10. PIVOT TABLES

1.1 Data 1.csv.xlsx

1.2 Data 1.xlsx

1.3 Pivot Tables.pptx

1. Definition, Navigation.mp4

17:09

2. EXAMPLE PIVOT TABLE.mp4

11:24

11. POWER QUERY

1.1 Data Normalisation.xlsx

1.2 Getting Data from the WEB.xlsx

1.3 Malawi Stock Exchange.xlsx

1.4 Practice.xlsx

1.5 Sales Report.xlsx

1. DEFINITION.mp4

05:25

2.1 POWER QUERY.pptx

2. Getting Data From Excel, PDF, WEB.mp4

17:39

3. Cleaning Data.mp4

25:47

4. Connecting Power Query to the WEB.mp4

07:45

5. Consolidating Data From Different Files into One File.mp4

13:58

12. CHARTS

1.1 ds salaries.csv

1.2 Excel Charts.pptx

1.3 OECD Alcohol Consumption per Capita.csv

1. Definition, Types and Examples.mp4

17:50

2. Example, Pie Chart, Customisation, Formatting.mp4

14:17

13. PIVOT CHART

1.1 ds salaries.xlsx

1.2 Pivot Chart.pptx

1. Definition, Example Pivot Charts.mp4

12:12

14. CONDITIONAL FORMATTING

1.1 Conditional Formatting.pptx

1.2 Practice Data.xlsx

1. Definition & Examples.mp4

15:43

15. DATA VALIDATION

1.1 Data Validation.pptx

1.2 housing price dataset.csv

1. Definition, Examples.mp4

18:44

16. AUDITING AN EXCEL WORKSHEET

1.1 Annual 2019 Budget COMREP - 23-09-19 (004).xlsx

1.2 Auditing an Excel Worksheet.pptx

1. Auditing Excel Formulas in a Worksheet.mp4

10:39

17. FLASH FILL

1.1 CustomterMaster.xlsx

1.2 Flash Fill.pptx

1. Definition, Examples.mp4

15:01

Description

Excel for Beginners

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

Who is this for?

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.

What You Need to Know?

No requirements needed, the course starts from scratch.

More details

Description
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.
Who this course is for:
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.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Lemmy Kawonga BAcc. ACCA. MSc (Accountancy)

Instructor's 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.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.