Advanced Excel

by PBA Institute Claim Listing

Advanced Excel Functions refers to the features and functions of Microsoft Excel, which helps the user to perform complex calculations, perform data analysis, and much more. In this article, you will learn some of the most commonly used advanced functions in Excel.

₹2500

Contact the Institutes

Fill this form

Advertisement

PBA Institute Logo

img Duration

20 Hours

Course Details

Advanced Excel Functions refers to the features and functions of Microsoft Excel, which helps the user to perform complex calculations, perform data analysis, and much more. In this article, you will learn some of the most commonly used advanced functions in Excel.

This advanced Excel training course starts with a blank spreadsheet and quickly dives into using combinations of functions and formulas to perform dynamic analysis. The main formulas & functions covered in this training course include: INDEX and MATCH.

 

Syllabus:

  • 1. EXCEL 2007 & 2010, 2013, 2016 QUICK OVERVIEW
  • Lesson 1. Difference between Excel 2003, 2007 and 2010,2013,2016.
  • Lesson 2. Use of Excel, its boundaries & features.
  • 2. BASIC FORMULA
  • Lesson 1. Formulae that Add / Subtract / Multiply / Divide.
  • Lesson 2. BODMAS / Formula Error Checking.
  • Lesson 3. The Sum Function.
  • 3. ABSOLUTE REFERENCING
  • Lesson 1. Problems with Absolute / Relative Cell Referencing.
  • Lesson 2. Creating Absolute / Mixed References.
  • 4. LOOKUP FUNCTION
  • Lesson 1. The VLOOKUP/ HLOOKUP Functions.
  • 5. PIVOTTABLES
  • Lesson 1. Creating, Formatting Simple PivotTables.
  • Lesson 2. Page Field in a PivotTable.
  • Lesson 3. Formatting a PivotTable.
  • Lesson 4. Creating / Modifying a PivotChart.
  • 6. LOGICAL FUNCTIONS
  • Lesson 1. IFs and Nested IF functions.
  • Lesson 2. Using AND / OR / NOT Functions.
  • And more.
  • Howrah Branch

    Besides Loknath baba Mandir, 54/2/4/1, Andul Rd, Howrah

Check out more MS Excel courses in India

Indira Technical Institute Logo

Microsoft Office

Microsoft Office course is offered by Indira Technical Institute. The skill level and educational attainment of the work force determines the productivity, income levels as well as the adaptability of the working class in changing environment.

by Indira Technical Institute [Claim Listing ]
Vedanta Computer Training Institute Logo

MS PowerPoint

MS PowerPoint course is offered by Vedanta Computer Training Institute. We have a team of highly experienced trainers for computer classes in Patna that are expert in the field of providing quality education in various courses of the computer.

by Vedanta Computer Training Institute [Claim Listing ]
AWT Education (Abstract Web Technologies) Logo

MS Office

MS Office course is offered by AWT Education (Abstract Web Technologies). AWT Computer Institute, is the best computer education institute in Bhubaneswar, ICI is committed to providing students with the latest technologies and expertise to prepare them for a successful career.

by AWT Education (Abstract Web Technologies) [Claim Listing ]
Bright Computer Education Logo

Microsoft Office 2013

Microsoft Office Course is offered by Bright Computer Education for all skill level. Bright Computer Education is An ISO 9001:2015 Certified and MSME Guj. Govt Registerd Institute. Bright Computer Education in Ahmedabad is one of the leading businesses in the Computer Training Institutes.

by Bright Computer Education [Claim Listing ]
Webnet Computer Institute Logo

Advance Excel

Advance Excel course is offered by Webnet Computer Institute.Webnet Computer Institute training in Nagpur offers training courses in IT software, Computer Hardware & Networking and Management with strong base of placement support, real-time trainers with working experience in MNC companies.

by Webnet Computer Institute [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy