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.

Opening Microsoft excel
Creating excel templates
Overview of the excel platform
Customizing the ribbons
Sorting in excel
Transpose data
Adjust cell sizes
Format painter tool
Freeze panes
Trim data
Basic formular in excel
Mean, median, mode
3D Formulars in excel
Shor formulars in excel
Cells fill series
Creating tables
Quick analysis
Plotting charts
Adding second y-axis
Forecast function in excel
Plotting pie charts
Plotting sparklines
Format chart axis
Hiding data in excel
Pivot tables
Plotting pivot charts
Find and replace
Inserting hyperlinks
Data validation
Dynamic maps in excel
Convert PDF to excel
Header and Footer
Separate names
20 shortcut keys
Camera tool
Change backround
Convert excel to pdf
Copy excel data to word
Adding borders
Break passwo
Creting Drop down list
Excel document printing
Creating organizational charts
Protecting excel sheet
Taking screenshot
Excel free online
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

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