Excel from Beginners to Expert

Name: Excel from Beginners to Expert
Rating: 4.5 (4 reviews)

The most comprehensive Excel Course

Created byYideaz Software Trainings

Last updated 2/2023

English

English [Auto],

What you'll learn

Mastery of Excel Basics: By the end of this course, learners should be able to navigate Excel's interface, perform basic data entry, formatting, and calculation
Advanced Data Analysis: After completing this course, learners should be able to manipulate data and create complex formulas and functions
Automation and Macros: By the end of this course, learners should be able to create macros and automate repetitive tasks using Excel's VBA programming language.
Explain how to apply the Microsoft Excel information in an office environment
Data Visualization: After completing this course, learners should be able to create effective visual representations of data using Excel's charting and graphing

Course content

19 sections • 118 lectures • 9h 3m total length

Learning Excel2:02

Basic Lesson and Layout of Course1:16
This Lesson explains the Basics and what are the topics which will be covered in the Fundamental Section
Uses of Excel and how it can help you in your work environment3:22
A brief history of Excel2:01
Launching the Excel Application2:13
Working with Excel Sheets5:08
Handy Tips and Tricks in Excel8:49
Quick Quiz on What we learnt
Importance of Shortcut Keys to improve efficiency in Excel0:53
Topics Covered on this module on the Introduction to the Fundamentals of Excel0:48
Master the fundamentals of Excel by exploring its history, versions, launching the application, and creating and manipulating documents, including understanding rows and columns.
Things to do to get familiar and fluent with Excel2:27
This video lesson explains what you would need to do to get familiar and fluent with Excel

Topics to be covered on Editing Excel Sheets and Data types0:44
What is a Workbook and a Worksheet and the differences2:37
Different Data Types in Excel4:04
The Excel Work Area and the different parts of the User Interface14:02
Creating and Saving your first Excel Workbook5:04
Create a simple Excel sheet for y c clothing, enter monthly sales data from January to September, and learn how to save, save as, open, and retrieve the workbook.
Quiz Time
Topics Covered on this module of Editing Excel Worksheets and data types0:44

Topics to be covered on this module on formulas and functions1:22
Creating A Simple Formula1:47
Mathematical Operators1:04
Comparison Operators0:33
Relative and Absolute Reference5:22
Order of Operations6:04
Difference between Formulas and Functions3:53
Sum Function3:05
Averages Function5:11
Count and Counta Function2:51
If Function2:28
Max and Min Function in Excel2:16
Check your understanding of Formulas and Functions
Topics covered in this module of Formulas and Functions1:14

Topics to be covered in working with data0:50
Selecting Data in Excel3:11
Copy Pasting Data in Excel2:39
Create Delete and Rename a sheet in Excel2:02
Paste Special in Excel4:59
Changing the Width and Height of a Column and Rows2:38
Hiding and Unhiding Sheets in Excel3:07
Move and Copy a Worksheet in a Workbook1:57
Change the Font Size and Colour of Text in Excel4:28
Creating a Table in Excel and its importance in Excel9:08
Wrapping Text in Excel1:37
Sorting and Filtering Data4:07
Using the Find and Select Options in Excel9:48
Removing Duplicate Data in Excel Sheet8:19
Freezing Panes in Excel2:08
Filtering Data Using A Single Criteria10:55
Filtering Data On Multiple Criteria2:04
Quiz Time
What we covered in the module on Working With Data0:49
Master essential data handling in Excel, including adjusting row and column layouts, copy and paste, paste special, and filtering, sorting, and find and select to work efficiently.

Topics Covered on the module for Formatting Data in Excel0:39
Formatting Cells As percentages4:42
Formula and Percentage formatting Challenge4:16
Using Format Painter1:53
Apply the format painter to copy cell formatting from one cell to others, ensuring uniform formats across the sheet. Learn to double-click to extend formatting to multiple destinations.
Merging and Unmerging Cells3:53
All about Conditional Formatting12:34
Auto Fill and Flash Fill10:51
What we covered in this module on Formatting Data0:53

Topics to be covered in this Module0:50
Vlookup and Hlookup10:04
Sumif, Countif and Average if functions6:36
DSum, DAverage, DCount functions6:02
Left Right and Middle Function2:11
Max and Min Function0:54
Cleaning Data using the Trim and Substitute Function6:15
Concatenate Function in Excel4:13
Explore how the concatenate function joins text from multiple cells in Excel, learn to insert spaces, and use trim to remove extra spaces when combining first, middle, and last names.
Index Match Function and its diverse uses21:06
All powerful Xlookup Function15:33
Topics covered in this module1:14

Requirements

No Excel experience required as all the information will be taught, basic use of the computer is needed
A good internet connection and Microsoft office installed on the system

Description

In this fast-changing world, there is a great demand for people who can help make sense of data, Excel is a great tool for that, so by learning this skill you can help your career move in the correct direction and help you evolve in this data-driven economy.

This course aims at getting you upskilled, with all the concepts of Excel to help you with using this powerful tool to help solve some of the challenges that data pose in today's work environment.

The aim of the course is to introduce the learner to the basic concepts of Excel and Data analysis tools.

Learners will learn how to collect, compile, analyze and present data using the different tools in Excel.

This course will introduce learners to concepts like basics of Excel, editing data with Excel, Formulas and Functions from basic to Advanced, working with data sets, formatting and modifying data, printing data, graphical representation of data, Pivot tables and data analysis, and automation of Excel tasks and VBA concepts.

Concepts and lessons will be illustrated with practice files to follow along.

Once you have learned and mastered Excel you will have the confidence to resolve data-related problems you face in the work environment.

Making you a valuable contributor to any team.

Who this course is for:

Beginners with no experience in Microsoft Excel

Excel from Beginners to Expert

What you'll learn

Explore related topics

Course content

Getting Started with Excel1 lecture • 2min

Fundamentals of Excel9 lectures • 27min

Editing Excel Worksheets and Data Types6 lectures • 27min

Formulas and Function and basics of their uses13 lectures • 37min

Working with data in Excel18 lectures • 1hr 15min

Formatting Data8 lectures • 40min

Importing Modifying and Using Elements in Excel6 lectures • 34min

Graphical Representation of Data in Excel4 lectures • 25min

Printing in Excel8 lectures • 25min

Commonly used formulas and functions in Excel11 lectures • 1hr 15min

Requirements

Description

Who this course is for: