Overview of Advance Excel

1
Overview of Advance Excel
2
What is the difference between Excel and Advanced
Excel?

• There are functions and advanced excel formula
  that can be utilized for complex calculations.
  The functions are designed for simple lookup and
  formatting of large pool of data whereas the
  advanced excel formula are implemented to get new
  information from a given particular set of data.

3
What is the most useful Excel function

• Lookup Formulas - VLOOKUP, HLOOKUP, INDEX, and
  MATCH - 5 Total Votes. The lookup functions are
  hands-down some of the most important Excel
  functions. You can't claim to be an Excel expert
  without being proficient with these.

4
Why Advanced Excel is important?

• It allows the customer to have the capability to
  utilize simple spreadsheet capacities such as
  practical tools, equations, diagrams and other
  critical tools. Advanced Excel today is the
  require of high importance and taking in the
  skills of advanced excel can lead you to stand
  out among a big crowd of people.

For Video Click Here Overview of Advance Excel
5

How can I learn Excel the fastest way?

• Enter and edit Excel data.
• Make simple pivot tables and charts.
• Create simple Excel formulas.
• Use Excel Functions IF and VLOOKUP.
• Filter and sort lists of data.
• Utilize Excel table functions to de-duplicate
  data and make totals.
• Understand how Excel is utilized in a business
  context to identify data.

6

What formulas are used in Excel?

• SUM. Formula SUM(5, 5) or SUM(A1, B1) or
  SUM(A1B5)
• COUNT. Formula COUNT(A1A10)
• COUNTA. Formula COUNTA(A1A10)
• LEN. Formula LEN(A1)
• TRIM. Formula TRIM(A1)
• RIGHT, LEFT, MID.
• VLOOKUP.
• IF Statements.

7


What jobs frequently use Excel?

• Administrative Assistant. Administrative
  assistants are liable for helping the
  organization they work for run smoothly by
  completing a collection of various tasks.
• Information Clerk.
• Accountants and Auditors.
• Cost Estimator.
• Financial Analyst.
• Sales Manager.

8
How can I get Microsoft Excel for free?

• To start using Office for free, all you have got
  to do is open your browser, go to Office.com, and
  select the app you want to use. There is online
  copies of Word, Excel, PowerPoint, and OneNote
  you can select from, as well as contacts and
  calendar apps and the OneDrive online storage.

9
Advance Excel Training in Chandigarh
CBitss Technologies

• 09988741983,0172-5031983
• counselor.cbitss_at_gmail.com

Website http//cbitss.co.in/advance-excel-train
ing-in-chandigarh.html
10
CBitss Technologies