Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
17 Hour(s) 26 Minute(s)
Language
English
Taught by
Lemmy Kawonga BAcc. ACCA. MSc (Accountancy)
Rating
Course Overview
Excel for Beginners
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.
Course Content
- 10 section(s)
- 86 lecture(s)
- Section 1 Introduction
- Section 2 Entering & Editing Worksheet Data
- Section 3 Working with Worksheets
- Section 4 Formatting & Aligning Data
- Section 5 Working with Cells & Ranges
- Section 6 Printing Your Work in Excel
- Section 7 Working with Tables in Excel
- Section 8 Protecting Your Worksheet & Workbook
- Section 9 Working with Formulas & Functions
- Section 10 PIVOT TABLES
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
- Real Life Projects
Skills covered in this course
Reviews
-
NNathaniel Nhial Majok Kuer
it is a good course for me because am doing electrical projects
-
AAnne Canales
Hard to understand the instructor. I feel like he just got on and started playing around with a very vague outline of what he was going to talk about. Seemed a bit unorganized.
-
AAmanda Cerny
It was a really great and worthwhile journey. Mr Lemmy teachings were seasoned and meticulously tailored to ensure that learners are properly taught from one step to the next. However, I wish there would be more emphasis on advanced formulas e.g one formula for computing College results to the display the scores with Grades, GPA, CGPA, Remarks etc.
-
EEden zedicurse
I really enjoyed the entire journey. Such a valuable and helpful undertaking, Moreover, it made me realize that I have just started to scratch the surface, and there is a lot to learn and practice about Excel and VBA in particular. And I am feeling motivated to explore more about it. I appreciate your professionalism, teaching method and spirit. Flying colours from the other side of the Atlantic! Thank you Lemmy and Udemy!
