Microsoft excel from beginner to expert

Microsoft excel from beginner to expert

Microsoft excel from beginner to expert

Microsoft Excel Tutorial

Language: english

Note: 4.6/5 (19 notes) 2,796 students

Instructor(s): Dr. Rasheed

Last update: 2022-05-18

What you’ll learn

  • 1. Opening Microsoft excel
  • 4. Customizing the ribbons
  • 4. Customizing the ribbons
  • 4. Customizing the ribbons
  • Status Bar in Excel
  • Cell Formatting
  • Sorting in Excel
  • Transpose data in Excel
  • Adjust Cell Sizes
  • Format painter tool
  • Free Panes in Excel
  • Trim data
  • Basic Formula in Excel
  • Calculate Mean, Median and Mode
  • 3D formulas in Excel
  • Show Formulas in Excel
  • Cells fill series
  • Creating Tables
  • Quick Analysis
  • Plotting Charts
  • Adding Second y-axis
  • Forecast function
  • Plotting Pie Charts
  • Sparklines Charts Plotting
  • Formatting Chart Axis
  • Hiding Excel Data
  • Pivot Tables
  • Plotting Pivot Charts
  • Find and Replace
  • Inserting Hyperlinks
  • Data Validation
  • Dynamic Maps in Excel
  • Convert PDF to Excel
  • Header and Footer
  • How to Separte Names
  • 20 Shortcut Keys
  • Camera Tool
  • Change background
  • Convert Excel to PDF
  • Copy Excel Data to Word
  • Adding Borders
  • Break Password
  • Creating Drop down list
  • Excel Document Printing
  • Creating organizational Chart
  • Protecting Excel Sheet
  • Taking Screenshots in Excel
  • Excel Online for FREE
  • 50 Tips and Tricks (Part 1 to 10)

 

Requirements

  • Microsoft office 365 subscription
  • Willingness to learn
  • Microsoft office 2021

 

Description

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. Shor 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.

 

Who this course is for

  • Beginner and intermediate in using MS office

 

Course content

  • Introduction
    • Introduction
    • Opening Microsoft Excel
    • Overview of the Excel Platform
    • Create Excel Templates
    • Customizing the Ribbons
    • Status Bar in Excel
    • Formatting Cells
    • Data Sorting in Excel
    • Data Transpose
    • Adjusting Cell Sizes
    • The Format Painter Tool
    • Freeze Panes
    • Data Trimming in Excel
    • Basic Formular in Excel
    • Mean, Median and Mode Calculation
    • 3D Formulars in Excel
    • How to Show Formulars in Excel
    • Cell Fill Series
    • How to Create and Manage Tables in Excel
    • Quick Analysis
    • Plotting Charts
    • Adding Second Y- Axis
    • Forecast Function
    • Plotting Pie Charts
    • Formatting Chart Axis
    • Plotting Sparkline Charts
    • Hiding Data in Excel
    • Pivot Tables
    • Plotting Pivot Charts
    • Find and Replace
    • Inserting Hyperlinks
    • Data Validation
    • Dynamic Maps in Excel
    • Convert PDF to Excel
    • Inserting Header and Footer in Excel
    • Separating Names in Excel
    • 20 Shortcut keys in Excel
    • The Camera Tool in Excel
    • Changing Background in Excel
    • Convert Excel to PDF
    • Copy Excel Data to Word
    • Adding Borders in Excel
    • Breaking Password in Excel
    • Creating Drop Down List
    • Excel Document Printing
    • Protect Excel Sheet
    • Taking Screen Shot in Excel
    • Creating Organizational Chart in Excel
    • Microsoft Excel Online For FREE
    • Tips and Tricks Part 1
    • Tips and Tricks Part 2
    • Tips and Tricks Part 3
    • Tips and Tricks Part 4
    • Tips and Tricks Part 5
    • Tips and Tricks Part 6
    • Tips and Tricks Part 7
    • Tips and Tricks Part 8
    • Tips and Tricks Part 9
    • Tips and Tricks Part 10

 

Time remaining or 332 enrolls left

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate