Microsoft Excel Tutorial
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
- Show 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
