Microsoft Excel From Beginner to Advanced 2024

Focused View

Dr. Wendy Pierre

2:13:30

20 View

1. Introduction

1. Welcome and Introduction.mp4

03:27

2. About The Instructor

1. About Dr. Wendy Pierre.mp4

01:35

3. Course Outline

1. Course Outline.mp4

03:05

2. Course Certificate.mp4

02:12

4. MODULE I The importance of Excel in the 21st Century

1. What is excel and what is the importance of excel in todays data-driven world.mp4

04:59

2. Different Methods to Open Excel, in Windows, macOS, and other Operating System.mp4

02:37

3. About the Instructor.mp4

01:35

5. Module II

1. Quick Navigation The status bar Spreadsheet and overview of the Course..mp4

07:59

2. What is Excel A brief History about excel what actually ribbon is worksh.mp4

04:47

6. Module III The Basics of Excel

1. Columns Rows Cells How to enter data into the cells How to change cell.mp4

06:29

7. Module IV Concatenation

1. Second Method; Using CONCATENATE Function.mp4

02:31

2. How to merge two columns in Excel without losing data using concatenation or con.mp4

04:12

8. MODULE V Formulas and Functions

1. Working With Charts and Graphs..mp4

02:43

2. How can we sort data in the Excel.mp4

02:49

3. Formulas and Functions.mp4

05:13

9. MODULE VI Relative and Absolute Cell Referencing

1. Relative and Absolute Cell Referencing..mp4

04:52

10. MODULE VII How to Enter Data in Excel

1. How to Enter Data in Excel.mp4

05:07

11. MODULE VIII Order of Operations in Excel

1. Order of Operations in Excel.mp4

07:06

12. MODULE IX Copying and Moving with Drag and Drop in Excel

1. Copying and Moving with Drag and Drop in Excel.mp4

04:02

13. MODULE X Working with Rows and Columns

1. How to Hide and Unhide Rows and Columns.mp4

08:08

2. How to Work with Rows and Columns.mp4

05:08

14. MODULE XI How to Work with Sheets

1. How To Change the Sheets How to Protect Sheets How to Delete Sheets.mp4

05:11

2. How to Create New Sheets Move Sheets around Sheet Reference .mp4

02:14

3. How to Work with Sheets.mp4

03:29

15. MODULE XII How to Filter Data

1. How To Remove Filter The Shortest Method to apply Filter.mp4

03:24

2. How to Filter Data {Long Method) Applying Filter on one Particular Column.mp4

04:42

3. About Filtering of Data..mp4

03:44

16. MODULE XIII Functions

1. Some Definitions to better understand Functions.mp4

02:43

2. Functions.mp4

03:40

3. How to perform a specific calculations in Excel.mp4

06:47

17. MODULE XIV How to name a number of ranges of cells in Excel

1. How to name a number of ranges of cells in Excel.mp4

07:00

Description

Learn A-Z in Excel, From Zero to Hero | Become an Advanced Excel User, For Excel 2013, 2016, 2019, 2021, Office 365.

What You'll Learn?

Master Microsoft Excel from Beginner to Advanced
Learn the most common Excel functions used in the Office
Build a solid understanding on the Basics of Microsoft Excel
Surprise your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
Access to a Professional helper/instructor with 20+ years of experience in teaching Excel
Develop advanced skills for complex data tasks.
Receive a certificate of completion to showcase your expertise.

Who is this for?

• Beginners looking to master Excel fundamentals.

• Intermediate users seeking advanced techniques.

• This Microsoft Excel course will take you through 3 levels of Microsoft Excel topics (Beginner, Intermediate, and Advanced).

• Professionals wanting to enhance their data analysis and reporting skills

What You Need to Know?

• Basic computer literacy.

• Familiarity with Microsoft Office applications is beneficial but not mandatory

• Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365 Excel installed on your Computer to Follow Along with Instructor Lectures is greatly Recommended

More details

Description
Welcome to our Excel Course!

Whether you're a beginner stepping into the world of spreadsheets or looking to refresh your skills, this course is your key to mastering the basics of Microsoft Excel.

In this engaging and user-friendly course, you'll:
Explore the essential features of Excel, from navigating the interface to understanding the core functionalities.

Learn to create, format, and organize data in a spreadsheet with ease.

Gain confidence in using basic formulas and functions for everyday calculations.

Discover time-saving tips and tricks to boost your efficiency and productivity.
This course is divided in different sections or individual lectures, and youâ€™ll be able to explore brand new Excel tips added on a regular basis. Each video is designed to be an independent and self-contained Excel video on itself, to help you learn these tools and techniques in quick, easy, and in small portion.

Join us on this learning journey and build a solid foundation in Excel that will serve you in both personal and professional settings. Enroll now and let's dive into the exciting world of spreadsheets together

Introduction: Buckle up for a thrilling dive into the universe of Excel!
What is Excel: Grasp the foundational concepts of the spreadsheet giant.
History of Excel: Embark on a journey through the evolution of this powerful tool.
Ribbon Overview: Navigate the Excel ribbon with the finesse of a pro.
Worksheet tabs: Master the art of organizing your data with precision.
Name Box: Uncover the secrets behind cell naming and referencing.
Status Bar: Decode the hidden information within the status bar.
Overview: Summarize your newfound Excel essentials in this thrilling introduction.
How to open Excel: Kickstart your Excel journey with the right steps.
Creating Spreadsheets: Craft your first masterpiece with hands-on guidance.
Define Cells, Column, and Rows: Understand the building blocks of Excel data.
How to enter data in a cell: Input data with finesse and precision.
Cells Formatting: Elevate the visual appeal of your spreadsheets with advanced formatting techniques.

While the level of difficulty varies considerably, the Excel demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of the underlying Excel concepts (like Excel Pivot Tables or formulas, for example).

It's time to start working smarter, not harder. If you're looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel EXPERT, this is the course for you.

Join today and get immediate, lifetime access to the following:
2+ hours of high-quality video
Excel project files & solutions
Expert-support and Q&A forum
30-day money-back guarantee

Happy learning!
-Dr. Wendy Pierre (Founder, Graphex Academy)
As you participate in each of the 14 Modules of this Excel Course that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.
At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:
Â· Creating effective spreadsheets
Â· Managing large sets of data
Â· Mastering the use of some of Excel's most popular and highly functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)
Â· Create dynamic report with Excel PivotTables
Â· Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot
Â· Excel Worksheet formulas to ensure clean formulas
Â· Automate your day to day Excel tasks by mastering the power of Macros and VBA and many more.
Who this course is for:
â€¢ Beginners looking to master Excel fundamentals.
â€¢ Intermediate users seeking advanced techniques.
â€¢ This Microsoft Excel course will take you through 3 levels of Microsoft Excel topics (Beginner, Intermediate, and Advanced).
â€¢ Professionals wanting to enhance their data analysis and reporting skills

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Dr. Wendy Pierre

Instructor's Courses

Dr. Wendy Pierre, With over two decades of relentless dedication to the realm of Microsoft Excel, Dr. Pierre has become synonymous with excellence in data analysis, reporting, and spreadsheet wizardry.Dr. Pierre's journey commenced in the late '90s, a time when Excel was making strides in becoming the go-to tool for businesses globally. Intrigued by the untapped potential of this software, Dr. Pierre delved deep into its intricacies, fueled by an unyielding passion for Microsoft Excel manipulation and Teaching.Armed with 4 bachelors, 2 masters, and a PhD Candidate in the related field, from a renowned institution, Dr. Pierre laid the academic foundation for his future endeavors. His academic prowess blended seamlessly with his natural affinity for problem-solving and logical reasoning.Dr. Pierre's professional journey took him across diverse industries, from Computer science to healthcare, and Business where he honed his Excel skills in varied contexts. This global exposure equipped him with a broad understanding of the challenges organizations faced in managing and interpreting vast sets of data.Dr. Pierre’s ascent to Excel virtuosity was marked by continuous learning and adaptation. From the simplicity of basic formulas to the intricacies of advanced functions and data visualization, Dr. Pierre mastered every facet of Excel's capabilities.Recognizing the transformative impact that Excel mastery had on his own career, Dr. Pierre felt compelled to share his knowledge. Over a decade ago, he made the transition from Business analyst to a dedicated Excel instructor, driven by the mission to empower others with the same skills that had been his professional bedrock.Dr. Wendy Pierre's legacy as an Excel instructor is one defined by passion, expertise, and a relentless commitment to empowering others. As he continues to shape the next generation of data professionals, the impact of his teachings reverberates across industries, countries and continents, solidifying his status as a true Excel Maestro.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.