A yellow label containing the text Everyday Excel

Excel In A Minute

Advanced Tips and Tricks in
Excel that
make your life easier

  • 1 Minute
  • 10 Days
  • Access Anywhere
A girl making an excited expression holding a big analog clock
A yellow label containing the text Everyday Excel

Excel In A Minute

Advanced Tips and Tricks in Excel that make your life easier

  • 1 Minute
  • 10 Days
  • Access Anywhere
A girl making an excited expression holding a big analog clock
A man talking to someone on mobile phone and smiling
A yellow label containing the text Question

Do you frequently work
on Excel?

If you spend each day using Excel to make spreadsheets, then you'll probably aim to work faster and in an efficient manner.

While most of us want to do that, we are always restricted by the knowledge that we have.

There are times when we see others do the same work much faster compared to us.

Do you face a similar situation, and are looking for answers?

A yellow label containing the text Question

Do you frequently work on Excel?

If you spend each day using Excel to make spreadsheets, then you'll probably aim to work faster and in an efficient manner.

While most of us want to do that, we are always restricted by the knowledge that we have.

There are times when we see others do the same work much faster compared to us.

Do you face a similar situation, and are looking for answers?

A man talking to someone on mobile phone and smiling
A yellow label containing the text Simplify

Do you feel some tasks in Excel
have simpler solutions?

Sometimes, while working on Excel, you probably don’t feel like you’re using the most efficient method. At times you may be using methods that are helping you achieve your objective, but require a lot of steps.

In all the cases, you end up taking longer as well as the monotony of tasks can be frustrating. A majority of people feel exactly the same way when working with Excel.

Even if you are aware of complex formulas and are good at analysing data, a limited understanding of ways to work faster can inhibit your progress.

A yellow label containing the text Simplify

Do you feel some tasks in Excel have simpler solutions?

Sometimes, while working on Excel, you probably don’t feel like you’re using the most efficient method. At times you may be using methods that are helping you achieve your objective, but require a lot of steps.

In all the cases, you end up taking longer as well as the monotony of tasks can be frustrating. A majority of people feel exactly the same way when working with Excel.

Even if you are aware of complex formulas and are good at analysing data, a limited understanding of ways to work faster can inhibit your progress.

A yellow label containing the text benefits

How will this course
help you?

  • In this course, you will learn 10 advanced Excel tips and tricks that will enable you to work much faster and efficiently in Excel.
  • You will be able to complete seemingly tedious and painful tasks in just a few seconds! Yes, a few seconds!
  • You will learn advanced excel tricks to save time and work with confidence
A girl standing with a book in her hand as a boy and a girl sit and write something in their notebooks
A yellow label containing the text benefits

How will this course help you?

  • In this course, you will learn 10 advanced Excel tips and tricks that will enable you to work much faster and efficiently in Excel.
  • You will be able to complete seemingly tedious and painful tasks in just a few seconds! Yes, a few seconds!
  • You will learn advanced excel tricks to save time and work with confidence
A girl standing with a book in her hand as a boy and a girl sit and write something in their notebooks
A yellow label containing the text reasons

Why should you learn these 10 Excel tips and tricks?

If you want to stop wasting time by doing simple things manually or in a way that takes longer, then you should learn these 10 tips. You will learn the following in this course.

Deleting blank rows can be tedious and painful. Some users delete them manually, some sort the data to remove them, or some filter them out. However, you'll learn the most efficient, error-free way to remove blank rows in just a few seconds.

When you copy or cut a column, it can be confusing to remember, if Excel will paste the copied column before, on, or after the selected column. You'll learn an easy way to take the guesswork out and move columns in Excel quicker and with confidence.

Do you want to learn how to custom format cells in Excel with text? Do you want to display text appended to numbers, yet perform mathematical operations on that cell? It's easy, and you'll learn that in less than 60 seconds!

We all struggle whenever there are duplicate values in our data. The inbuilt utility to identify duplicates in Excel does not highlight the duplicate data but removes them instead. In this course, you will learn a simple Excel formula to find duplicates in one column easily and manage them with ease in the way you want to.

Calculating working days in Excel requires considerations like weekends and holidays. With different countries following different weekends, it gets complicated. Changing holiday dates can cause project plans to reflect incorrect status. You will learn a simple formula to manage all these complexities with ease and get an accurate answer each time!

There are times when you need to restrict the type of input you want to allow in a cell, e.g. text only, numbers only, numbers less than or meeting a condition, etc. You may also want to define the exact length of the text. You will learn how to do all this using a simple Excel functionality and define the boundary conditions for users of your Excel sheet.

Working with text formulas in Excel can be complex, as usually, we have to use more than one formula to achieve our objective. Learn a simple method, Flash Fill in Excel where you can split and merge text without writing a single formula. No kidding!

Are you maintaining similar sheets for monthly, quarterly, or yearly data? Or, are you maintaining similar sheets for products or people? Updating all of them can be time-consuming! Learn how to group sheets in Excel and make changes to all of them in one go.

Pivot Tables are useful in doing quick analysis. However, do you struggle with writing formulas when you have to find the difference of values from a single cell, e.g. difference in sales value over the years from a particular year? Learn how to use the in-built capability of Pivot Tables to get the result in no time.

Have you sorted data with months? Do you get stuck when it sorts the data alphabetically? Do you add numbers and then sort the data again manually? Learn the right method to avoid workarounds to sort data by months, days or other parameters!

A yellow label containing the text reasons

Why should you learn these 10 Excel tips and tricks?

If you want to stop wasting time by doing simple things manually or in a way that takes longer, then you should learn these 10 tips. You will learn the following in this course.

Deleting blank rows can be tedious and painful. Some users delete them manually, some sort the data to remove them, or some filter them out. However, you'll learn the most efficient, error-free way to remove blank rows in just a few seconds.

When you copy or cut a column, it can be confusing to remember, if Excel will paste the copied column before, on, or after the selected column. You'll learn an easy way to take the guesswork out and move columns in Excel quicker and with confidence.

Do you want to learn how to custom format cells in Excel with text? Do you want to display text appended to numbers, yet perform mathematical operations on that cell? It's easy, and you'll learn that in less than 60 seconds!

We all struggle whenever there are duplicate values in our data. The inbuilt utility to identify duplicates in Excel does not highlight the duplicate data but removes them instead. In this course, you will learn a simple Excel formula to find duplicates in one column easily and manage them with ease in the way you want to.

Calculating working days in Excel requires considerations like weekends and holidays. With different countries following different weekends, it gets complicated. Changing holiday dates can cause project plans to reflect incorrect status. You will learn a simple formula to manage all these complexities with ease and get an accurate answer each time!

There are times when you need to restrict the type of input you want to allow in a cell, e.g. text only, numbers only, numbers less than or meeting a condition, etc. You may also want to define the exact length of the text. You will learn how to do all this using a simple Excel functionality and define the boundary conditions for users of your Excel sheet.

Working with text formulas in Excel can be complex, as usually, we have to use more than one formula to achieve our objective. Learn a simple method, Flash Fill in Excel where you can split and merge text without writing a single formula. No kidding!

Are you maintaining similar sheets for monthly, quarterly, or yearly data? Or, are you maintaining similar sheets for products or people? Updating all of them can be time-consuming! Learn how to group sheets in Excel and make changes to all of them in one go.

Pivot Tables are useful in doing quick analysis. However, do you struggle with writing formulas when you have to find the difference of values from a single cell, e.g. difference in sales value over the years from a particular year? Learn how to use the in-built capability of Pivot Tables to get the result in no time.

Have you sorted data with months? Do you get stuck when it sorts the data alphabetically? Do you add numbers and then sort the data again manually? Learn the right method to avoid workarounds to sort data by months, days or other parameters!

What all does this course include?

What all does this course include?

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

An icon of a laptop

1 lesson video delivered each day for 10 days

An icon of a clock

Less than a minute investment per day

An icon of a certificate

Course Certificate on completing all lessons

An icon of downloading a file

Downloadable worksheets for practice

Course Curriculum

Course Curriculum

Reviews

5

Top Rated
  • 5 100%
  • 4
  • 3
  • 2
  • 1
Yee Zhong Tan

Tiktok Concept " Excel in a minute"

It's really difficult for working adults to find time, sit down and learn new skills especially after started to work . But this short video concept is align with "Tik Tok" , as we can save time to learn one or two new skills from Excel.

2 years ago

Get access to the course

You too can be outstanding at Excel and breeze through tasks like a pro with our select tips and tricks!

Invest just a fraction of a minute daily to master these handpicked techniques, and watch your Excel skills skyrocket in no time.

Don't wait another second - dive in and transform the way you work in Excel today!

Thumbnail for the course Excel In A Minute showing a girl holding a big table clock

Excel In A Minute

Tips and Tricks that Make Your Life Easier


  • Lifetime access
  • Workbook to practice along
  • Support available through discussion forums
  • One lesson daily for 10 days
  • Earn certificate on completing the course

Get access to the course

You too can be outstanding at Excel and breeze through tasks like a pro with our select tips and tricks!

Invest just a fraction of a minute daily to master these handpicked techniques, and watch your Excel skills skyrocket in no time.

Don't wait another second - dive in and transform the way you work in Excel today!

Thumbnail for the course Excel In A Minute showing a girl holding a big table clock

Excel In A Minute

Tips and Tricks that Make Your Life Easier


  • Lifetime access
  • Workbook to practice along
  • Support available through discussion forums
  • One lesson daily for 10 days
  • Earn certificate on completing the course