Excel for sales reporting
Please fill following information
Expert use of Excel will save a lot of time. That time adds up to extra time for your more enjoyable activities. In addition, your colleagues and supervisors will notify that you are efficient and can produce professional looking reports that impresses. This course will take you straight into a simple set of efficiency rules that will lead you towards Excel excellence
OUTLINE:
- Data ANALYSIS WITH PIVOT TABLE
- Creating Pivot Table
- Different types of calculations with “Value Field Setting”
- Pivot Charting
- Inserting Slicers
- FORMULA & FUNCTIONS SESSION:
- LOOKUP FUNCTION :
- VLOOKUP
- DATE & TIME FUNCTIONS :
- NOW, TODAY
- DAY, MONTH, YEAR
- TEXT, DATE
- MATHEMATICAL FUNCTIONS :
- ROUND, ROUNDUP, ROUNDDOWN
- SUM, AVERAGE, COUNT, COUNTA
- SUBTOTAL
- MAX, MIN
- Finding & Managing Duplicates
- Protecting Sheets & Workbooks
- GRAPHS & CHARTS
- Line graph
- Bar graph
- Pie chart
- Combo graph
- FORMULA & FUNCTIONS SESSION
- MATHEMATICAL FUNCTIONS :
- IF, IFS
- SUMIF, SUMIFS
- COUNTIF, COUNTIFS
- TEXT FUNCTIONS :
- CONCATENATE and & (AMPERSAND)
- LEFT, RIGHT, MID
- PROPER, UPPER, LOWER
- LEN, REPT, TRIM
- Conditional Formatting
- Highlight Cell Rules
- Top/Bottom Rules
- Data Bars/ Color Scales/ Icon Set
- Data Validation & Drop down list
Course Information
- Reg. Ends 09 October, 2020
- Start Date 10 October, 2020
- End Date 11 October, 2020
- Class Schedule 7:30PM - 9:30PM
- Total Hours 4 Hours
- Venue Title Online Live Training
- Venue Address www.sudoksho.com/class-room
