Spreadsheet Shortcuts, Formulas and Reports

Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.

Spreadsheet Shortcuts, Formulas and Reports

Instructor: EDUCBA

Included with

Learn more

Ask Coursera

6 modules

Gain insight into a topic and learn the fundamentals.

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

6 modules

Gain insight into a topic and learn the fundamentals.

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Apply Excel shortcuts, formulas, and functions to improve productivity and accuracy.
Use lookup, logical, financial, and text functions to analyze and manage business data.
Create professional reports, automate calculations, and optimize spreadsheet workflows efficiently.

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 6 modules in this course

Master Microsoft Excel shortcuts, formulas, functions, and reporting skills to work faster and smarter.

Learn VLOOKUP, HLOOKUP, IF, SUMPRODUCT, PMT, text functions, date calculations, trend analysis, and business reporting. This course helps learners build practical Excel skills for professional environments. You will learn essential shortcuts, worksheet navigation, formatting techniques, foundational formulas, counting functions, summation tools, logical values, and text combination techniques. The course also covers cell referencing, IF statements, conditional formulas, date and time calculations, text formatting, data cleaning, lookup functions, financial functions, loan analysis, payment calculations, statistical tools, ranking methods, trend analysis, forecasting, and rounding techniques. By the end of this course, you will be able to navigate Excel efficiently, build powerful formulas, retrieve and clean data, perform financial and statistical analysis, automate calculations, and create accurate professional reports. This course is ideal for students, analysts, finance professionals, MIS users, admin teams, and anyone who wants job-ready Excel productivity skills.

Learn essential Excel shortcuts, worksheet navigation, formatting techniques, and foundational formula-building skills to improve spreadsheet productivity and reporting efficiency.

What's included

9 videos4 assignments

9 videosTotal 71 minutes

Introduction to Excel reports12 minutes
Shortcut Key Function - F68 minutes
Shortcut Key Function - F106 minutes
Formatting Text and Numbers7 minutes
F2 and Shift Plus F28 minutes
CTRL Plus Apostrophe7 minutes
CTRL Plus Shift Plus Tilde8 minutes
Entering a Formula8 minutes
Entering a Function5 minutes

4 assignmentsTotal 60 minutes

Getting Started with Excel Reporting10 minutes
Smart Formatting Techniques10 minutes
Formula Basics & Quick Data Entry10 minutes
Excel Foundations & Essential Navigation30 minutes

Develop practical skills in Excel formulas, counting functions, summation tools, logical values, and text combination techniques for efficient data analysis.

What's included

9 videos4 assignments

9 videosTotal 84 minutes

Operator Precedence11 minutes
Name and Formula in Excel12 minutes
Count functions in Excel7 minutes
Sum Functions in Excel7 minutes
More in Count Functions in Excel7 minutes
Counts of Logical Values in Excel7 minutes
Sum Product Function in Excel11 minutes
Average Counting Blank and Non Blank11 minutes
Offset and Concat Function in Excel11 minutes

4 assignmentsTotal 60 minutes

Formula Logic and Naming Techniques10 minutes
Advanced Counting & Summation Skills10 minutes
Powerful Logical Functions in Action10 minutes
Mastering Formulas & Logical Functions30 minutes

Master cell references, logical functions, conditional formulas, and date/time calculations to automate decision-making and business reporting tasks.

What's included

9 videos4 assignments

9 videosTotal 80 minutes

Relative Reference in Excel6 minutes
Absolute and Mixed Reference in Excel10 minutes
Logically if Function in Excel7 minutes
Logically AND & OR Function in Excel9 minutes
Nested if and Switch Function10 minutes
Example of Logical Function12 minutes
Basic of Date and Time Format12 minutes
Dated if and Weekday Function7 minutes
Network Day Function7 minutes

4 assignmentsTotal 60 minutes

Understanding Cell References10 minutes
Building Smart Conditions in Excel10 minutes
Working with Dates & Time Calculations10 minutes
Cell Referencing & Logical Decision Making30 minutes

Build expertise in text formatting, data cleaning, search functions, and lookup operations to manage and retrieve business data effectively.

What's included

9 videos4 assignments

9 videosTotal 77 minutes

Work Day Function6 minutes
Example of Date and Time Function6 minutes
String Concentration Function13 minutes
Upper and Lower Function8 minutes
Lenth of the Function7 minutes
Trim and Clean Function12 minutes
Search and Concat Function11 minutes
Vertical Lookups (v LOOKUPS)7 minutes
Horizontal Lookups (H Lookups)7 minutes

4 assignmentsTotal 60 minutes

Date Planning and Text Handling10 minutes
Text Cleaning and Search Operations10 minutes
Lookup Functions for Data Retrieval10 minutes
Text Functions & Lookup Mastery30 minutes

Learn advanced lookup methods and financial functions to perform loan analysis, payment calculations, and dynamic data retrieval in Excel.

What's included

9 videos4 assignments

9 videosTotal 78 minutes

Match Function11 minutes
Left V Lookups10 minutes
Tow Ways Lookup9 minutes
Tow Ways Lookup Continues11 minutes
Example of Lookups10 minutes
PMT Financial Function6 minutes
Loan with Different Terms7 minutes
Loan with Different Terms Continues7 minutes
PPMT and IPMT6 minutes

4 assignmentsTotal 60 minutes

Dynamic Lookup Techniques10 minutes
Financial Calculations Made Easy10 minutes
Loan Analysis & Payment Functions10 minutes
Advanced Lookup & Financial Functions30 minutes

Apply statistical tools, ranking methods, trend analysis, forecasting techniques, and rounding functions to analyze and present business data accurately.

What's included

10 videos4 assignments

10 videosTotal 82 minutes

Example of PPMT and IPMT8 minutes
Average and Average If Function10 minutes
Random Number and rank Function8 minutes
Random Number and rank Function Continues8 minutes
Percentile and Quadrilles12 minutes
Round and Even Odd Function8 minutes
Trendline and Trend Analysis7 minutes
Trendline and Trend Analysis Continues8 minutes
Round up and Round Down Function6 minutes
INT and TRUNC Function7 minutes

4 assignmentsTotal 60 minutes

Data Analysis and Ranking Tools10 minutes
Trend Analysis & Precision Functions10 minutes
Forecasting & Final Excel Functions10 minutes
Statistical Analysis & Advanced Rounding Techniques30 minutes

Instructor

EDUCBA

1,625 Courses335,896 learners

Offered by

EDUCBA

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.