Microsoft Excel Super User - Boost your Productivity

Name: Microsoft Excel Super User - Boost your Productivity
Rating: 4.4 (71 reviews)

For any Excel user (Beginner to Advanced) wanting to enhance their work efficiency and productivity

Created bySuhail Gangaram

Last updated 1/2024

English

What you'll learn

Learn efficient use and application of Excel features and tools
Learn basic tips and tricks to enhance productivity
Learn how to use and apply useful keyboard shortcuts to save time
Learn how to use and apply useful keyboard shortcuts to mitigate repetitive tasks

Course content

3 sections • 10 lectures • 57m total length

Sheet Duplication and Multiple Sheet Editing2:31
Master sheet duplication and multi-sheet editing in Excel by using quick drag-and-copy with the Ctrl key and applying a value across selected sheets.
Sheet Navigation using shortcut keys and custom buttons5:15
Navigate a multi-sheet workbook with Excel shortcuts, sheet list view, and clickable shape buttons, mastering quick jumps to sheets like sheet three.
Quick navigation shortcut keys and Row & Column resizing8:02

Populating and Replacing multiple cell content instantly3:01
Master populating and replacing multiple cell content instantly in Microsoft Excel using Ctrl+Enter and the find and replace feature.
Paste Special and Link cell values to a shape7:07
Master Excel paste special options to paste values, formulas, formats, or perform operations like multiply, and learn to link cell values to shapes for dynamic dashboards.
Relative and Absolute Cell Referencing7:41
Learn how to use relative and absolute cell referencing in Excel to accurately copy formulas across rows and columns, and lock cells with the dollar sign for reliable calculations.

Deleting Blank rows and Multi-level Row & Column sorting7:15
Delete blank rows in large data sets using go to special for efficient cleanup. Sort by product type, production output, and month; add or copy levels for multi-level sorting.
Snap to grid and Camera Tool7:28
Learn to align shapes to the Excel grid with snap to grid and enhance dashboards using the camera tool, which snapshots cell ranges as linked pictures that update automatically.
F1 and Invisible Text6:09
Use the F1 key with Ctrl to collapse the ribbon and gain more workspace. Hide numbers with three semicolons custom format to create a heat map using conditional formatting.
Cntrl D, Cntrl R and Alt3:29
Learn to use Ctrl D and Ctrl R for quick copy and paste in Excel, and the Alt key to navigate and apply features within the spreadsheet.

Requirements

Know how to operate a personal computer
Have a basic understanding of the Excel user interface

Description

Welcome to Microsoft Excel Super User - Boost your Productivity

In this course, any Excel user (Beginner to Advanced) will learn and improve on their existing Excel proficiency.

They will have the opportunity to learn Excel in a simple manner with the aim of enhancing office efficiency and productivity.

By the end of this course, learners will know:

How to efficiently use and apply Excel features and tools.
Basic tips and tricks to enhance productivity.
How to use and apply useful keyboard shortcuts to save time.
How to use and apply useful keyboard shortcuts to mitigate repetitive tasks.

My name is Suhail Gangaram and I will be your teacher for this course.

I have a BSc. (Hons) Mechanical Engineering degree with a higher certificate in Production/Operations and Productivity Management.

My Excel journey began when I first started working in a process improvement role, where my work involved improving operational processes and efficiencies within industrial production environments.

Currently, I am working as a Senior PMO Analyst and the work I have done up until now, involved and continues to involve the use of Excel, where I mainly use it for analyses and designing interactive reports and dashboards from scratch.

I want learners to learn Excel in a manner which is simple. Therefore, I have designed this course in a way that is easy to follow and understand.

If you are interested in leveling up your Excel knowledge, then you have found the right course!

Looking forward to learning with you in your Excel journey. Good luck!

Who this course is for:

Anyone interested in improving Excel working efficiency and productivity
Anyone ranging from a Beginner to Advanced Excel user

Microsoft Excel Super User - Boost your Productivity

What you'll learn

Explore related topics

Course content

Basics3 lectures • 16min

Productivity3 lectures • 18min

Efficiency4 lectures • 24min

Requirements

Description

Who this course is for: