Business Excel

#_LOCATIONMAP

Date/Time
Date(s) - 01/08/2020 - 20/08/2020
4:30 am - 5:45 am

Location
#_LOCATIONLINK

Categories No Categories


S. No Topics Hours
1 Excel Basics

•       Menus & Worksheets | Keyboard Shortcuts
•       Working with Cells and Ranges: Formatting Cells, Name Manager
•       Absolute, Relative & Mixed References
•       Setting up a database | Data Formatting & Cleaning
•       Conditional Formatting | Sparkline Graphics (In Cell Charts)

3
2 Excel Functions & Formulas

VLOOKUP, HLOOKUP, SUMIF, SUMIFS, SUMPRODUCT, COUNTIF, COUNTIFS, IF, IFERROR, OR, AND, INDEX, MATCH, CONCATENATE, Array Formulas, Random Number Generation.

Tables and Structured References, Formulas for Financial Applications

6
3 Excel Options  

Auto Filter – Multiple and Advanced Filter, Data Validation
Sorting Data – Multiple Sorting – Generating Subtotals & Formatting
What If Analysis – Data Table – Scenario Manager – Goal Seek & Solver

2
4 Charts

Creating, Formatting and Modifying Chart – Building Primary and secondary Axis chart – Working with various Charts. Setting up page – previewing and Printing.

2
5 VBA and Macros

Introduction to Macros – Recording Macros – Running Macros using menu command – Assigning a Keyboard shortcut – Assigning macro to a toolbar, menu or button

1
6 Pivot Tables for Data Analysis

Create Database for Pivot, Analysing Data with Pivot Tables, Data Crunching, Report generation, Slicers, Creating Automated Reports, and Interactive Excel Dashboards & GETPIVOTDATA.

Introduction to Power Query, Power Pivot & Power BI

6
Total Hours 20

Details:

  • 20 Hours of Live Training – 100% Practical Sessions | Tentative Dates: August 2020
  • Webcast: Teams or Google Meet: Course Fees: Rs. 826 /- (Incl GST)

Participants Profile: Basic Excel Knowledge (50 Max)

Sample YouTube Videos: https://youtu.be/U4LeA77gmSs

Trainer Profile: Dr.P. Kamalakannan, Assistant Professor, Sona School of Management, Salem, Tamilnadu, India.

Visual CV: http://bit.ly/kamaltableau | LinkedIn: http://www.linkedin.com/in/kamalpk

Blog: https://drkamalpk.wordpress.com/

Registration Link: https://bit.ly/ssomexcel

Leave a Reply

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