Pro Mastering Advanced Excel - Formulas, Functions & Charts

Focused View

Monir E.Y,Mina Vosoughi

1:18:45

13 View

1. Getting to know the Basics of Formula Writing

1. Formula & Function.mp4

05:01

2. Relative and Absolute Addressing with the sign ($).mp4

03:33

3. Familiarity with Common Errors in Formula Writing.mp4

03:54

2. Logical Functions

1. IF function.mp4

04:44

2. AND Function.mp4

03:34

3. OR Function.mp4

03:50

4. IF ERROR Function.mp4

02:58

3. Conditional Formatting

1. Highlight cells Rules.mp4

02:18

2. example.mp4

03:19

3. How to Remove Conditional Formats.mp4

00:54

4. Writing Formulas in Conditional Formatting.mp4

02:20

5. Adding a New Line.mp4

02:51

6. Gantt Chart.mp4

02:48

4. Text Function

1. LEFT, RIGHT, MID functions.mp4

03:50

2. LEN Function.mp4

01:45

3. CONCATENATE Function.mp4

02:50

4. REPLACE and SUBSTITUTE Functions.mp4

03:20

5. Examples of Textual Functions.mp4

03:53

6. REPT Function.mp4

04:29

7. REPT Function (Example).mp4

01:41

8. FIND Function.mp4

03:52

9. TEXT Function.mp4

02:49

10. VALUE Function.mp4

04:52

11. TRIM Function.mp4

03:20

Description

Mastering Microsoft Excel 2021: Step-by-Step Learning and Advanced Skills Bundle-Through Comprehensive and Real Examples

What You'll Learn?

Learn all about: Charts, Formatting, Formulas and Functions
Go from complete beginner to proficient Excel user within 4 hours of content
Acquire critical Excel knowledge within the first 2 hours of tutorials
Access to a Professional Trainer with 10+ years of Excel Training
Learning to combine functions is distinguishing feature of this course

Who is this for?

All those who have completed the introductory Excel course and want to become a professional Excel user .

What You Need to Know?

Microsoft Excel 2021 desktop version for windows installed and ready to use on your computer.

You have basic Microsoft Excel knowledge.

More details

Description
Welcome to the next level of Excel mastery! Building upon the foundations laid in introductory course, this advanced Excel program is for individuals possessing a solid understanding of Excel and designed to catapult your skills to professional heights swiftly and effectively. Whether you're a seasoned Excel user or have completed foundational course, this program empowers you to leapfrog to an advanced skill level.
This course delves deeper into the intricacies of Excel, Mastery of functions, formulas, and intricate data visualization techniques forms the core of this program. From complex nested functions to statistical analysis, this program unlocks the full potential of Excel' s capabilities.
Also In this course, we'll explore how in Excel can enhance your data analysis and automation capabilities. Throughout the course, we will use real and comprehensive examples to highlight the power and versatility of Excel functions. By the end of the course, you'll have a deep understanding of how to use functions to solve complex problems and simplify your workflow.
Note: I wanted to inform you that our course is undergoing modifications and updates on a weekly basis to enhance your learning experience. As a part of this process, I'm gradually uploading new course materials and expanding the teaching hours. Currently, only some parts of the course have been uploaded, but rest assured, more content will be added regularly. I'm dedicated to enriching the course content to provide you with the most comprehensive learning resources.
Thank you for your patience and understanding as we work towards making this learning journey even more beneficial for all of us. If you have any questions or need clarification, please don't hesitate to reach out.
In this course, all textual, logical, Math and Statistical and lookup functions will be taught to you. Functions including IF , IF ERROR, RIGHT, LEFT, REPT, VALUE, TRIM, SUMIF, COUNTIF, LOOKUP, VLOOKUP, SUBTOTAL, etc .You will also be taught how to draw, format and edit all types of graphs, including linear, bar, surface, circular, etc.
What sets this course apart is its comprehensive approach and dedication to taking learners from proficient users to Excel professionals. We don't just teach; we empower you to apply these skills confidently in your professional endeavors.
Join us on this exciting journey to unlock the power of Excel. Enroll in our course today and gain the skills and confidence to tackle any Excel task that comes your way!
"Any reproduction, scanning or copying of all or part of the contents of this course, even if the source is mentioned, without the written permission of the publisher is prohibited and will be prosecuted."

Who this course is for:
All those who have completed the introductory Excel course and want to become a professional Excel user .

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Monir E.Y

Instructor's Courses

Hello! I am an experienced IT Engineer with a passion for providing top-notch IT solutions. Passionate and dedicated, I am an experienced educator with a remarkable 10-year journey in teaching Microsoft courses and I have acquired a deep understanding of various IT systems and technologies. Throughout my career, I have successfully tackled complex IT challenges and implemented innovative solutions. My expertise spans areas such as network infrastructure, system administration, cybersecurity, and cloud computing. I firmly believe in the power of continuous learning and improvement and I have honed my skills and stayed up-to-date with the latest advancements in the field. Through my dynamic teaching methods, I guide students towards mastering Microsoft and IT courses, unleashing their potential, and opening doors to exciting career prospects. Join my courses and embark on a transformative learning experience that will equip you with the skills to stand out in today's competitive landscape

Mina Vosoughi

Instructor's Courses

Hello! I am an experienced IT Engineer with a passion for providing top-notch IT solutions. With over 10 years of experience in the industry and a strong background in teaching of Microsoft and IT courses, I have acquired a deep understanding of various IT systems and technologies.Throughout my career, I have successfully tackled complex IT challenges and implemented innovative solutions.My expertise spans areas such as network infrastructure, system administration, cybersecurity, and cloud computing.I firmly believe in the power of continuous learning and improvement. As a firm believer in the transformative power of technology, I have honed my skills to empower individuals with the knowledge and expertise needed to excel in the digital world and stayed up-to-date with the latest advancements in the field.Through my dynamic teaching methods, I guide students towards mastering Microsoft and IT courses, unleashing their potential, and opening doors to exciting career prospects.Join my courses and embark on a transformative learning experience that will equip you with the skills to stand out in today's competitive landscape.

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.