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
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
Rakshitha CM –
Classes are understandable
Rakshitha CM –
Understandable
nagma khanum –
goooood
nagma khanum –
good teaching
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.
Varun v sagar –
Good
Lakshmi N –
I liked this
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
Sangeetha.c –
Good teaching
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 🙂
Naveen s –
Understandable
Naveen s –
Usefull and understandable
Poornima g –
Good