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

Logic Computer Education Centre Logo

Ms-Office Course

Ms-Office  course is offered by Logic Computer Education Centre. Our comprehensive curriculum, offered in both classroom and online formats, equips students with essential computer skills, from basic operations to advanced IT knowledge.

by Logic Computer Education Centre [Claim Listing ]
DASVM Logo

Microsoft Visio

Visio is a drawing and diagramming program that includes a variety of pre-drawn shapes and picture elements that can be dragged and dropped onto the illustration. Users can define their own elements and place them onto the Visio palette.

by DASVM [Claim Listing ]
Indra Institute of Education Logo

Microsoft Office

Microsoft Office is a suite of applications designed to help with productivity and completing common tasks on a computer. You can create and edit documents containing text and images, work with data in spreadsheets and databases, and create presentations and posters.

by Indra Institute of Education [Claim Listing ]
Education World Logo

Advance Excel

Advance Excel course is offered by Education World. Education is a leading skill development Computer Institute, providing quality, Education with career support. Our primary aim is to achieve good skills and knowledge among the student and give them the right path to their destination.

by Education World [Claim Listing ]
Career Planet Computer Education Logo

Advance Excel Training Course

The Advanced Excel Training Program Course covering the basic and advanced modules of Microsoft Excel. In this training program, you will learn how to use Microsoft Excel and the advanced concepts of Excel.

by Career Planet Computer Education [Claim Listing ]
  • Price
  • Start Date
  • Duration

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