The Complete Microsoft Excel 365 Masterclass

Focused View

Media Training Worldwide Digital,Jan Ekhteyari

6:28:44

26 View

1. Getting Started with Excel

1. The Complete Microsoft Excel 365 Masterclass.mp4

01:20

2. Join Your Facebook Support Community!.mp4

00:34

3. Ask a Question! You Will Not be Judged!.mp4

00:28

4. License Guide - Microsoft 365 Plan and Installation.mp4

11:51

5. Launching Microsoft Excel in a Productive Way.mp4

02:31

6. Welcome to QuickStart - Creating Documents and Templates.mp4

04:14

7. Updates Reminder Update Your Office to Get The Latest.mp4

02:28

8. Creating New Sheets and Finding the Right Template.mp4

04:18

9. Learn How to Open Your Recent Documents.mp4

04:19

10. A Minor Check-Up on Your Account - Learn to Update and Manage Settings in Excel.mp4

03:23

11. Microsoft Excel Interface- Get to Know Excels Environment Better.mp4

09:13

2. File Menu - Learn to Manage Documents in Microsoft Excel

1. Diving Deep into How to Open, Create Sheets, and Templates.mp4

05:20

2. Learning to View All Information About Your Document.mp4

03:47

3. Uploading and Sharing Documents in Excel Easily.mp4

04:46

4. How to Protect a Workbook with Read-Only Mode and Password.mp4

03:18

5. Inspecting a Document for Issues to Ensure Better Accessibility and Compatibilit.mp4

02:46

6. How to View Excel File Version History and Restore Previous Versions.mp4

01:40

7. Checking In and Out to Avoid Errors and Unwanted Editing.mp4

03:39

8. How to Change Browser View Options If You Shared the Excel File.mp4

01:09

9. File Saving Management- How to Save and Use Save As.mp4

05:26

10. Print Options and How To Print Effectively.mp4

07:42

11. How to Efficiently Save as PDF in Excel.mp4

03:47

3. Home Menu- Learn to Make Your Documents Stand Out

1. Clipboard in Excel - Learn to Copy and Paste Like a Pro.mp4

13:51

2. Font - Make Your Cells Readable by Adding Color and Border.mp4

09:51

3. Alignments and Merge - Better Align Your Text with Excel.mp4

06:59

4. Number Formatting in Excel- Make Each Cell Special.mp4

07:02

5. Style - How to Style and Format the Workbook.mp4

15:40

6. Cell Management - Learn to Insert, Delete, and Format Cells.mp4

09:32

7. Quick Editing Tools - From Clear Formatting to Sorting.mp4

08:04

4. Insert Menu- Learn to Insert Pictures, Charts, and Tables

1. Table Options - Learn to Create Simple and Pivot Tables Part 01.mp4

27:30

2. Table Options - Learn to Create Simple and Pivot Tables Part 02.mp4

10:12

3. Illustrations - How to Insert Pictures, SmartArt, and More Part 01.mp4

14:55

4. Illustrations - How to Insert Pictures, SmartArt, and More Part 02.mp4

11:49

5. Charts - Make Your Next Charts Look Professional.mp4

07:15

6. 3D Maps - How to Make Your Map Look Great.mp4

03:05

7. Pivot Chart on How to Present Date Easier.mp4

03:27

8. Filter and Links in Excel for More Accessible Data.mp4

02:22

9. Header and Footer for A Better Print of Excel.mp4

05:42

10. Text, Signature and Symbols in Excel.mp4

03:43

5. Draw Menu- A Menu That You May Need

1. Draw Menu- A Menu That You May Need.mp4

02:21

6. Page Layout - Learn How to Keep Your Page Well-Organized

1. Themes - How to Manage and Create a Better Theme for Your Workbook.mp4

03:08

2. Page Setup, Scale and Sheets Options in Excel.mp4

07:08

7. Formulas - Learn Basics to Advanced Formulas with Projects

1. Operational Math and Percentage in Excel Creating Invoice.mp4

26:15

2. Autosum in Excel- how To Use It Effectively.mp4

04:40

3. Home Expense Using Vlookup and If Error.mp4

27:16

4. Date and Time Formulas.mp4

07:55

5. Timeline Project with Days360.mp4

05:04

6. Progress Percentage with Counta.mp4

02:46

7. Student Assignment Tracker with If and Average.mp4

18:10

8. Countif with Student Attendance.mp4

16:58

8. Data - Learn to Enrich Your Data

1. Data - Learn to Enrich Your Data.mp4

07:18

9. Review Learn About Your Sheets Issues Before Publishing

1. Review Learn About Your Sheets Issues Before Publishing.mp4

05:19

10. View - How to Enhance the Viewing Experience

1. View - How to Enhance the Viewing Experience.mp4

04:45

11. Conclusion

1. How to Download Your Certificate of Completion.mp4

00:43

Description

Unlocking Excel Mastery: From Basics to Advanced Techniques

What You'll Learn?

Master Excel Fundamentals and Advanced Features
Efficient Document Management
Data Visualization and Presentation
Problem Solving and Decision Making

Who is this for?

Beginners who are new to Excel and want to learn the basics

Intermediate users looking to enhance their skills with more advanced functions

Professionals across various fields needing Excel for data analysis and reporting

Students and academics who use Excel for research and assignments

Entrepreneurs and business owners who manage finances and strategic planning with Excel

Job seekers looking to increase their employability by mastering a key office tool

What You Need to Know?

No prerequisite!

Willing to learn Excel!

More details

Description
Microsoft 365 offers a suite of applications, with Excel standing out as particularly noteworthy. The trio of Microsoft Word, Excel, and PowerPoint are essential tools for accomplishing tasks and simplifying your life. Microsoft Word goes beyond just text, and Excel transcends mere tables; these applications are designed to assist with both personal and business purposes. These applications are super handy for everyday life.
In this course, we will learn everything from the basics to more advanced topics. It's important to have a foundation in these skills before diving in. Then we will tackle some advanced stuff including functions and formula.
We are going to learn that Excel isn't only for those who love numbers or work in accounting. Itâ€™s widely used across various industries such as finance, marketing, and human resources, making knowledge of Excel a valuable asset in any field.
For those who enjoy working with numbers, Excel is a perfect fit. It offers advanced functions and features that enable you to perform complex calculations, analyze trends, and produce compelling reports. Your skills in Excel can help you stand out in your workplace.
Moreover, Excel is a powerful tool for problem-solving and decision-making. You can manipulate data, project future trends, and explore different outcomes, almost like a form of forecasting.
Learning Excel is an investment in your professional growth, opening doors to new opportunities and giving you a competitive edge. Employers value proficiency in Excel, which can enhance your prospects for landing your dream job or advancing in your career.
For entrepreneurs or business owners, Excel is indispensable. It allows for effective management of finances, market analysis, and strategic business planning, acting as a crucial tool for success.
Finally, mastering Excel does more than just improve your software skills; it enhances your ability to think logically, solve problems, and make data-driven decisions. It also prepares you for learning other advanced tools in the future.
In "The Complete Microsoft Excel Masterclass," students will learn on a comprehensive journey through Microsoft Excel, starting from the basics and progressing to advanced functionalities. Hereâ€™s a breakdown of what they will learn:
Course Setup and Introduction: Welcomes students with an overview and learning outcomes, system setup instructions, access to a supportive Facebook community, and direct contact with an instructor for ongoing queries.
Basic Excel Operations: Covers the essentials of using Excel effectively, from installation and launching to creating templates and managing document settings. Updates and account management are also addressed to ensure optimal use.
Document Management: Teaches comprehensive document handling in Excel, including opening, creating, sharing, and securing files, along with learning how to manage version histories and recovery options.
Enhancing Document Presentation: Focuses on the visual and functional enhancement of Excel documents, utilizing formatting tools from the Home menu and advanced features like charts and tables from the Insert menu.
Advanced Formatting and Data Management: Delve into the Home menu for clipboard functions, complex cell formatting, and quick editing tools, while the Insert menu introduces professional charting, 3D maps, and data presentation techniques.
Formulas and Data Handling: Introduces a wide range of formulasâ€”from basic operations to advanced functions like VLOOKUP and logical testsâ€”applied through project-based learning to real-world scenarios.
Course Completion and Further Learning: Concludes with a comprehensive recap, a final project to apply what's been learned, and offers resources for continued learning and certification, ensuring students are well-prepared for practical Excel use and further advancement.
What are you waiting for! Join me now!Â
Who this course is for:
Beginners who are new to Excel and want to learn the basics
Intermediate users looking to enhance their skills with more advanced functions
Professionals across various fields needing Excel for data analysis and reporting
Students and academics who use Excel for research and assignments
Entrepreneurs and business owners who manage finances and strategic planning with Excel
Job seekers looking to increase their employability by mastering a key office tool

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Media Training Worldwide Digital

Instructor's Courses

Media Training Worldwide Digital is a full-service online training firm specializing in video on-demand courses. We publish courses on all aspects of technology, business, personal development, communications, and the arts. Our top instructors include Best-selling experts such as Clarian North and TJ Walker. Media Training Worldwide Digital partners with the foremost experts in the world in order to deliver high-quality video-based learning experiences to students.

Jan Ekhteyari

Instructor's Courses

Jan has been a successful course/content creator since 2019, having produced many best-selling courses throughout his career. He is a highly professional and resourceful instructor and content creator who takes advantage of every opportunity to make a significant impact on people's lives.His courses have greatly simplified the learning of technical skills and languages for many individuals. He has a large student base of over 250,000 across all educational platforms. He has been teaching IT skills and language with the support of organizations like OXFAM, OHW, PI-AMI, MOVE, and NSEC for more than 2 years.In addition to his personal work, Jan collaborates closely with TJ Walker, a best-selling course creator who has produced over 200 courses and is the founder of Media Training Worldwide.Jan learned media training, public speaking, and presentation skills through Media Training Worldwide. As a result, he has been able to assist people in learning and speaking English confidently.Jan grew up without access to the internet and was unable to read the alphabet at the age of 14. However, he is now able to read fluently.During his school years, he became motivated to assist people remotely, and now he is thrilled to take his business to the next level and assist millions of people around the world. A friend posed a thought-provoking question that set him on the right path, for which he is very grateful to his friends. Good friends are always a valuable asset.Jan has proven to be very resilient and has shown on multiple occasions that he is an exceptional analytical individual and is able to handle any crisis, situation, and conflict.Right now, Jan is chasing his dream in Canada. It's important to note that his skills are self-taught. University provides him with the opportunity to invest more time and establish networks. Greetings from Jan!

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.