The Microsoft Excel Bootcamp: Beginner to Advanced

Focused View

Rajat Sharma

6:45:21

0 View

1. Getting Started

1. Introduction.mp4

00:59

2.1 Lacture1.xlsx

2. Course Structure.mp4

05:49

3. Who this course is for.mp4

03:39

4. Demand and Market.mp4

02:13

2. MS Excel Fundamentals

1. Welcome to course.mp4

00:30

2. Launching Excel.mp4

02:19

3. Excel Interface.mp4

05:27

4. Basic Terminologies in Excel.mp4

04:32

5. Workbook Vs Worksheet.mp4

01:17

6. All about Font & Defaults.mp4

06:11

7. Data Range.mp4

05:45

8. Insert, delete rows and columns.mp4

02:17

9. Formatting.mp4

03:31

10. Format Painter.mp4

01:31

11. Paste Special.mp4

03:08

12. Sorting Data.mp4

04:05

13. Filtering Data.mp4

03:07

14. Use of right click options.mp4

03:44

15. Number Filters.mp4

03:31

3. Formatting

1. Formatting Data.mp4

03:42

2. General Formatting.mp4

04:27

3. Format Cells.mp4

06:10

4. Conditional Formatting P1.mp4

04:11

5. Conditional Formatting P2.mp4

06:14

4. Other Fundamentals

1. View Tab.mp4

06:41

2. Review Tab.mp4

06:08

3. Shortcut Keys.mp4

05:40

4. Excel VS CSV.mp4

02:12

5. Import Data Part1.mp4

05:16

6. Import Data Part2.mp4

04:49

7. Existing connections.mp4

02:56

8. Power Query.mp4

03:48

9. Advanced Filter.mp4

04:03

10. Text to column and remove duplicates.mp4

06:24

11. Data validation.mp4

07:33

12. Consolidated.mp4

04:39

13. Goal Seek.mp4

01:56

14. Data Table.mp4

03:39

15. Absolute vs Relative.mp4

04:12

16. Page Layout Tab.mp4

09:56

17. Insert Tab Intro.mp4

01:55

18. Illustrations.mp4

07:35

5. Formulas & Functions

1. Formula Tab.mp4

05:54

2. Logical Formulas.mp4

07:25

3. Auto Sum.mp4

06:13

4. Iferror.mp4

03:44

5. Text Formulas1.mp4

13:54

6. Text Formulas2.mp4

03:46

7. Date Functions.mp4

08:50

8. Lookup Functions.mp4

19:58

9. Math Functions.mp4

13:35

10. Defined Names.mp4

07:36

11. Vlookup Practice.mp4

11:24

12. Functions Practice1.mp4

12:23

13. Functions Practice2.mp4

09:04

14. Dynamic filter using Vlookup.mp4

06:20

6. Charts & Visualization

1. Charts Part1.mp4

08:27

2. Charts Part2.mp4

23:03

3. Charts Part3.mp4

07:27

4. Speedometer and Dynamic charts.mp4

17:14

7. Pivot Tables

1. Pivot Tables Basics1.mp4

12:32

2. Pivot Basic2.mp4

13:12

3. Dimension Field Options.mp4

11:05

4. Pivot Charts.mp4

04:34

Description

Become a top 10% Excel expert

What You'll Learn?

Learn Microsoft Excel from Beginner to Advanced
Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
Become a top 10% Excel power user to enhance your skillset and career opportunities
Build a solid understanding on the Basics of MS Excel
Automate, streamline, and completely revolutionize your workflow with Excel
Learn to use Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports
Learn all about: tables, charts, formatting, formulas and functions, macros, pivot tables/charts, and much more!
Master 75+ MS Excel formulas and learn data analysis with a top Microsoft Excel & business intelligence instructor

Who is this for?

Graduate students who aspire to become investment bankers, financial advisory professionals, consultants etc.

Anyone who works with Excel on a regular basis (even if you've never used a Pivot Table!)

Anyone looking to pursue a career in data analysis or business intelligence.

This Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA).

What You Need to Know?

No experience needed. You'll learn everything you need to know right from the beginning.

No need to start from scratch. Almost all tutorials have a premade spreadsheet/workbook for you to download and use.

More details

Description
Become a top 10% Excel power user to enhance your skillset and career opportunities.
Learn all about tables, charts, formatting, formulas and functions, pivot tables/charts, and much more!
Microsoft Excel all in One Package
Unlock the power of Excel with our comprehensive beginner's course designed to take you from novice to confident user. Whether you're a student, professional, or someone looking to boost your data management skills, this course offers a solid foundation in Excel's core functionalities.
What You'll Learn:
Excel Interface Navigation: Familiarize yourself with the Excel workspace, ribbons, and toolbars.
Basic Spreadsheet Functions: Learn how to create, save, and manage worksheets and workbooks.
Data Entry and Formatting: Master the art of entering data, formatting cells, and organizing your spreadsheets for clarity and efficiency.
Formulas and Functions: Understand the basics of creating and using formulas and functions to perform calculations and analyze data.
Data Visualization: Discover how to create and customize charts and graphs to present your data visually.
Data Management Tools: Get introduced to sorting, filtering, and using basic data validation techniques to ensure data accuracy.
Practical Tips and Shortcuts: Learn essential tips, tricks, and keyboard shortcuts to streamline your workflow and improve productivity.
Course Highlights:
Step-by-Step Tutorials: Detailed, easy-to-follow instructions for each lesson, designed to build your skills progressively.
Hands-On Practice: Real-world exercises and projects to reinforce your learning and give you practical experience.
Interactive Learning: Engage with quizzes and assignments to test your knowledge and track your progress.
Expert Support: Access to our experienced instructors for guidance and answers to your questions.
Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel.
As a Microsoft Excel Trainer, I will use my 5+ years of Excel to guide you step by step through the beginner to advanced level and beyond.
Who this course is for:
Graduate students who aspire to become investment bankers, financial advisory professionals, consultants etc.
Anyone who works with Excel on a regular basis (even if you've never used a Pivot Table!)
Anyone looking to pursue a career in data analysis or business intelligence.
This Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA).

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Rajat Sharma

Instructor's Courses

I am a technical graduate with 4+ years of professional experience in the analytics domain. I have worked across Marketing analytics, Digital analytics, Banking Credit Risk domain, Credit Card, and hands-on with Risk Reporting, Visualization, and Automation field. Looking forward to help learners/Student/Beginners for better skill selections with my experience. Please refer to my course for:- Data analysis- Excel skill - Data analytics using Python

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.