Certification Course on Microsoft Excel & Personality Development

Last updated: Thursday August 12, 2021

4.9 by 47 Users | 90 Students Enrolled | Languages: Hindi, English

1099 8999

Hurry up, few days left at this price!

Course Key Features

  • Master Microsoft Excel from Beginner to Advanced
  • Learn the most common Excel functions used in the Office
  • Wow your boss by unlocking dynamic formulas with IF, XLOOKUP, VLOOKUP, INDEX, MATCH functions and many more
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Master unique tips, tools and case studies that you won't find in ANY other course, guaranteed
  • How to Import Data from Web, Tally ODBC Server
  • Improve your overall personality
  • Learn all about Personality Development
  • How to use body language to appear confident
  • How to make use of correct gestures and postures for making communication effective
  • Importance of the First impression
  • How to groom well

Course Description

Certification Course on Microsoft Excel & Personality Development


In our continuous endeavor to empower more and more finance professionals, this Certification Course on Microsoft Excel & Personality Development has been designed for you. Detailed 9 Days course has been designed where daily more than 2 hrs sessions have been organized. This Course contains Videos along with study material, Files. Live training on Personality Development will be given.

How I will get the course:


This is an online Certification Course on Microsoft Excel & Personality Development so there will not be any physical delivery of the lectures. After the purchase of the Certification Course on Microsoft Excel & Personality Development, you can see the Certification Course on Microsoft Excel & Personality Development under my account option under Dashboard. All the videos, study materials, PDF files, PPT’s, Personality Development & Excel files will be uploaded there for quick access of participants. This Certification Course on Microsoft Excel & Personality Development is valid for 60 Days.

Who is Eligible to Join this Course:


There is no bound on the eligibility from our side for the Certification Course on Microsoft Excel & Personality Development. Any person who wants to learn and master Microsoft Excel & Personality Development can join this course. However, it will be more beneficial for the below-mentioned persons:

⭐Commerce Graduates/CA/CS/CMA/Law students

⭐Tax professionals whether in JOB or Practice

⭐Qualified CA/CS/CMA/LLB

⭐Semi-qualified CA/CS/CMA working in CA Firms or in Industry

⭐Any other person not covered above can join the course if interested.

Certification Course on Microsoft Excel & Personality Development Duration:


The course duration is 9 Days and around 18+ hours.

Certificate:


A Certificate of Participation from Studycafe will be provided on completion of the Certification Course on Microsoft Excel & Personality Development.

Views Limitation:


This is a Completely online course, no bar on the number of views. During 60 days you can access this Certification Course on Microsoft Excel & Personality Development from anywhere at any time with unlimited views.

Course Content

Day-1: Data Cleansing & Date related Calculation Functions :

2 Hrs

Alt Function, Excel Smart Shortcuts, Edit Tool Bar, Randomdata, Smart Copy Paste, Smart Paste special, Transpose, now, date function, Format Cell, Concatenate, Trim & Clean, Proper, Upper, Lower, Left, Right, Mid & Len, Filter, Advance Filter, Format Painter.

Day-2: Advanced Features in Excel :

2 Hrs

Concatenate & Text Join, Giving password to excel and back up, Advance Find & Replace, Smart Sorting, Skip Blank, TDS Working Check list, GST Late Fees Calculator, Import 26 AS data and converting in to excel

Day-3: Advanced Excel Functions :

2 Hrs

Text to Columns, Flash Fill, Remove Duplicate, Data Validation, Consolidation, Conditional Formatting, if functions, Goto Special, Macro of Spell Number, etc.

Day-4: Advanced Excel Functions :

2 Hrs

Calculate Drs Ageing, Sumif, Sumifs, Advance Subtotal, Iferror, Match Function, Vlookup, IF Error+Vlook up, IFError+Vlookup, Hlookup, Xlookup, How to Record Macro, Relative Size factor Theory (RSF) in Excel to identify red flags or fraudulent transactions in audit,

Day-5: Advanced Excel Functions :

2 Hrs

Table, Vlookup, Hlookup, X Lookup Funcation, How to Create Pivot Table, USe of Pivot Table Pivot Table, Advance Pivot Table Features, Pivot Charts, Sparkline Chart,

Day-6: Advanced Excel Functions :

2 Hrs

Preperation of Balance Sheet from trial, CFO or Management Dashboard, Extract data in Excel from NET, Excel worksheet to corporate (or Tally) database & extract any data that you want, Connect your Excel worksheet to live data on the Internet to track (for e.g.) current value of investments, Reconcillation of GSTR2A with GSTR3B ,

Day-7: Body Language & Confidence Building

2 Hrs

- The change starts from within

- Overcoming nervousness

- Getting over Fear

Day-8: The Transformation from Inside to Outside and overcoming Fear

2 Hrs

- The change starts from within

- Overcoming nervousness

- Getting over Fear

Day-9: The Power of Dressing

2 Hrs

- How to groom well

- Importance of the First impression

Reviews of Course Participants

Our Alumni at Leading Companies

FAQ

Who can join this Course?

⭐ Commerce Graduates/CA/CS/CMA/Law students ⭐ Tax professionals whether in JOB or Practice ⭐ Qualified CA/CS/CMA/LLB ⭐ Semi-qualified CA/CS/CMA working in CA Firms or in Industry ⭐ Any other person not covered above can join course if interested.

What will be Language?

It will be in Mix of English and Hindi Language.

What is the Duration of the Course?

Course Duration will be of more than 6 Hrs.

Whether Course Material will be Provided?

Yes, Course Material will be Provided.

Whether Course Recording will be Provided?

Yes Recording will be Provided for 60 Days.

How Can we Join ths Course?

Please register yourself and pay the fees. After paying fees you will get link to join session on your email.

Can we join from Mobile?

yes

Featured In

Terms and Conditions

  • Recording will be Valid for 60 Days Only.

Requirements

  • Required internet connection. Lectures can be viewed on Mobile or Laptop

This course includes:

  • Hindi, English
  • 6+ Hours of Video Content
  • Recording is Available for 60 Days
  • Studycafe Certificate of Participation
  • Access on mobile or Computer/Laptop
  • Downloadable Material
Certificate

Certificate to be provided to all the participants.

In case of any Query Please Call us or Whats App

About Authors

Deepak Gupta

CA: Business

CA Deepak Gupta,is Co-founder of Studycafe. He is Microsoft Office Specialist and Trainer of Microsoft Excel, PowerPoint, Power BI, Google Sheet, Google Forms and Other Tools. CA Deepak Gupta, is Having more than 13 plus years of industry experience, and he has Worked with best brands Like, Hero, Wipro, Ericsson before Starting Studycafe. He has Trained more than 20000 Persons in Microsoft Excel, PowerPoint, Power BI, Google Sheet, Google Forms and Other Tools.

Feedback