Spreadsheet Shortcuts, Formulas and Reports

Obtenez l'une de nos meilleures offres avec Coursera Plus pour 199 $ (habituellement 399 $). Économisez maintenant.

Ce cours n'est pas disponible en Français (France)

Nous sommes actuellement en train de le traduire dans plus de langues.

Spreadsheet Shortcuts, Formulas and Reports

Instructeur : EDUCBA

Inclus avec

6 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

2 semaines à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

6 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

2 semaines à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

Ce que vous apprendrez

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.

Détails à connaître

Certificat partageable

Ajouter à votre profil LinkedIn

Récemment mis à jour !

juin 2026

Évaluations

24 devoirs

Enseigné en Anglais

Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées

En savoir plus sur Coursera pour les affaires

logos de Petrobras, TATA, Danone, Capgemini, P&G et L'Oreal

Il y a 6 modules dans ce cours

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.

Inclus

9 vidéos4 devoirs

9 vidéosTotal 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 devoirsTotal 60 minutes

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

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

Inclus

9 vidéos4 devoirs

9 vidéosTotal 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 devoirsTotal 60 minutes

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

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

Inclus

9 vidéos4 devoirs

9 vidéosTotal 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 devoirsTotal 60 minutes

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

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

Inclus

9 vidéos4 devoirs

9 vidéosTotal 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 devoirsTotal 60 minutes

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

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

Inclus

9 vidéos4 devoirs

9 vidéosTotal 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 devoirsTotal 60 minutes

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

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

Inclus

10 vidéos4 devoirs

10 vidéosTotal 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 devoirsTotal 60 minutes

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

Instructeur

EDUCBA

1 657 Cours337 648 apprenants

Offert par

EDUCBA

En savoir plus sur Data Analysis

Statut : Essai gratuit
Coursera
Accounting Spreadsheets: Formulas, Validation, Formatting
Cours
Statut : Essai gratuit
John Wiley & Sons
Excel Formulas and Data Analysis Essentials
Cours
Packt
Excel Functions and Formulas
Cours
Statut : Essai gratuit
EDUCBA
Master Microsoft Excel: Apply, Analyze & Visualize Data
Cours

Pour quelles raisons les étudiants sur Coursera nous choisissent-ils pour leur carrière ?

Felipe M.

Étudiant(e) depuis 2018

’Pouvoir suivre des cours à mon rythme à été une expérience extraordinaire. Je peux apprendre chaque fois que mon emploi du temps me le permet et en fonction de mon humeur.’

Jennifer J.

Étudiant(e) depuis 2020

’J'ai directement appliqué les concepts et les compétences que j'ai appris de mes cours à un nouveau projet passionnant au travail.’

Larry W.

Étudiant(e) depuis 2021

’Lorsque j'ai besoin de cours sur des sujets que mon université ne propose pas, Coursera est l'un des meilleurs endroits où se rendre.’

Chaitanya A.

’Apprendre, ce n'est pas seulement s'améliorer dans son travail : c'est bien plus que cela. Coursera me permet d'apprendre sans limites.’

Foire Aux 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.