MSME Logo

Advance Excel with Data Analysis

Date : 22nd, 23rd, 29th & 30th May 2021
Time : 2.00 pm To 6.00 pm
 
Click to Register
 

Hi,
This is Yamini (9500034831) MSME Training Coordinator for "Advance Excel with Data Analysis". We are starting on 22nd 23rd, 29th, 30th May 2021, time 2.00pm to 6.00 pm.

Learning this course online with MSME (Govt of India) Certificate at this Govt subsidized Fee of ₹ 4,720/- including GST per candidate, assures multiple Business opportunities, Career Progression and Management.

Program Feature: In this Course, you will learn many useful features in MS Excel

  • Manage workbook options
  • TAT saving Techniques
  • Data Mining features
  • Pivot Tables & Pivot Reporting
  • Advanced Analytical Tools
  • Advanced Database Functions
  • Introduction to Macros.
Advance-Excel-with-Data-Analysis
  1. Learn how to minimize as much manual labor as possible in data analysis
  2. Learn to use the most overlooked Excel formulas that will make your life easier
  3. Learn powerful functions built into Excel that streamline your analysis
  4. Learn how to build macros to automate common tasks

Course Sections:

  • The most useful and overlooked Excel shortcuts to make life easier
  • Different ways to make your Excel worksheet into a model instead of just a flat analysis? Learn different "switches alternatives" (if, choose, offset)
  • Data validation techniques to dummy proof your model
  • Basic regression analysis using least squares approach
  • One-dimension and two-dimensional sensitivity analyses using data tables
  • Utilizing the vlookup function to its fullest to streamline tedious lookup jobs
  • Pivot Tables: Everybody's heard of them, but who knows how to use them?
  • Learn how to summarize and dissect large amounts of data for analysis
  • Even better - add built-in and custom calculated fields to really use pivot tables to the max
  • Using the sumif formula and sum+if array functions to simplify complex conditional calculations
  • Automate alternate row shading in a table of data using complex conditional formatting
  • Using the transpose array function

Adding some spice to your Excel analysis and models using drop-boxes

Registered candidates should fill in MSME Application form and with passport photo, Aadhar card copy by email to msmetdcchennai1@gmail.com or Whatsapp to 9790922344

Payment can be made directly to MSME online to www.cftichennai.in or do NEFT to MSME Account Details:
Name: DIRECTOR CFTI,
Account No: 10299691069,
IFSC Code: SBIN0000956,
You may pay through Gpay no.9790922344.

Interested in Register Contact Training Coordinator Yamini +91 9840098230

Thanks & Regards,

Yamini

MSME Training Coordinator

+91 9840098230