Home » Three Weeks Online Certificate Course in Data Analysis using Business Excel + Leveraging LinkedIn for Networking – July 26, 2021

Three Weeks Online Certificate Course in Data Analysis using Business Excel + Leveraging LinkedIn for Networking – July 26, 2021

Course Contents (Three Weeks – 30 Hours)

Data Calculation and Management (Excel Basics) (3 Hours)                                    
Referencing – Absolute, Relative, Mixed, Cell Formatting – Numbers, Text, Currency etc., Basic Formulas – Statistical, Text, Date, 20 + Shortcuts and Tips, Paste Special 10+ Applications & Clipboard, Sort and Filter

Quick Calculation and Analysis (2 Hours)
Flash Fill – Patterns, Freeze Views, Text to Columns, Conditional Formatting for Business Reporting, Quick Analysis,

Data Analysis and Presentation (1 Hour)
Pivot Tables – Instant Reports, Simple Dashboard, New Data Types & AI Features of Excel

Formulas and Functions (4 Hours)
Statistical Functions, Text Functions, Logical Functions, Finance Functions, Lookup Functions – VLOOKUP, HLOOKUP & XLOOKUP                                                                                

Data Manipulation (2 Hours)
Flash Fill Extended, Statistics in Excel – Descriptive Statistics, Forecasting, Regression, Advanced Filter, Subtotal, Data Validation

Advanced Analysis (5 Hours)                                                                                             
What IF Analysis – Goal Seek, Scenario Manager, Data Tables, Simple Macros, Mail Merge, Tables

Financial Analysis & Management (7 Hours)
 Annual Report Analysis (Telecom Sector Data), Data Extraction from Websites, Formatting Basics
 Reporting using Management Accounting
Capital Budgeting Cases – Payback, ARR, NPV, IRR, PI
 Sensitivity Analysis in Capital Budgeting

Marketing Reports / Sales Dashboard (4 Hours)
Pivot Tables and Charts, Sparkline Graphics, Advanced Analysis and Building a Classic Dashboard

Leveraging LinkedIn for Networking (2 Hours)
– LinkedIn Facts and Mechanics
– Building an All-star LinkedIn profile from scratch
– Optimizing for search appearance
– Attracting and following connections
– Ways to create an engaging content – Post, Event, Article
– Building skills and recommendations
– Networking through groups, companies and interests
– Creating Pages, Companies vs Education, Job posting
– Creating an effective resume/cv through LinkedIn
– Job search, Internship and Project opportunities
– Benefits of LinkedIn School page for Educational Institutions, tracking alumni
– LinkedIn Interview prep and Job ready reckoner
– Skill tests and LinkedIn learning free courses
– LinkedIn premium benefits
– Downloading your data for LinkedIn Analytics

Instructions:

  • Timings: Course Starting on July 26, 2021.
  • Monday to Friday 7 to 9 PM – 2 Hours per day | 15 Days (Tentative)
  • E Certificate (2 Nos.)
  • Participants need to carry a laptop with MS Excel 2013 or later Installed.
  • 30 Hours (Approximately) of Online Training – 100% Practical Sessions
  • Business Use cases
  • Extended Support after the course
  • Step by Step Manual for easy Solving
  • Cheat sheets for Instant access
  • Reference Books
  • Practice Exercises
  • Recorded Lectures

Fees: Rs. 3500 (Group Discount for 4+ Registrations)

Course Fee to be paid Upfront before starting of the Class. No Refund allowed, Replacement Accepted.

Instructor: Dr.P. Kamalakannan – www.linkedin.com/in/kamalpk
                       Programme Director & Instructor
                       School of Business Intelligence (https://onlinepitstop.in/schoolofbi/)
                       Mobile: 9865071197

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

onlinepitstop

Back to top