Microsoft excel from beginner to expert


Microsoft Excel Tutorial

What you will 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)

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.


Subscribe to latest coupons on our Telegram channel.

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.

English
language

Content

Introduction

Introduction
Opening Microsoft Excel
Create Excel Templates
Overview of the Excel Platform
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

Enroll for Free

Share This Course on:
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock