Week 3 Introduction

Loading...

Del curso dictado por Macquarie University

Excel Skills for Business: Intermediate II

270 calificaciones

Macquarie University

Excel Skills for Business: Intermediate II

270 calificaciones

Curso 3 de 4 en SpecializationExcel Skills for Business

Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In this third course of our Excel specialization Excel Skills for Business you will delve deeper into some of the most powerful features Excel has to offer. When you have successfully completed the course you will be able to Check for and prevent errors in spreadsheets; Create powerful automation in spreadsheets; Apply advanced formulas and conditional logic to help make informed business decisions; and Create spreadsheets that help forecast and model data. Once again, we have brought together a great teaching team that will be with you every step of the way. Nicky, Prashan and myself will guide you through each week. As we are exploring these more advanced topics, we are following Alex who is an Excel consultant called in by businesses that experience issues with their spreadsheets.

De la lección

Automating Lookups

How do find information from different parts of a workbook? This module introduces you to functions like CHOOSE, VLOOKUP, INDEX, MATCH and other dynamic lookups to find and display data from several sources.

Week 3 Introduction2:43

Week 3 Discussion4:59

Conoce a los instructores

Dr Yvonne Breyer
Director, Learning and Teaching
Faculty of Business and Economics

[SOUND] Welcome to week three.

As our spreadsheets grow in size and complexity,

we want automation wherever possible.

Especially when we need to draw on information that is stored in different

parts of a workbook.

We need to find mechanisms to ensure that our work is fast,

efficient and free of errors.

These Excel functionalities will come into play when you are working with files from

say different departments in your organization.

However they become even more essential when you're doing something more complex

like completing a bank reconciliation or even finalizing a tax return.

It could even be something very common like getting your data ready for

a mail merge as part of a conference or networking event.

Alex has been asked to help populate some data in particular spreadsheets with

values from other spreadsheets.

Manually attending to this is going to be too time consuming and

of course prone to multiple errors.

Excel has a great toolbox of functions just for this task.

These functions can be used to help you find exactly what you want from one

spreadsheet based on certain criteria and

then feed this information into another spreadsheet, genius.

This week Alex is building an automated quotation system for a network company.

Here you will learn about the key functions he's going to use to do his job.

We're starting off with an introduction to lookups with the CHOOSE function.

After that, we are working through the use of VLOOKUP function

to find approximate as well as exact matches.

The MATCH function, is going to help us find a position and

then we will combine index and match to create Dynamic Lookups.

As always we have a series of practice videos to equip and

empower you with these co Excel skills.

Download the Excel workbooks, and

work alongside us in the upcoming practice videos step by step.

Practice makes permanent, so come back and work through these videos again.

Remember, the practice challenge after these videos, which will show you

the true power and efficiency of using lookup functions in Excel.

Check out the toolbox as you always do and of course this week's great ninja tip.

Now let's sit down with Nicky and talk about automating lookups in more detail.

[SOUND]

Explora nuestro catálogo

Inscríbete de manera gratuita y obtén recomendaciones personalizadas, actualizaciones y ofertas.

Coursera brinda acceso universal a la mejor educación del mundo, al asociarse con las mejores universidades y organizaciones, para ofrecer cursos en línea.

© 2018 Coursera Inc. Todos los derechos reservados.

Descargar en la App Store

Consíguelo en Google Play