Home » Two Weeks Online Course in Business Excel – Advanced + Leveraging LinkedIn for Networking – July 19, 2021

Two Weeks Online Course in Business Excel – Advanced + Leveraging LinkedIn for Networking – July 19, 2021

Business Excel – Advanced + Leveraging LinkedIn for Networking
Course Contents (20 Hours)

Data Calculation and Management (Excel Basics) (3 Hours)                                    
Referencing – Absolute, Relative, Mixed, Cell Formatting – Numbers, Text, Currency etc., Basic Formulas – Statistical, Text, Date, 30 + 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 Stat, Forecasting, Regression, Advanced Filter, Subtotal, Data Validation

Advanced Analysis (6 Hours)                                                                                             
What IF Analysis – Goal Seek, Scenario Manager, Data Tables, Simple Macros, Mail Merge, Tables, Pivot Tables and Charts, Advanced Analysis and Building Classic Dashboard

 Bonus (2 Hours) – Leveraging LinkedIn for Networking
– 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
Note: Microsoft Excel 2013 or later will be required to learn this course

  • Timings: Course Starting on July 19, 2021 – Monday (Tentative – depending on Registrations).
  • Monday to Friday 7 to 9 PM – 2 Hours per day | 10 Days
  • E Certificate (2 Nos.)
  • Participants need to carry a laptop with MS Excel 2013 or later Installed.
  • 20 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. 1500 
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
                     Mobile: 9865071197

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


Back to top