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

AH Accounting and Training Services Logo

Certificate In Microsoft Excel 2019

Are you tired of struggling with Excel and not fully utilising its capabilities? Do you want to stand out in your professional life by becoming an Excel expert? Look no further, because our Ultimate Excel Mastery Course is here to transform you into an Excel wizard!

by AH Accounting and Training Services [Claim Listing ]
Skills Campus Logo

Analysing and Visualizing Data with Excel

This course will teach you how to use Excel to perform data analysis and visualisations. As a beginner-level course, it is ideal for individuals interested in how to use Excel to explore, analyse, and present data with interactive visualisations.

by Skills Campus [Claim Listing ]
Ara Institute of Canterbury Ltd Logo

Access Enhanced

Enhance your knowledge and build your skills in Microsoft Access 2019/Office 365. Learn; forms, reports, advanced queries, import data from an external source, and create user instructions. We recommend you have completed Access for Beginners or have the equivalent knowledge.

by Ara Institute of Canterbury Ltd [Claim Listing ]
Sue's Computer Training Co Logo

Understanding Word Level 1

Covers the essentials of word processing, Preparing a document, changing and improving the way it looks, printing and saving it for future use.

by Sue's Computer Training Co [Claim Listing ]
UCOL (Manawatu Campus) Logo

Introduction to Microsoft PowerPoint

Learn the basics of creating a presentation in UCOL's free Introduction to Microsoft PowerPoint course. Following on from UCOL's Introduction to Computing course, continue your learning experience with this Introduction to Microsoft PowerPoint Course.

by UCOL (Manawatu Campus) [Claim Listing ]

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