Improving Productivity Using Excel | Courses for Working Professionals

Improving Productivity Using Excel

Referencing, Copying Formulas, Dynamic Arrays, RANK Formula and Creating Price Charts

What will you learn in this course?

In this course, you will learn how to write better formulas using absolute or relative referencing. You will also learn how to use the dynamic arrays in Excel 365 or Excel 2021 to simplify the way you write formulas.

Cell Referencing

One of the major advantages of writing formulas in Excel is that you can easily copy and paste them to other cells.

Relative referencing and absolute referencing allow you to choose if you want referencing cells to move or stay as you copy a formula.

A good understanding will enable you to write robust formulas.

Dynamic Arrays

This is one of the best kept secrets of Excel 365 that allows you to write formulas across rows or columns without having to retype or even copy-paste them.

Learning this technique will help you finish your work much faster and also avoid common mistakes made while making use of referencing in your formulas

Rank Formula

Rank your data in ascending or descending order to emphasize their relative position in the data group.

This is used extensively in business situations while ranking sales, performance, or any other data that may require comparison.

How will this course help you?

In this course, you will learn these productivity methods saving you hours of effort.

Write robust formulas

You'll learn how to build worksheets with smart formulas that utilize fixed, relative or mixed referencing to prevent writing multiple formulas repeatedly in a worksheet

Update 2 dimensional tables

You'll be able to update 2 dimensional tables by just writing a single formula.

Example: You can create pricing charts, where a discount tier kicks in as the sales go up

Faster & error free formulas

Dynamic arrays transforms the way you write formulas. You can write one formula that spans multiple rows, columns or both.

You don't need to copy formulas and you can verify the formulas for multiple rows, columns or both by just looking at one cell.

This not only saves time, but also assures you of errors not creeping in at all.

Rank items

You'll be able to develop proficiency in rank formula and use its various variants to arrange your data in ascending or descending order.

A young man wearing headphones and looking at a laptop with focus

What all does this course include?

You'll have access to all these benefits once you enroll in this course

Short lessons for a quick understanding

Personalized feedback on assignment

Course Certificate on approval of assignment

Earn a Skill Badge on approval of assignment

Link to add certificate to your LinkedIn profile

Invitations to upcoming webinars

Discussion forum for clarifying doubts

Downloadable worksheets for practice

Course Curriculum

Improving Productivity
6 Lessons
- Download Resource File
  Start
- Reuse or copy formulas for fast turnaround
  Start
- Write smart, easy to copy formulas using absolute & relative referencing
  Start
- Reduce time & errors by writing Dynamic Array Formulas
  Start
- Rank data points using the RANK formula & Mixed Referencing
  Start
- Achieve more with less by writing mixed referencing formula
  Start
Wrap-up
3 Lessons
- Quiz - Improving Productivity
  Start
- Final Words
  Start
- Assignment
  Start

Get access to the course

If you want to work faster in Excel and reduce errors, time spent on resolving mistakes, then this is the course for you. You can make working on Excel an enjoyable experience rather than a challenging one.