Mastering Microsoft Excel: From Basics to Advanced Technique

Focused View

Anand Mishra

4:01:01

0 View

1. Introduction To Excel

1. What Is Excel What Are The Advantages Of Excel.mp4

03:19

2. Introduction To Excel Interface (MS Excel 2019).mp4

04:32

2. The Building Blocks Of Spreadsheets

1. What Are Rows, Columns And Cells.mp4

05:35

2. Editing Data In Cells.mp4

02:25

3. Customize The Quick Access Toolbar And Ribbon.mp4

02:23

4. Freeze Worksheet Rows And Columns, Change Views And Orientation.mp4

04:53

5. Navigate Within The Workbooks.mp4

03:38

3. Editing Data In Microsoft Excel

1. Manipulate Data In Worksheets.mp4

04:23

2. Working With Different Types Of Data.mp4

01:11

3. What Are Lists Features Of Lists.mp4

06:29

4. Create, Format And Modify Tables Database Functions.mp4

03:12

5. Database Functions.mp4

05:11

4. Perform Operations By Using Formulas And Functions

1. Structure Of A Function.mp4

16:55

2. Inbuilt Functions And Logical Operations Using Formulas.mp4

17:48

3. Troubleshoot Formulas.mp4

10:03

5. Formatting And Validating Data

1. Cell Aesthetics.mp4

05:01

2. ormat And Validate Data (Data Validation).mp4

04:43

6. Creating Visualization

1. Create Charts.mp4

2. Modifying Advanced Charts.mp4

08:13

7. PivotTables And PivotCharts

1. PivotTables In Excel.mp4

10:22

2. PivotCharts In Excel.mp4

06:58

8. LOOKUP Function

1. LOOKUP() And VLOOKUP() Function.mp4

15:07

2. HLOOKUP() Function.mp4

08:58

3. INDEX(), MATCH().mp4

18:14

9. Macros

1. Macros In Excel.mp4

07:34

10. Visual Basic For Application In Excel

1. Introduction To Visual Basic For Application.mp4

09:17

2. Conditional Statements And Loops In VBA.mp4

21:38

11. Creating Dashboards

1. Creating An Excel Dashboard.mp4

32:59

Description

Unlock the Full Potential of Excel: From Fundamental Skills to Advanced Data Analysis and Visualization

What You'll Learn?

Understand the fundamental features and functionalities of Microsoft Excel, including navigating the interface, entering data, and basic formatting.
Learn how to use advanced Excel functions such as VLOOKUP, HLOOKUP, INDEX, MATCH, and advanced charting techniques.
Develop skills in creating compelling charts and graphs, using pivot tables, and implementing conditional formatting to visualize data effectively.
Gain proficiency in recording and editing macros, and writing basic VBA code to automate repetitive tasks in Excel
Learn to manage large datasets, use advanced sorting and filtering techniques, and employ data validation to maintain data integrity.
Build and understand financial models using Excel, including budgeting, forecasting, and performing sensitivity analysis.
Explore how to use Excel for business intelligence, including connecting to external data sources and using Power Query for data manipulation.

Who is this for?

Anyone Interested in Data Analysis and Visualization: Individuals who want to leverage Excel for more advanced data analysis and visualization tasks

What You Need to Know?

Basic computer skills, including familiarity with operating a computer and using common software applications.

A working installation of Microsoft Excel (preferably the latest version) to practice and apply the techniques learned in the course.

No prior experience with Excel is required, as the course will start from the basics and progress to advanced topics.

More details

Description
Mastering Microsoft Excel: From Basics to Advanced Techniques is a comprehensive course designed to equip you with the essential skills and advanced capabilities needed to become an Excel expert. Whether you are a beginner looking to get started with Excel or an intermediate user aiming to enhance your proficiency, this course covers it all.
In this course, you will begin with an introduction to Excel, learning about its advantages and navigating the Excel interface (MS Excel 2019). You will then move on to understanding the building blocks of spreadsheets, including rows, columns, and cells, as well as editing data and customizing the Quick Access Toolbar and Ribbon.
We delve into editing data, manipulating worksheets, and working with various data types. You'll explore lists, tables, and database functions, learning how to create, format, and modify them.
The course also focuses on performing operations using formulas and functions, troubleshooting formulas, and understanding the structure of functions. You will learn to format and validate data, create and modify advanced charts, and develop skills in data visualization.
Additionally, you will master PivotTables and PivotCharts, crucial for data analysis. Advanced topics include using lookup functions (LOOKUP, VLOOKUP, HLOOKUP, INDEX, MATCH), working with macros, and an introduction to Visual Basic for Applications (VBA) to automate tasks.
Finally, you will learn how to create dynamic Excel dashboards, bringing together all your skills to present data effectively and make informed decisions.
Who this course is for:
Anyone Interested in Data Analysis and Visualization: Individuals who want to leverage Excel for more advanced data analysis and visualization tasks

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Anand Mishra

Instructor's Courses

Hello there! I'm an entrepreneur with a passion for innovation and a track record of transforming ideas into successful ventures. My journey in entrepreneurship has been a thrilling ride, with each startup presenting its own unique challenges and rewards.My first venture, 'SmartSpeaky', was born out of a desire to connect people through language learning. I recognized the power of communication in bridging cultural gaps and created a platform that enabled people from all walks of life to learn languages together.Next came 'WorkerHub', a platform that revolutionized the labor market by connecting laborers to companies through CSC. This venture was a testament to my commitment to empowering the workforce and optimizing the labor market.My latest venture, 'BabyCloud', is perhaps the most personal. Launched just six months ago, it's already valued at $5M. As a platform designed to support new parents, BabyCloud reflects my ability to identify and address new market needs.Throughout my entrepreneurial journey, I've learned that success comes from a combination of innovative thinking, relentless drive, and a deep understanding of societal needs. I'm excited to share my experiences and insights with you, and I hope to inspire and empower you on your own journey.

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.