US $19.97

Microsoft Excel Tutorial for Beginners

——   Created by EPIC Mentorship

Learn Microsoft Excel

Share this course:

NEW
Course
58
Lessons
6h 55m
Lesson time
beginner
Skill level

More about this course

It is not about how much data you have collected, but how you process, and bring in meaning using visuals.

It all begins with using the right tool.

Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool that can help you take your data analytics to the next level.

With Microsoft excel you can understand trends, patterns, use modern formulas to perform multi-functional calculations. Its best for students, lecturers and industry professionals involved in different kinds of data management.

You can plot different charts and graphs, sparklines charts and work with different types of tables including pivot tables and pivot charts that are dynamic in nature.

  1. Opening Microsoft excel
  2. Creating excel templates
  3. Overview of the excel platform
  4. Customizing the ribbons
  5. Sorting in excel
  6. Transpose data
  7. Adjust cell sizes
  8. Format painter tool
  9. Freeze panes
  10. Trim data
  11. Basic formular in excel
  12. Mean, median, mode
  13. 3D Formulars in excel
  14. Show formulars in excel
  15. Cells fill series
  16. Creating tables
  17. Quick analysis
  18. Plotting charts
  19. Adding second y-axis
  20. Forecast function in excel
  21. Plotting pie charts
  22. Plotting sparklines
  23. Format chart axis
  24. Hiding data in excel
  25. Pivot tables
  26. Plotting pivot charts
  27. Find and replace
  28. Inserting hyperlinks
  29. Data validation
  30. Dynamic maps in excel
  31. Convert PDF to excel
  32. Header and Footer
  33. Separate names
  34. 20 shortcut keys
  35. Camera tool
  36. Change backround
  37. Convert excel to pdf
  38. Copy excel data to word
  39. Adding borders
  40. Break passwo
  41. Creting Drop down list
  42. Excel document printing
  43. Creating organizational charts
  44. Protecting excel sheet
  45. Taking screenshot
  46. Excel free online
  47. Tips and Tricks Part 1:
  48. Tips and Tricks Part 2:
  49. Tips and Tricks Part 3:
  50. Tips and Tricks Part 4
  51. Tips and Tricks Part 5
  52. Tips and Tricks Part 6
  53. Tips and Tricks Part 7
  54. Tips and Tricks Part 8
  55. Tips and Tricks Part 9
  56. Tips and Tricks Part 10

Thank you for joining this course and i look forward to interacting with you.

The course project

To test your understanding of whether you follow through the tutorial, try to get any data and perform the following operations with it:

  1. Basic formular in excel (Practice some basic calculations using formulars in the cells)
  2. Mean, median, mode (Do some basic calculations)
  3. Show formulars in excel (try it on a sheet that contains formulas)
  4. Cells fill series (Try some fill series with any formular you added in the sheet)
  5. Creating tables (Try creating a basic table within the data)
  6. Quick analysis (Attempt to understand the data using quick analysis tool)
  7. Plotting charts (Do some basic plotting)
  8. Do any of the above and report your experience. If you have any issue feel free to reach out.

58 Lessons

6 mins
Course Introduction
free preview
8 mins
Opening Microsoft Excel
free preview
12 mins
Overview Of Microsoft Excel Platform
6 mins
Customizing The Ribbons
9 mins
The Excel Status Bar
6 mins
Creating and saving Templates
7 mins
Data Sorting
4 mins
Data Transpose
4 mins
Data Transpose
6 mins
Cell Sizes
6 mins
How to use the Format Painter Tool
2 mins
How to use Freeze Panes
6 mins
How to Trim Data
9 mins
Basic Formulas in Excel
6 mins
Mean, Median, Mode and Standard Deviation
View more lessons +

About the instructor

It you!

A certified public speaker and digital content creator. The founder of EPIC Mentorship. I have a PhD in Civil Engineering and currently a Lecturer I …

Read more
This course is included in Arbington Premium
$15/month gets you access to every course. Start your 14 day trial today. ☝️

Class benefits

  • Certificate of Completion
  • 30 day satisfaction guarantee
  • 24/7 streaming access
  • Project included
  • Direct teacher access
  • 6h 55m of on-demand video
  • Have a coupon?
  • Checkout