Microsoft Excel (Data Analysis and Reporting)

by Auldhouse Claim Listing

You will automate some common Excel tasks, vLookups, apply pivot analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data.

$435

Contact the Institutes

Fill this form

Advertisement

Auldhouse Logo

img Duration

1 Day

Course Details

You will automate some common Excel tasks, vLookups, apply pivot analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data.

After completing this course, students will be able to:

  • Use the IF and IFERROR functions to calculate a value based on specified criteria; use conditional functions to summarize data; use PMT function to calculate periodic payments for a loan; use text functions to extract data strings; use date functions to calculate duration in years, months, and days; create array formulas to perform multiple calculations on multiple sets of data at one time; and change calculation options and iteration limits. 
  • Use the VLOOKUP and HLOOKUP functions to find values in worksheet data; use the MATCH function to find the relative position of a value in a range; use the INDEX function to find the value of a cell at a given position in a range; and use data tables to project values. 
  • Use the Data Validation feature to validate data entered in cells; and use advanced filter options to display the data you specify. 
  • Format data points in charts; create combination charts and trendlines; insert sparklines; use chart templates; and add and modify drawing objects and shapes. 
  • Ponsonby Branch

    338 Ponsonby Road, Ponsonby, Auckland
  • Sydenham Branch

    13 Stanley St, Sydenham, Christchurch
  • Wellington Branch

    Level 8, JacksonStone House 11 Hunter St, Wellington

Check out more MS Excel courses in New Zealand

Ripped Orange Logo

Microsoft PowerPoint (Intro)

In this course, you will learn how to design presentations for yourself or others in a creative, but equally efficient manner, then this course is for you.

by Ripped Orange [Claim Listing ]
Step by Step Auckland Logo

Microsoft Word Training

All of our word processing courses can be customised and targeted without needing to sit the full course or NZQA Unit Standard.

by Step by Step Auckland [Claim Listing ]
AH Accounting and Training Services Logo

Certificate in Microsoft Word 2019

Master Microsoft Word 2019 Like a Pro: Unlock the Full Potential of Word Processing with Our Comprehensive and Easy-to-Follow Course!

by AH Accounting and Training Services [Claim Listing ]
NorthTec Logo

Community Computing

You will learn through the latest Internationally standardised online tutorials, activities and tests, with the support of our friendly knowledgeable coaches on hand to offer assistance to gain computer confidence and learn new skills.

by NorthTec [Claim Listing ]
Chalk Box Logo

Microsoft Excel Functions

Learn the power of Excel. Turn stress into efficiency by using Excel formulae to simplify tasks. Expand your knowledge and gain new skills for using more of Excel’s wide range of functions.

by Chalk Box [Claim Listing ]

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