Get advance Excel Training at I4BEST, and secure your Job

MS Excel is the most common software used for spreadsheet, the Workshop on MS Excel has been designed to provide hands-on experience. The workshop aims to impart the basic and advanced techniques of Excel to acquaint users with the latest technology as well as lessen their work load. We, at Career Skills Academy, believe in practical oriented training methodology, and thus we conduct a hands on workshop to enrich the existing knowledge in professionals and help them explore unimaginable possibilities.

Who Should Attend This Workshop? Why?

Workshop on MS Excel is a common platform for all to learn the nitty-grittys of spreadsheet application. It is for Executives, who are familiar with the basic functionality of spreadsheets, yet are unaware of its advanced techniques. It is for students of professional courses, who use spreadsheet at on elementary level and will have to graduate to advanced features during their academic and career pursuits.

Ordinary laymen, who use spreadsheets in their day to day lives, can also take part in this workshop to learn more about the application and thus expand the horizons of their knowledge and possibilities. Workshop on Advanced Spreadsheet is an endeavor by Career Skills Academy to spread awareness about the application and thus help the users to utilize it optimally.

Course Content
This workshop is specifically designed for professionals and graduate students who need to learn about the advanced ways of using spreadsheets for complex issues. This knowledge packed workshop starts with an introduction to MS Excel. Tentative list of topics which are covered in the seminar.

Quick Overview

• Essential Shortcuts

• Absolute & Relative Referencing ($)

• ROUND (), SUMPRODUCT (), etc.

Data Analytics

• Using SUBTOTAL() with Filtered data

• SUMIF, COUNTIF

Pivot Tables

• Computations %, Sum, Max, Min, Average, Count, etc.

• Generate Multiple Reports

Data Lookup

• VLOOKUP() & HLOOKUP()

• VLOOKUP() with MATCH(), INDEX() & MATCH()

Excel Modelling

• INDIRECT() with Cell Range Naming

Logical Statements

• IF(), Nested IFs(), AND(), OR(), IFERROR()

• ISNUMBER(), ISTEXT(), ISBLANK()

Working with Dates


Data Cleaning

• LEFT(), RIGHT(), MID()

• LEN(),TRIM(), SUBSTITUTE(), VALUE()

• UPPER(), LOWER(), PROPER()

• Using “&” for concatenating or joining strings / cell values

• Find & Replace (Using wildcard character – Asterisk *)

• Go To (Special) with Ctrl+Enter trick

• Text to Columns with advanced tricks

• Remove Duplicates

MIS Reporting

• Data Consolidation

• Automatic Row Wise Sub-Total

• Conditional Formatting – Blanks, Duplicates, Cell Values, Formula based, etc)

• File Password & Cell Protection


Dashboard Techniques

• Data Validation (List)

• Cell Range Naming, Grouping


What IF Analysis

• Data Tables

Macros: Overview

• Concept

• Macros Recorder, Record & Run


Contact : 9038970007


Comments

Post a Comment

Popular posts from this blog

The Best HR Career Paths – for Freshers/Experience Who want to Make Career in HR

Image
With a one-person HR team, administrative duties often take priority over strategic initiatives, like employee experience, workforce planning, or company culture. However, as companies grow, so too do opportunities for HR professionals to take on new responsibilities and contribute in meaningful ways. Specialized HR careers ensure that every stage of the employee lifecycle has a clear owner and a process—so nothing gets left in a blind spot. Whatever HR job title you land on, you have a wide range of career paths to choose from. Where do you start? We’ve outlined five tracks to help you find your ideal future in HR. 1. The HR Generalist For the jack-of-all-trades and multi-tasker extraordinaire, HR Generalist roles may be the fit for you. The HR Generalist has a hand in all pieces of the HR machine, including benefits, onboarding,  performance management , talent acquisition, and compliance. The HR Generalist plays a vital role in ensuring that everything runs without a
Read more

Career prospects and job opportunities in HR from i4best HR Training Institute

Image
It’s good to see you searching for career options that I4BEST in HR Practical Trianing offer you. Absolutely, Practical Training from I4BEST in HR opens up a career ladder for you, because it is well-known fact that HR plays a vital role in organizational growth. Often, every I4BEST HR pass out graduate looks for a return on investment. Moreover, jobs in HR literally give you the power of controlling hundreds of employees (sometimes even thousands of employees). Exciting, isn’t it? So, Practical Training in HR from I4BEST opens the doors of your dream job. But wait, it is worth asking some questions to yourself before picking up your discipline. Does it give a good fit for you? What is the future scope of HR specialization What are the job opportunities and skills required to perform those jobs? There are a huge number of jobs in India, and off-course there is a great opportunity to work in abroad for HR professionals. Let’s look into the same, HR Generalist: Fi
Read more

TDS Deduction

TDS Deduction Every employer who is paying salary to employees has to deduct TDS under section 192 of the Income tax Act, 1961, if the salary is more than maximum amount exempt from tax. The employers also need to generate Form 24Q and Form 16 in time. Some of the salary components that impact TDS deduction are: HRA, Special allowance, Leave travel allowance, Children education allowance, Medical allowance, Investments. Statutory Compliances For ESI Fund And PF Deduction ESI  fund, maintained by ESIC is applicable to employees’ earning Rs 15,000 or less per month to provide the cash and medical benefits to them and their families. PF is a compulsory contributory fund for the future of employees after their retirement or for their dependents in case of their early death. Professional Taxes Professional tax or employment tax is a state-based tax. It is one of the statutory deductions from the gross income before computing the tax. Gratuity Gratuity is the amount given t
Read more