Advanced Excel training in Marathahalli

1
advanced excel

• Ria Academy

www.riaacademy.in
2
What functions are in Excel?

• Excel includes many common functions that can be
  used to quickly find the sum, average, count,
  maximum value, and minimum value for a range of
  cells. In order to use functions correctly,
  you'll need to understand the different parts of
  a function and how to create arguments to
  calculate values and cell references.

www.riaacademy.in
3
What is the difference between Excel and Advanced
Excel?

• Excel It performs basic functions compared to
  advanced excel. Excel can use complex formula but
  it is not as complex as advanced excel. Some of
  the formulas include AVERAGE, SUMIF, COUNTIF, and
  so on.

www.riaacademy.in
4
Advanced Excel Skills

• Advanced Excel SkillsNowadays, many jobs require
  advanced Excel skills. Naturally, you are
  interested to know what are these Advanced Excel
  Skills? ...Data, Power Query, Tables
  Formatting. ...Conditional Formatting.
  ...Advanced Charting. ...Pivot Tables Pivot
  Reporting. ...VBA Macros. ...Using Excel
  Productively. ...Data Tables, Simulations Solve

www.riaacademy.in
5
Thank you

• - Ria Academy

www.riaacademy.in