MS Excel - You will Love Excel Just in 05 Hours

Focused View

Machma Virtual College of Skill Development

4:50:51

25 View

1. All In 3 Minutes.mp4

03:01

2.1 MS Excel Activity Book.xlsx

2. MS Excel - Part 01.mp4

11:19

3. MS Excel - Part 02.mp4

10:21

4. MS Excel - Part 03.mp4

10:25

5. MS Excel - Part 04.mp4

05:49

6. MS Excel - Part 05.mp4

05:50

7. MS Excel - Part 06.mp4

10:44

8. MS Excel - Part 07.mp4

09:41

9. MS Excel - Part 08.mp4

10:52

10. MS Excel - Part 09.mp4

22:05

11. MS Excel - Part 10.mp4

06:15

12. MS Excel - Part 11.mp4

11:15

13. MS Excel - Part 12.mp4

03:55

14. MS Excel - Part 13.mp4

03:02

15. MS Excel - Part 14.mp4

12:28

16. MS Excel - Part 15.mp4

02:25

17. MS Excel - Part 16.mp4

13:31

18. MS Excel - Part 17.mp4

06:17

19. MS Excel - Part 18.mp4

02:48

20. MS Excel - Part 19.mp4

03:32

21. MS Excel - Part 20.mp4

03:07

22. MS Excel - Part 21.mp4

03:37

23. MS Excel - Part 22.mp4

04:56

24. MS Excel - Part 23.mp4

04:00

25. MS Excel - Part 24.mp4

04:15

26. MS Excel - Part 25.mp4

14:34

27. MS Excel - Part 26.mp4

06:05

28. MS Excel - Part 27.mp4

02:11

29. MS Excel - Part 28.mp4

08:43

30. MS Excel - Part 29.mp4

03:04

31. MS Excel - Part 30.mp4

07:50

32. MS Excel - Part 31.mp4

04:07

33. MS Excel - Part 32.mp4

02:51

34. MS Excel - Part 33.mp4

02:24

35. MS Excel - Part 34.mp4

04:37

36. MS Excel - Part 35.mp4

02:10

37. MS Excel - Part 36.mp4

01:20

38. MS Excel - Part 37.mp4

00:41

39. MS Excel - Part 38.mp4

03:17

40. MS Excel - Part 39.mp4

00:49

41. MS Excel - Part 40.mp4

06:01

42. MS Excel - Part 41.mp4

01:57

43. MS Excel - Part 42.mp4

01:03

44. MS Excel - Part 43.mp4

02:04

45. MS Excel - Part 44.mp4

03:13

46. MS Excel - Part 45.mp4

03:34

47. MS Excel - Part 46.mp4

02:34

48. MS Excel - Part 47.mp4

02:10

49. MS Excel - Part 48.mp4

04:46

50. MS Excel - Part 49.mp4

00:36

51. MS Excel - Part 50.mp4

01:44

52. MS Excel - Part 51.mp4

03:11

53. MS Excel - Part 52.mp4

00:51

54. MS Excel - Part 53.mp4

00:52

55. MS Excel - Part 54.mp4

01:01

56. MS Excel - Part 55.mp4

00:44

57. MS Excel - Part 56.mp4

00:34

58. MS Excel - Part 57.mp4

01:19

59. MS Excel - Part 58.mp4

01:43

60. MS Excel - Part 59.mp4

00:41

Description

Covering these 60 videos will make you love excel

What You'll Learn?

Master essential functions for effective data management and analysis.
Create impactful charts and graphs to interpret and present data.
Utilize advanced formulas for in-depth data analysis and problem-solving.
Learn to protect, share, and collaborate efficiently using Excel's security features.

Who is this for?

Excel Skill Development

What You Need to Know?

No prior skill is needed

More details

Description
Dive into the world of Microsoft Excel with this easy-to-follow course. It's perfect for those starting out or looking to refresh their skills. You'll learn the basics of Excel, from understanding the layout to organizing data neatly. We'll guide you through creating eye-catching charts, performing simple calculations, and managing lists effectively. Plus, you'll get tips on how to keep your data safe and share it with others smoothly. By the end of this course, you'll be comfortable using Excel for everyday tasks, making your work or study life easier and more organized.

Syllabus Content

I. Introduction to Excel
Basic Parts of Excel Window
How to Save
How to Page Setup & Print
II. Data Entry and Formatting
Items in Group Clipboard (Home Tab)
Items in Group Font (Home Tab)
Items in Group Alignment (Home Tab)
Items in Group Number (Home Tab)
Inserting Pictures, Shapes & Smart Art
Inserting Equation & Symbol
Insert a Dropdown List
Check Spelling
How to Hide Gridlines
III. Data Manipulation and Analysis
Items in Group Editing (Home Tab)
Sum, Average, Rank, Max & Min
Count & CountA
Upper, Lower & First Letter Capital
Combine Word from Different Cells
Columns to Rows & Vice Versa
Group Ungroup Columns and Rows
Remove Duplicates
Splitting Data in a Cell
Converting Numbers into Words
Finding Number of Characters in a Cell
Using LEFT, RIGHT, and MID Functions
Removing Extra Spaces Inside a Cell
IV. Data Visualization
Working with Charts
Inserting Graphs Inside a Cell
Use of Slicer
Interactive Dashboard using Hyperlink
Pivot Tables
V. Data Organization and Reference
Items in Group Cells (Home Tab)
Items in Group Styles (Home Tab)
Freeze Rows & Columns
Relative, Absolute, and Mixed References
How to use VLOOKUP
How to use HLOOKUP
Using ISNA with VLOOKUP
Trace Precedents
Trace Dependents
Monitoring Cells with Watch Window
VI. Advanced Excel Functions
IF function
Eliminating Blank Rows
Adding Current Date and Time
Auto Time Using VBA
Locking Certain Cells in a Worksheet
Protecting a Workbook
Password Protect Excel File
Calculating Loan Installments
Using Scenario Manager for What-If Analysis
Implementing Goal Seek for Data Optimization
Using Match Formula
Basic Macro
VII. Data Integration and Collaboration
Import Data Using Queries
How to use Smart Lookup
How to use Translate
How to use Comments
Finding Age
Finding Hours Worked
Workbook Statistics
Who this course is for:
Excel Skill Development

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Machma Virtual College of Skill Development

Instructor's Courses

Our company is a distinguished online educational institute, dedicated to providing top-tier virtual learning experiences. Specializing in a wide array of skill development programs to the diverse needs of professionals worldwide. Our curriculum is meticulously crafted to blend theoretical knowledge with practical application, ensuring that students not only learn but also excel in their chosen fields. By fostering an environment of continuous learning and innovation, we are committed to empowering individuals to navigate the ever-evolving professional landscape successfully. Our mission is to be the stepping stone for ambitious learners, transforming them into tomorrow's industry leaders through quality education and skill enhancement.

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.