Dive into "Excel Essentials and Beyond", a comprehensive exploration of Excel, the world's leading spreadsheet tool. This course is thoughtfully crafted for both newcomers to Excel and also for those aiming for mastery.
We begin by introducing Excel's robust interface and foundational features, ensuring a firm grasp of data organization techniques. As you advance, you'll delve into data visualization, transforming raw data into captivating stories.
The course reveals advanced data manipulation. Explore temporal data handling for data-centric analyses, and harness the power of Excel's dynamic lookup functions. Visualization takes center stage as you learn to craft compelling charts, and the intricacies of Pivot Tables and Charts are demystified, setting the stage for deep data exploration.
The concluding modules focus on designing dynamic dashboards, essential for today's decision-makers. By the course's end, you'll be equipped not just to use Excel, but to leverage its vast capabilities for influential data-driven outcomes.
Disclaimer: This course is an independent educational resource developed by Board Infinity and is not affiliated with, endorsed by, sponsored by, or officially associated with Microsoft Corporation or any of its subsidiaries or affiliates. This course is not an official preparation material of Microsoft Corporation. All trademarks, service marks, and company names mentioned are the property of their respective owners and are used for identification purposes only.
In this comprehensive module, you'll embark on a transformative journey through four essential pillars of Excel proficiency. Starting with an introduction to Excel's interface and capabilities, you'll then dive into the art of cell formatting and styling, mastering techniques to make your data visually compelling. Next, you'll explore the intricacies of cell references, uncovering the power of relative, absolute, and mixed references for accurate data analysis. The module culminates in advanced data management and navigation strategies, enabling you to efficiently sort, filter, and manipulate data. By completing this module, you'll acquire a solid foundation in Excel that's indispensable for success in various professional pursuits.
Inclus
20 vidéos6 lectures5 devoirs2 sujets de discussion1 plugin
Afficher les informations sur le contenu du module
20 vidéos•Total 131 minutes
What is Microsoft Excel•3 minutes
Why Excel is important for any career•6 minutes
Understanding the Ribbon•7 minutes
What is Worksheet and Workbook•8 minutes
Data Types in Excel•7 minutes
Format Cells in Excel•8 minutes
Number Tab in Excel•4 minutes
How to change the font, Font size, Font Colour in Excel•6 minutes
How to do Text Alignment and apply border in Excel•8 minutes
How to apply format painter in Excel•6 minutes
Formatting Text and Numbers•9 minutes
References in Excel•5 minutes
Relative Reference in Excel•5 minutes
Absolute Reference in Excel•5 minutes
Mixed Reference in Excel•10 minutes
Navigations using Excel•8 minutes
Flash fill•5 minutes
Sorting Data in Excel•9 minutes
Filtering Data in Excel•7 minutes
Text to Columns in Excel•5 minutes
6 lectures•Total 140 minutes
Syllabus•10 minutes
Further reads on Introduction to Excel•30 minutes
Learn more about Mastering Cell Formatting and Styling in Excel•30 minutes
Learn more about Excel Formatting and Cell Reference Techniques•30 minutes
Learn more about Excel Data Management and Navigation Strategies•30 minutes
Practice Quiz - Mastering Cell Formatting and Styling in Excel•15 minutes
Practice Quiz - Excel Formatting and Cell Reference Techniques•15 minutes
Practice Quiz - Excel Data Management and Navigation Strategies•15 minutes
2 sujets de discussion•Total 20 minutes
Meet & Greet•10 minutes
How Do You Use Excel in Your Daily Work?•10 minutes
1 plugin•Total 15 minutes
Quick Course Check-In•15 minutes
Excel Data Analysis and Visualization
Module 2•5 heures à terminer
Détails du module
Dive into the heart of data manipulation and presentation with this comprehensive module. From refining and visualizing data to performing advanced calculations and intricate conditional logic, you'll acquire a holistic understanding of Excel's capabilities. Master the art of data analysis, unleash the potential of specialized functions, and enhance your data visualization skills, all while becoming proficient in harnessing conditional logic for dynamic decision-making. By completing this module, you'll emerge as a data-savvy Excel expert ready to extract insights and convey information effectively.
Inclus
20 vidéos4 lectures5 devoirs
Afficher les informations sur le contenu du module
20 vidéos•Total 90 minutes
Remove Duplicates in Excel•5 minutes
Data Validation in Excel•8 minutes
Conditional Formating in Excel•9 minutes
Advanced Conditional Formatting with Formulae in Excel•6 minutes
Clear Rules•3 minutes
Functions and Formulae in Excel•7 minutes
Sum Function•5 minutes
Min Function•3 minutes
Max Function•1 minute
Count Function•3 minutes
Count A Function•3 minutes
Average Function•1 minute
Conditionals in Excel•4 minutes
If Conditions in Excel•4 minutes
If with Or Conditions in Excel•6 minutes
If with And Conditions in Excel•4 minutes
A simple Nested if Conditions in Excel•5 minutes
IfError Condition in Excel•4 minutes
SumIF Condition in Excel•6 minutes
SumIFs Condition in Excel•5 minutes
4 lectures•Total 120 minutes
Further reads on Excel Data Enhancement and Visualization Techniques•30 minutes
Learn more about Excel Functions for Data Analysis and Calculation•30 minutes
Learn more about Excel Advanced Data Analysis and Conditional Logic•30 minutes
Learn more about Excel Conditional Logic and Specialized Functions•30 minutes
5 devoirs•Total 120 minutes
Graded Quiz - Excel Data Analysis and Visualization•60 minutes
Practice Quiz - Data Enhancement and Visualization Techniques•15 minutes
Practice Quiz - Excel Functions for Data Analysis and Calculation•15 minutes
Practice Quiz - Excel Advanced Data Analysis and Conditional Logic•15 minutes
Practice Quiz - Excel Conditional Logic and Specialized Functions•15 minutes
Excel Advanced Functions and Temporal Functions
Module 3•5 heures à terminer
Détails du module
In this comprehensive learning journey, you will delve into the realm of advanced Excel functions and the manipulation of date and time data. As you progress through the lessons, you'll acquire the skills needed to analyze complex data scenarios, optimize workday calculations, and effectively utilize Excel's powerful date and time functions. Whether you're seeking to enhance your analytical capabilities, streamline scheduling tasks, or make informed decisions based on time-related data, this module equips you with the expertise to excel in these endeavors. Let's begin your exploration of Excel's advanced functions and temporal manipulation techniques.
Inclus
20 vidéos4 lectures5 devoirs1 sujet de discussion
Afficher les informations sur le contenu du module
20 vidéos•Total 70 minutes
CountIF Condition in Excel•3 minutes
CountIFs Condition in Excel•3 minutes
Average IF Condition in Excel•4 minutes
Average IFS Condition in Excel•3 minutes
Date and Time Functions in Excel•6 minutes
Date Function•4 minutes
Today Function•3 minutes
Now Function•4 minutes
Date Value Function•5 minutes
Day Function•2 minutes
Month Function•1 minute
Year Function•2 minutes
EOMonth Function•4 minutes
Weekday Function in Excel•4 minutes
DatedIF Function•4 minutes
EDATE Function•3 minutes
Workday Function•5 minutes
Workday.INTL Function•5 minutes
NetworkDays Function•3 minutes
NetworkDays.INTL Functions•4 minutes
4 lectures•Total 120 minutes
Further Reads on Advanced Excel Functions and Conditional Calculations•30 minutes
Learn More About Excel Date and Time Manipulation Techniques•30 minutes
Learn More About Excel Date and Time Analysis Toolbox•30 minutes
Learn more about Advanced Date and Workday Functions in Excel•30 minutes
5 devoirs•Total 120 minutes
Graded Quiz - Excel Advanced Functions and Temporal Functions•60 minutes
Practice Quiz - Advanced Excel Functions and Conditional Calculations•15 minutes
Practice Quiz - Excel Date and Time Manipulation Techniques•15 minutes
Excel Date and Time Analysis Toolbox practice quiz•15 minutes
Practice Quiz - Advanced Date and Workday Functions in Excel•15 minutes
1 sujet de discussion•Total 10 minutes
Before Module 3: Ready to Go Beyond the Basics?•10 minutes
Excel Data Manipulation and Advanced Lookups
Module 4•5 heures à terminer
Détails du module
In this comprehensive learning journey, you will delve into the realm of advanced data retrieval techniques and text manipulation within Excel. Through a series of carefully crafted lessons, you'll gain mastery over lookup functions, uncover advanced data manipulation methods, and explore the intricacies of text handling and cleaning. By the end of this module, you'll possess the skills needed to efficiently retrieve, analyze, and manipulate data, enhancing your overall Excel proficiency.
Inclus
20 vidéos4 lectures5 devoirs
Afficher les informations sur le contenu du module
20 vidéos•Total 82 minutes
Lookup Functions in Excel•3 minutes
Vlookup in Excel•9 minutes
Hlookup in Excel•3 minutes
Index and Match Function in Excel•5 minutes
Index Functions•3 minutes
Match Functions•3 minutes
Index and Match Function•5 minutes
Two way Lookup•6 minutes
Case Sensitive Lookup•6 minutes
Left Lookup•5 minutes
Two Column Lookup•4 minutes
Closest Match•4 minutes
Text Functions in Excel•6 minutes
Concatenate Function•2 minutes
Left Function•2 minutes
Right Function•2 minutes
MID Function•3 minutes
TRIM Function•3 minutes
Replace Function•5 minutes
LEN Function•2 minutes
4 lectures•Total 120 minutes
Further reads on Excel Lookup Techniques and Advanced Data Retrieval•30 minutes
Learn more about Excel Advanced Lookup Techniques and Dynamic Retrieval•30 minutes
Learn More About Excel Data Manipulation and Text Techniques•30 minutes
Learn More About Excel Text Manipulation and Cleaning Techniques•30 minutes
5 devoirs•Total 120 minutes
Graded Quiz - Excel Data Manipulation and Advanced Lookups•60 minutes
Practice Quiz - Excel Lookup Techniques and Advanced Data Retrieval•15 minutes
Practice Quiz - Excel Advanced Lookup Techniques and Dynamic Retrieval•15 minutes
Practice quiz- Excel Data Manipulation and Text Techniques•15 minutes
Practice Quiz - Excel Text Manipulation and Cleaning Techniques•15 minutes
Excel Data Analysis, Visualization, and Presentation
Module 5•5 heures à terminer
Détails du module
In this comprehensive learning journey, you'll delve into the core aspects of Excel, ranging from mastering data analysis techniques and utilizing Pivot Tables for in-depth exploration to creating impactful charts and leveraging advanced visualization tools. By the end of this module, you'll be equipped to analyze, visualize, and effectively present data, making informed decisions and conveying insights with confidence.
Inclus
20 vidéos4 lectures5 devoirs
Afficher les informations sur le contenu du module
20 vidéos•Total 74 minutes
Find Function•3 minutes
Round Function•3 minutes
Subtotal Function•4 minutes
Pivot Tables in Excel•2 minutes
Creating a Pivot Table and Dragging a field•3 minutes
Sorting & Filtering in Pivot Table•5 minutes
Changing Summary Calculation in Pivot Table•3 minutes
Two Dimensionals Pivot Table•3 minutes
Slicer in Pivot Table•4 minutes
Charts in Excel•4 minutes
Creating a Chart in Excel•4 minutes
Switch Row/Column for charts in Excel•3 minutes
Legend Position for Charts in Excel•3 minutes
Data Labels for Charts•4 minutes
Pivot Charts in Excel and its types•3 minutes
Creating a Pivot Chart•4 minutes
Filter Pivot Chart•2 minutes
Lines Charts•6 minutes
Scatterplots•5 minutes
Heat maps•5 minutes
4 lectures•Total 120 minutes
Further reads on Mastering Excel Data Analysis and Presentation•30 minutes
Learn More About Excel Pivot Tables and Visual Data Exploration•30 minutes
Learn More About Excel Charting and Visualization Techniques•30 minutes
Learn More About Excel Pivot Charts and Advanced Visualizations•30 minutes
5 devoirs•Total 120 minutes
Graded Quiz - Excel Data Analysis, Visualization, and Presentation•60 minutes
Practice Quiz - Mastering Excel Data Analysis and Presentation•15 minutes
Practice Quiz - Excel Pivot Tables and Visual Data Exploration•15 minutes
Practice Quiz - Excel Charting and Visualization Techniques•15 minutes
Practice Quiz - Excel Pivot Charts and Advanced Visualizations•15 minutes
Excel Advanced Data Visualization and Insightful Dashboards
Module 6•5 heures à terminer
Détails du module
In this comprehensive learning journey, you'll dive deep into advanced techniques for visualizing data in Excel. From specialized charting methods for detailed analysis to the practical creation of interactive dashboards, you'll gain the expertise to present data in a compelling and informative manner. By mastering these skills, you'll be empowered to extract insights, make informed decisions, and effectively communicate complex information.
Inclus
12 vidéos4 lectures3 devoirs1 évaluation par les pairs
Afficher les informations sur le contenu du module
12 vidéos•Total 72 minutes
Histograms•6 minutes
Maps in Excel•5 minutes
Dual Axis Charts•4 minutes
Pie Charts•3 minutes
Bump Charts•12 minutes
Control charts•4 minutes
Funnel charts•7 minutes
Pareto charts•5 minutes
Waterfall charts•4 minutes
Usage and filtration of data with charts•3 minutes
Dashboarding in Excel•8 minutes
Case by creating dashboard•11 minutes
4 lectures•Total 100 minutes
Further Reads On Excel Advanced Visualization Techniques•30 minutes
Learn More About Excel Specialized Charts and Data Analysis•30 minutes
Learn More About Excel Dashboard Design and Practical Implementation•30 minutes
Provide your feedback!•10 minutes
3 devoirs•Total 45 minutes
Practice Quiz - Excel Advanced Visualization Techniques•15 minutes
Practice Quiz - Excel Specialized Charts and Data Analysis•15 minutes
Practice Quiz - Excel Dashboard Design and Practical Implementation•15 minutes
Board Infinity is a full-stack career platform, founded in 2017 that bridges the gap between career aspirants and industry experts. Our platform fosters professional growth, delivering personalized learning experiences, expert career coaching, and diverse opportunities to help individuals fulfill their career dreams. Board Infinity has successfully facilitated over 20,000 career transitions, marking a significant impact in the career development landscape.
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.’
Avis des étudiants
4.4
53 avis
5 stars
64,15 %
4 stars
20,75 %
3 stars
9,43 %
2 stars
3,77 %
1 star
1,88 %
Affichage de 3 sur 53
M
MA
5·
Révisé le 5 févr. 2025
Very nice instructor. He explains, you understand and the extra reading resources he provides are superb. I highly recommend this course to anyone.
F
FH
5·
Révisé le 21 juil. 2024
A great simple hands on approach for learning basic and advance functions in MS Excel.
M
MT
5·
Révisé le 3 sept. 2024
The Journey has been really good so far and I learned a lot of new things. Thanks!!!
What is the "Excel Essentials and Beyond" course all about?
This course is a comprehensive journey into excel, taking you from foundational skills to advanced techniques. You'll learn to efficiently analyze, visualize, and present data using excel's vast capabilities.
Who is this course designed for?
This course is suitable for beginners looking to get started with excel, as well as intermediate users aiming to enhance their proficiency and explore advanced Excel functionalities.
What prerequisites should I have before taking this course?
A basic familiarity with spreadsheets can be helpful, but it's not mandatory. The course starts with foundational concepts, making it accessible to all.
What will I learn in this Excel course?
You'll master a range of skills from navigating Excel, Data Manipulation, Visualization, creating dynamic dashboards, using Pivot Tables, and much more.
What is covered in the first module about Excel Proficiency Essentials?
The first module focuses on foundational skills. You'll learn about the Excel interface, cell formatting, references, and advanced data management techniques.
What are the key topics in the second module focusing on Data Analysis and Visualization?
The second module dives deep into data manipulation and presentation. You'll harness specialized functions, data visualization skills, and conditional logic in Excel.
What topics are covered in the third module concerning Excel Advanced Functions and Temporal Functions?
This module introduces you to Excel functions and how to manipulate date and time data effectively. You'll learn about workday calculations and various date-time functions.
What does the fourth module on Data Manipulation and Advanced Lookups include?
In this module, you'll explore advanced data retrieval techniques, master lookup functions, and delve into text manipulation and cleaning within Excel.
How will the fifth module enhance my skills in Data Analysis, Visualization, and Presentation?
This module will equip you with advanced data analysis techniques, Pivot Tables, and creating diverse charts for impactful data visualization.
What can I expect from the sixth module on Advanced Data Visualization and Insightful Dashboards?
You'll learn specialized charting methods, and how to design and implement interactive and insightful dashboard in Excel.
How long does it typically take to complete the course?
The course will take approximately 15 hours to complete. This estimate includes time for lectures, hands-on exercises, and projects, but the actual time may vary depending on individual pace and understanding.
Can I take the course at my own pace?
Absolutely, the Excel course is designed for self-paced learning. This allows you to progress through the material at a pace that suits your individual needs and schedule.
When will I have access to the lectures and assignments?
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.
What will I get if I purchase the Certificate?
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.
Is financial aid available?
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.