Microsoft Excel Online Course for Professionals

  • Rs. 1,200.00
    Unit price per 
  • Save Rs. 3,800
Shipping calculated at checkout.


MICROSOFT EXCEL COURSE - FOR FINANCE PROFESSIONALS

2000+ Students have enrolled till date

Demo Class: Click Me to Watch

Course Details: 

Learn everything about Microsoft Excel. Its an online course on Microsoft Excel which gives you training on how to use MS Excel in day to day office life. You will get Microsoft Excel Tutorials which are pre recorded and you will also get Excel Templates for free.

WHAT WILL YOU LEARN DURING COURSE?

Section 1 - Make a start with Microsoft Excel Training

  • A First Look at Microsoft Excel online course

  • Excel Rows & Columns

  • Enter Text & Number in a cell

  • How to Edit Text in a cell

  • How to Center Text & Numbers

  • Font formatting in Excel

  • How to Change the Color of cell

  • Currency Symbols in Excel

  • How to Wrap Text & Merge Cells

Section 2 - A more complex Microsoft Excel Spreadsheet

  • How to use Autofill

  • Entering simple Addition Formula

  • How to use Paste Special

  • Various Calculations used in Corporate level

Section 3 - Microsoft Excel Charts

  • How to sort data in Excel

  • Create Excel Charts, Charts layouts, Titles, series titles, Chart Layout Panel,

  • Create a Pie Chart in Excel, add labels to the pie chart, Format the pie chart segment.

  • Predict a future with a trend line chart

  • Sparkling charts

Section 4 - Functions / Formulas in Excel

  • The Average, Average if Function

  • The Students Averages Project

  • Time & Date Function in Excel

  • Financial Functions

  • SumIf, CountIf, Conditional Formatting in Excel

Section 5 - Processing Data in Excel

  • Data Tables in Excel

  • Absolute Cell References

  • Named Ranges in Excel

  • Reference other worksheets

  • Create a Business Invoice

  • Pivot Tables

  • Index, Match, Offset ane Choose Version
  • Create Loan Schedule
  • Create a Depreciation Schedule

Section 6 - Advanced Excel

  • How to create an Excel Template

  • How to create Pivot Tables
  • Playing with Pivot Table Formatting & Slicer
  • Dropdown list in Excel

  • Add your own Error Messages

  • Array Formulas

  • Frequency Distribution

  • Hyperlinks in Excel

  • Object linking & Embedding

  • Insert Drawing Objects

Section - 7 Basic to Advanced Charting

  • Insert Bar Chart
  • Insert Column Chart
  • Insert Birdge Chart
  • Insert Scattered Chart
  • Insert Area Chart
  • Insert Pie Chart
  • Insert Bubble Chart
  • Advance Level Formatting 

IMPORTANT DETAILS:

1) Classes shall be available on Google Drive.

2) Practical Classes, NO THEORY.

3) No Exam, only inbuilt assignments to be completed

CERTIFICATE: After the course completion and online test.

NO OF LECTURES - 45

DURATION - 10 Hours

CLASSES VALIDITY - 30 Days

Customer Reviews

Based on 1 review Write a review