Microsoft Excel - from Beginner to Advanced & VBA by IITian

Focused View

Vishal Srivastava

6:27:01

74 View

1. Introduction to Excel 2016

1. Starting Excel 2016.mp4

02:11

2. Excel 2016 user Interface.mp4

08:05

3. The Excel 2016 Backstage View.mp4

04:10

2. Working with Workbook and Worksheets

1.1 Data Files.zip

1.2 Mastering Excel 2016 with Assignments and Case Studies - paperback.pdf

1. Workbooks and Worksheets.mp4

02:46

2. Editing Worksheets.mp4

04:33

3. Entering Data.mp4

03:13

4. Naming Cell Range.mp4

02:28

5. Handling Worksheets.mp4

03:36

6. Assignments for the section.html

3. Introduction to Microsoft Excel Tables, Formulas and References

1. Introduction to Tables in Excel 2016.mp4

03:14

2. Excel 2016 Functions.mp4

04:49

3. Operators in Excel 2016.mp4

01:50

4. Cell Referencing in Microsoft Excel 2016.mp4

03:55

5. Using Paste Preview to Transpose Rows into Columns.mp4

02:49

6. Assignment for Section 3.html

4. Formatting Data in Excel 2016

1. Formatting Data in Excel 2016 - 1.mp4

04:48

2. Formatting Data in Excel 2016 - 2.mp4

03:19

3. Formatting Numbers in Excel 2016.mp4

06:08

4. Text Rotation and Other Formatting Techniques.mp4

04:07

5. Practice assignment for section 4.html

5. Managing Your Data in Excel 2016

1. Using Named Ranges and Sorting Data in Excel 2016.mp4

04:57

2. Filtering Data in Excel 2016 Worksheet.mp4

03:12

3. Using Comments to explain your data in Excel 2016.mp4

02:24

4. Finding and Replacing Data in your Worksheet.mp4

03:14

5. Tracking Changes to Your Worksheet in Excel 2016.mp4

05:01

6. Practice assignment for section 5.html

6. Formulas in Excel

1.1 MSE Chapter 6 Text Formulas Case Study.pdf

1. Text Formulas in Excel.mp4

01:44

2. Text Formulas Case Study Solution.mp4

08:16

3.1 MSE Chapter 6 Date and Time Formulas Case Study.pdf

3. Date and Time Formulas in Excel 2016.mp4

01:24

4. Date and Time Formulas in Excel 2016 - Case Study Solution.mp4

03:48

5.1 MSE Chapter 6 Logical Formulas Case Study.pdf

5. Logical Formulas in Excel 2016.mp4

01:49

6. Solution to Logical Formulas Case Study.mp4

05:16

7.1 MSE Chapter 6 Information Formulas Case Study.pdf

7. Information Formulas in Excel 2016 - Case Study.mp4

00:43

8. Information Formulas Case Study - Solution.mp4

06:10

9.1 MSE Chapter 6 Mathematical and Statistical Formulas.pdf

9. Mathematical Formulas Case Study.mp4

02:28

10. Mathematical Formulas Case Study - Solution.mp4

12:26

11.1 MSE Chapter 6 Statistical Formulas Case Study.pdf

11. Statistical Formulas Case Study.mp4

01:47

12. Statistical Formulas Case Study - Solution.mp4

09:47

13.1 MSE Chapter 6 Financial Formulas Case Study.pdf

13. Financial Formulas Case Study.mp4

02:57

14. Financial Formulas Case Study - Solution.mp4

05:23

15. Practice Assignment for Section 6.html

7. Inserting and Formatting Objects Some

1.1 MSE Chapter 7 Inserting Objects Case Study.pdf

1. Inserting Objects Case Study.mp4

01:03

2. Inserting Objects Case Study - Solution.mp4

04:55

3. Practice Assignment for Section 7.html

8. Lookup and Reference Functions

1. LOOKUP Functions.mp4

06:07

2. Transpose Function.mp4

02:53

3. Comparing Lists.mp4

05:21

4.1 MSE Chapter 8 Lookup and Reference Formulas Case Study.pdf

4. Lookup and Reference Formulas Case Study.mp4

01:25

5. Lookup and Reference Formulas Case Study - Solution.mp4

08:04

6. Assignment for Section 8.html

9. Advanced Excel Tables

1.1 MSE Chapter 9 Excel Tables Case Study.pdf

1. Excel Tables Case Study.mp4

01:00

2. Excel Table Case Study - Solution.mp4

09:06

3. Printing Excel Tables.mp4

01:53

4. Assignment for Section 9.html

10. Using Charts in Excel 2016

1.1 MSE Chapter 10 Charts Case Study.pdf

1. Charts Case Study.mp4

02:00

2. Column, Bar, Pie, Histogram and Treemaps - Solution.mp4

10:53

3. Line Charts and Sparklines - Solution.mp4

04:30

4. 3D Maps in Excel - Solution.mp4

06:05

5. Assignment for Section 10.html

11. Pivot Table

1.1 MSE Chapter 11 PivotTable Case Study.pdf

1. Pivot Table Case Study.mp4

01:09

2. Pivot Table Case Study Solution - Part 1.mp4

10:26

3. Pivot Table Case Study Solution - Part 2.mp4

04:45

4. Pivot Table Case Study Solution - Part 3.mp4

02:37

5. Assignment for Section 11.html

12. What If Analysis

1.1 MSE Chapter 12 What If Analysis Case Study.pdf

1. What If Analysis Case Study.mp4

01:56

2. What If Analysis Case Study - Solution.mp4

07:33

3. Assignment for Section 12.html

13. Data Analysis and Validation

1. Importing Data in Excel 2016.mp4

02:25

2. Formula Auditing in Excel.mp4

07:26

3. Converting Text to Columns.mp4

02:36

4. Using Power Pivot to Import Data in Excel 2016.mp4

04:56

5.1 MSE Chapter 13 Data Analysis and Validation Case Study.pdf

5. Data Analysis and Validation Case Study.mp4

01:29

6. Data Analysis and Validation Case Study Solution - 1.mp4

07:24

7. Data Analysis and Validation Case Study Solution - 2.mp4

01:56

8. Assignment for Section 13.html

14. Printing Excel Workbooks and Sheets

1.1 MSE Chapter 14 Printing.pdf

1. Printing Case Study.mp4

00:52

2. Printing Case Study Solution.mp4

07:33

3. Assignment for Section 14.html

15. Macros

1.1 MSE Chapter 15 Macros Case Study.pdf

1. Macros Case Study.mp4

00:48

2. Macros Case Study Solution.mp4

04:15

3. Assignment for Section 15.html

16. Managing Excel Files

1. Saving and Sharing Workbooks in Excel.mp4

04:40

2. Splitting A Worksheet.mp4

02:22

3. Protecting Workbook and Worksheets.mp4

05:03

17. Visual Basic for Applications (VBA)

1. Visual Basic For Applications.mp4

02:32

2. Procedures and Variables.mp4

04:28

3. Loops And Conditional Logic.mp4

04:19

18. VBA Case Study 1

1.1 mse chapter 17 vba case study1 solution.zip

1.2 MSE Chapter 17 VBA Case Study1.xlsx

1.3 VBA Case Study-1.pdf

1. Case Study Solution - Record the Macro.mp4

04:24

2. Case Study Solution - Understanding Macro.mp4

02:25

3. Case Study Solution - Editing the Macro.mp4

05:13

4. Case Study Solution - Worksheets Object.mp4

04:56

5. Case Study Solution - Accepting User Input while Your Macro is Running.mp4

05:09

19. VBA Case Study 2

1.1 VBA Case Study-2.pdf

1. Case Study Description.mp4

01:35

2. Case Study Solution - Creating a User Form.mp4

02:16

3. Case Study Solution - Adding Controls to Form.mp4

02:34

4. Case Study Solution - Editing Properties of Form Controls.mp4

03:57

5. Case Study Solution - Adding Items to A ComboBox.mp4

06:01

6. Case Study Solution - Change Event for ComboBox Control.mp4

02:40

7. Case Study Solution - Adding code to a CommandButton control.mp4

02:00

8. Case Study Solution - Setting TextBox Control Value.mp4

03:49

9.1 mse chapter 17 vba case study2 solution.zip

9. Case Study Solution - Adding Code to Open Event of Workbook.mp4

03:29

20. VBA Case Study 3

1.1 VBA Case Study-3.pdf

1. VBA Case Study 3 Description.mp4

02:34

2. Case Study Solution - Creating a Custom Excel Function.mp4

03:33

3. Case Study Solution - Adding Conditional Logic to Function.mp4

03:45

4. Case Study Solution - Adding Help to Custom User Function.mp4

02:35

5.1 mse chapter 17 vba case study3 solution.zip

5. Case Study Solution - Using Defined Function within Excel Worksheet.mp4

02:24

21. VBA Case Study 4

1.1 MSE Chapter 17 VBA Case Study4.xlsx

1.2 VBA Case Study-4.pdf

1. Case Study 4 Description.mp4

01:26

2. Case Study Solution - Automate the SUM Function for One Worksheet.mp4

07:20

3. Case Study Solution - Automate the SUM Function for all Worksheets.mp4

05:24

22. Practice assignment for VBA

1. Assignment for VBA.html

Description

Master Excel 2016, 2013 and 2010 - Formulas, Functions, Charts, LOOKUP, Pivot Table, What-If Analysis, Macros & VBA

What You'll Learn?

95 Lectures and 15 Assignments
6.5 Hours of Video. 27 Downloads
Text, Date, Logical, Math, Financial, Statistical Functions
Pivot Table, LookUp, INDEX, MATCH and SEARCH
Automation with Macros and VBA
Charts, Trendlines, 3D Map and Drawing Tools
BONUS - Excel Shortcuts and Function Keys
BONUS - Free Excel 2016 eBook worth $4.99
Practical Learning with Case Studies
All Data files, Assignments and Solutions
Microsoft Excel 2016 - Beginner to Advanced Course

Who is this for?

Sales, Marketing, Accounting, Finance and Other Professionals

Entrepreneurs and Business Owners

College Students

What You Need to Know?

If you know how to use a computer, you can learn Excel 2016

More details

Description
ONLY $11.99 or Rs.500 Today. Sign Up Before It Goes Back to $19.99 / Rs.1,280 Tomorrow.

This Microsoft Excel course includes 95 Lectures, 15 Assignments (with Solutions), Excel eBook worth $4.99, Data files, Instructor feedback on assignments, Lifetime course access and 100% money-back guarantee form Udemy
This Microsoft Excel course is recorded in Indian Voice.
Microsoft Excel - Excel from Beginner to Advanced & VBA is the most comprehensive Excel course on Udemy.
It comes with full set of course book, data files for exercises, case studies and solutions. This is the Microsoft Excel Bible that includes everything you need to know to become an Excel expert.Â
The course is recorded with Microsoft Excel 2016. I point out important differences from Excel 2013 whereever applicable.Â Whether you use Excel 2016 or Excel 2013, this course is all you need. In fact, most features should work in Excel 2010 as well.
You will learn everything you need to learn in Microsoft Excel, from basics to advanced features like Pivot Table, Charts, Sparklines, Macros,Â Workbook Management and VBA.
A unique feature of this course is the use of exercises and case studies to illustrate how to use Excel formulas, functions and features.Â Â
With this Microsoft Excel course, your Excel skills will go from starter to expert in just a few hours. Whether you want to learn Excel for business, work, or College, this is the right course for you.Â Â
This Microsoft Excel course has been used by thousands of people. It is licensed to multiple colleges, businesses and professional education companies in India, Malaysia and Dubai. Â Â
You will master the following Microsoft Excel features in this course:
Excel User Interface
Workbook and Worksheets
Excel Tables
Data Management
Excel Formulas & Functions â€“ Date, Financial, Information, Mathematical & Statistical and Text
Inserting and Formatting Objects
Lookup and Reference Functions
Charts, 3D Map and Sparklines
Pivot Table
What If Analysis, Data Analysis and Validation
Printing Excel Files
Macros
Managing Excel Files
Advanced VBA
BONUS CONTENT:
PDF with most common Excel 2016 keyboard shortcuts
Excel eBook worth $4.99
If you are from the following countries, you will especially love the Charts and Graphs section. I use Sachin Tendulkar's career stats to show you how to use different types of charts to analyze data.
India
England
Ausrtalia
SriLanka
South Africa
Pakistan
Bangladesh
New Zealand
West Indian Island Countries
Enroll now and start mastering Microsoft Excel. Go from an Excel Novice to Excel Expert in just a few hours!
Videos are recorded in Indian voice so people from India and other Asian countries can also follow it easily.

Who this course is for:
Sales, Marketing, Accounting, Finance and Other Professionals
Entrepreneurs and Business Owners
College Students

User Reviews

Rating

average 0

Total votes0

Focused display

Hi,I am a marketing and sales professional. I work as virtual CMO for growing SaaS and technology services companies. My primary focus is scaling up lead generation and sales using both digital and traditional channels. I have worked with top tier Management and IT Consulting firms as business consultant. I have advised Fortune 500 as well as startups in business operations, sales and marketing. I love teaching, especially digital marketing and sales. My courses are used by higher education institutes and professional training providers. I have conducted training programs for several businesses including running outsourced workshops for Fortune 500 companies. You can see my complete profile on LinkedIn.

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.