Bustudymate Excel Training

(10 customer reviews)

 149.00

Category:

Description

Course Content

1) Quick tour of excel
a,Excel work book worksheet, cell structure
b,Ribbon & Quick access toolbar
c,Customizing the excel interface

2) Data input
Data entry & Editing excel data
Basic excel formula
Correctly inputs dates & time stamps
Use excel auto fill to do your work
Excel flash fill for major time saving
Custom list with auto fill
Finding excel formulas & input cells
Excel data validation to reduce time

3) Worksheet, Navigation, Copying & Protecting
Useful excel shortcuts for navigation
Copying, moving, & hiding worksheets
Freeze panes & split screen for long excel reports
Copying & pasting data
Protecting Excel worksheets & specific ranges

4) Important Excel Function
COUNT, COUNTA, COUNT BLANK
COUNTIFS based on a condition
SUM & AVERAGE Function
SUMIFS & AVERAGEIFS
MAX & MIN ( MAXIFS &MINIFS)
ROUNDING VALUES
IF excel function – conditional functions
VLOOKUP Function
ABSOLUTE & RELATIVE CELL REFERENCING

5) Data cleaning & Management
    Sort data
Filter data
Remove duplicates

6) Formatting including CONDITIONAL & NUMBER FORMATTING in excel

7) Charts
     Basic charts
Comparison excel charts
Combination charts
Pareto & Histogram Excel charts
Sunburst, Pie & Doughnut excel charts

ADVANCED EXCEL

1) Excel tips
    a) Excel keyboard shortcuts
b) Simpler tasks
c) Navigate larger files
d) Import Text & Data
e) Audit & Debug formula
f) Pivot table

2) Excel Formula
    SUMIFS, COUNTIFS, AVERAGEIFS to account for exceptions
IF functions
IFERROR
VLOOKUP & HLOOKUP
INDEX & MATCH
OFFSET
FREQUENCY, SMALL & LARGE
SUMPRODUCT
Advanced text functions
CIRCULAR REFERENCES

3) Finance functions
   Time value of money
Single series cashflow : present value & future value
Compounding
Capital budgeting – Net present value & Internal rate of return
Goal seek
Data table
Payment functions

FUNDAMENTAL ANALYSIS

Here we will understand the Income statement, Balance sheet & Cash flow statement by doing a exercise on BASIC FINANCIAL STATEMENT

10 reviews for Bustudymate Excel Training

  1. Bhargavi

    As I don’t attend first class I don’t know anything about it

    • Bustudymate

      The First Class is just an introduction to Class. U can enroll for this and attend the excel training

  2. Rakshitha CM

    Classes are understandable

  3. Rakshitha CM

    Understandable

  4. nagma khanum

    good teaching

  5. Aishwarya v

    As first class attending the class is I don’t know anything abt it …

    • Bustudymate

      No prior knowledge is necessary. This course starts with the basics before diving into more advanced tips and strategies.

  6. Varun v sagar

    Good

  7. Ayesha shariff

    I have attended the demo class through which I was able to understand better and the sir was very supportive he had cleared by doubts. I am very thankful to have u sir thank you once again

  8. Sangeetha.c

    Good teaching

  9. Arshiya

    Bustudymate is really helping students by providing excel course for affordable price .. just for Rs 99 it’s worth doing excel from here .

    • Bustudymate

      Thank you 🙂

  10. Naveen s

    Usefull and understandable

Add a review

Your email address will not be published. Required fields are marked *

Shopping Cart
There are no products in the cart!
Subtotal
 0.00
Total
 0.00
Continue Shopping
0