Microsoft Excel Basic to Advanced: A Complete Learning Path

Focused View

Click Learning

5:59:49

0 View

1 - Create and open Workbook.mp4

04:24

2 - Tabs and Ribbon.mp4

09:14

3 - Errors Function.mp4

12:10

4 - AND and OR Function.mp4

04:25

5 - NOT Function.mp4

02:43

6 - XOR Function.mp4

04:59

7 - SWITCH Function.mp4

04:35

8 - CELL Function.mp4

03:55

9 - IFS Functions.mp4

05:06

10 - Nesting IF Functions.mp4

03:47

11 - Use IF function to calculate letter grades in Excel.mp4

03:23

12 - Use IFS function to calculate letter grades in Excel.mp4

03:47

13 - Use Filter Function in Excel.mp4

02:09

14 - DATE Function.mp4

05:02

15 - DATEIF Function.mp4

05:19

16 - EDATE Function.mp4

03:20

17 - EOMONTH Function.mp4

01:49

18 - DateValue Function.mp4

03:57

19 - TODAY and NOW Function.mp4

02:56

20 - Convert Time Hours Minutes and Seconds.mp4

04:31

21 - Count Function.mp4

09:27

22 - Round Function.mp4

08:56

23 - Sum Function SUM SUMIF SUMIFS SUMPRODUCT.mp4

11:09

24 - Average Function.mp4

07:58

25 - Subtotal Function.mp4

10:51

26 - Power Function.mp4

03:30

27 - Mod Function.mp4

02:52

28 - INT TRUNC Function.mp4

06:09

29 - MAX MIN MAXA and MINA Function.mp4

05:33

30 - Find and Replace.mp4

06:58

31 - LEN Formulas.mp4

05:10

32 - MID Formulas.mp4

05:03

33 - Rept Formulas.mp4

10:21

34 - Split Formulas.mp4

05:05

35 - Text Formulas.mp4

04:56

36 - Trim Formulas.mp4

03:58

37 - Show Gridlines.mp4

02:16

38 - INDEX Function.mp4

08:13

39 - MATCH Function.mp4

09:38

40 - EXACT Function.mp4

05:40

41 - VLOOKUP APPROXIMATE MATCH Function.mp4

08:02

42 - VLOOKUP Function.mp4

05:12

43 - HLOOKUP Function.mp4

06:42

44 - XLOOKUP Function.mp4

04:52

45 - Exact match vs Approximate match.mp4

08:04

46 - Hyperlink.mp4

04:52

47 - How to import data web to excel.mp4

02:42

48 - Use DETECTLANGUAGE formula in google spread sheets.mp4

01:37

49 - How to convert number to word.mp4

04:17

50 - Dynamic Drop Down List.mp4

05:09

51 - Dependent dropdown List.mp4

05:42

52 - Charts Graphs.mp4

10:51

53 - How to Use Pivot Tables.mp4

06:01

54 - Sort Function.mp4

03:48

55 - Filter Function.mp4

02:17

56 - Merge and Separate data using flash fill.mp4

07:02

57 - Freeze panes.mp4

02:34

58 - Split panes.mp4

01:58

59 - Rename and Color Worksheets.mp4

02:01

60 - Add and Delete Worksheets.mp4

02:57

61 - Hide and Unhide Worksheets.mp4

02:35

62 - Move and Copy Worksheets.mp4

02:32

63 - Worksheet Groups.mp4

01:51

64 - Proetect Worksheet.mp4

05:04

65 - Protect Workbook.mp4

02:48

66 - Lock Individual Cells and Protect Sheets In Excel.mp4

02:00

67 - Sharing Excel Workbook with Multiple Users.mp4

05:03

68 - Headers and footers.mp4

04:35

69 - Page settings.mp4

02:42

70 - Page break view.mp4

02:19

71 - Print selection.mp4

03:28

72 - Set print area.mp4

02:58

Description

Master Microsoft Excel from the ground up, covering essential basics to advanced techniques in this comprehensive course

What You'll Learn?

Create and Open Workbook
Tabs and Ribbon
Errors Functions
AND, OR, XOR, SWITCH, CELL Functions
IF and Nesting IF() Functions
Filter Functions
DATE and DATEVALUE Functions
Convert Time Hours, Minutes and Seconds
COUNT, ROUND, SUM, AVERAGE Functions
Subtotal and Power Functions
INT & TRUNC Function
Find and Replace
LEN, MID, REPT, SPLIT, TEXT and TRIM
INDEX, MATCH, EXACT Functions
VLOOKUP, HLOOKUP and XLOOKUP Functions
Exact match vs Approximate match
Import Data Web to Excel
Convert Number to Word
Dynamic dropdown List
Dependent dropdown List
Charts & Graphs
Sort and Filter Functions
Proetect Worksheet and Worksheet
Freeze and Split Panes
Headers and Footers
Page settings
Set Print Area

Who is this for?

Anyone interested in becoming a proficient Excel user.

Start from the basics and advance step by step.

What You Need to Know?

No Prior Experience Required

More details

Description
Master the power of Microsoft Excel with this comprehensive course that guides you from beginner-level basics to advanced techniques. Whether you're just starting with Excel or aiming to enhance your skills for work, this all-inclusive course covers everything you need to become a proficient Excel user and take on complex tasks with confidence.

What Youâ€™ll Learn:
Excel Fundamentals: Navigate the Excel interface, understand spreadsheets, and perform basic tasks such as data entry, formatting, and calculations.
Formulas and Functions: Gain a strong grasp of Excelâ€™s core formulas and functions, including SUM, AVERAGE, VLOOKUP, and IF statements, to perform essential calculations and data analysis.
Data Visualization: Create compelling charts and graphs to visually present data, and apply conditional formatting to highlight trends and patterns.
PivotTables and PivotCharts: Dive deep into PivotTables and PivotCharts for summarizing large datasets, making it easier to extract insights and report findings.
Data Analysis and Validation: Use Excelâ€™s built-in data analysis tools like Goal Seek, Solver, and Data Validation to enhance decision making and streamline your workflow.
Macros and Automation: Automate repetitive tasks by recording and running macros, making your Excel processes more efficient and productive.
Advanced Excel Techniques: Learn more advanced features such as What If Analysis, INDEX & MATCH, and Power Query for handling large datasets and performing complex tasks.

This Course Includes:
Create and Open Workbook
Tabs and Ribbon
Errors Functions
AND, OR, XOR, SWITCH, CELL Functions
IF and Nesting IF() Functions
Filter Functions
DATE and DATEVALUE Functions
Convert Time Hours, Minutes and Seconds
COUNT, ROUND, SUM, AVERAGE Functions
Subtotal and Power Functions
INT & TRUNC Function
Find and Replace
LEN, MID, REPT, SPLIT, TEXT and TRIM
INDEX, MATCH, EXACT Functions
VLOOKUP, HLOOKUP and XLOOKUP Functions
Exact match vs Approximate match
Import Data Web to Excel
Convert NumberÂ to Word
Dynamic dropdown List
Dependent dropdown List
Charts & Graphs
Sort and Filter Functions
Protect Worksheet and Worksheet
Freeze and Split Panes
Headers and Footers
Page settings
Set Print Area
And Many Mores

Why Take This Course?
Comprehensive Curriculum: From basic to advanced, this course is designed to build a complete set of Excel skills.
Practical Applications: Real world examples and projects that enable you to apply your new skills immediately.
Step-by-Step Learning: Lessons are structured to ensure gradual, effective learning, with clear instructions.

By the end of this course, you will have mastered Excel from the basics to advanced features, making you a powerful and efficient Excel user. Enroll now and take your Excel skills to the next level!
Who this course is for:
Anyone interested in becoming a proficient Excel user.
Start from the basics and advance step by step.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Click Learning

Instructor's Courses

Click Learning revolutionizes technical education with a commitment to accessibility and innovation. Our platform offers a diverse range of courses and tutorials, empowering learners to acquire and enhance their technical skills. With a flexible, self-paced learning environment and expert instructors, we ensure that students of all levels can stay current in tech fields like coding, data science, cybersecurity, and web development. Click Learning isn't just about knowledge; it's about fostering adaptability and innovation to thrive in the dynamic tech world. Join us on this journey, and embrace the future of technical education.

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.