Microsoft Excel - Building Reports with Microsoft Excel
4.3 (12 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,303 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel - Building Reports with Microsoft Excel to your Wishlist.

Add to Wishlist

Microsoft Excel - Building Reports with Microsoft Excel

Learn Microsoft Excel Intelligence to Generate Data Reports: Compatible w/ Microsoft Excel 2013, Excel 2010, Excel 2007
4.3 (12 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,303 students enrolled
Created by Dhruv Bais
Last updated 9/2016
English [Auto-generated]
Current price: $10 Original price: $100 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 3.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn Microsoft Excel Step By Step
  • Get a head start in the complex Microsoft Excel functionality of modern day programming Excel Analysis
  • Obtain the opportunity to learn more complex Microsoft Excel Formulas at the end of the course
View Curriculum
  • Download Microsoft Excel onto your PC

You are interested in learning Microsoft Excel and getting into the wide realm of programming and intense Tech Entrepreneurship. You have probably wondered what is the most practical way of learning Microsoft Excel (which to be frank, gives you the key to ruling the technology industry

Since technology is changing every day, I have to learn something new every time. The best way that you can learn how to program is "to program".

Yet, nobody teaches in this manner and I suffer from the same pain when learning something new every time. Most courses are not designed Microsoft Excel to help you learn by example (immersion is the most potent way of learning in humans). Rather they bathe you with inapplicable information that you have to learn over and over again anyways.

This course is designed to cover all the basic concepts of Microsoft Excel and the syntax necessary for learning the advanced topics in Microsoft Excel. Microsoft Excel can open the door to working with data and basically everything else with the word “Data” attached to it

My job is to make this class a great and fun learning experience so that I can help you progress through your path to learning advanced Microsoft Excel (whether it be just programming logic...classes....backends (boring) or doing fun stuff like Sharing).

In this course, I will walk you though 5 steps of data analysis with Microsoft Excel. The first step is to import and clean data. Next, formulas are added to our data. We then produce visualizations which help us summarize our data. Finally we export our reports using either email or print.

Only a few videos per section are focused on information. I develop the rest of the details of the data structures and syntax through exercises that I walk you through in the course. There are 2-3 lectures on solving tough exercises on each subject so that you can understand not only the syntax and how to the program Microsoft Excel, but also what the crux of programming is in terms of how we solve problems programmtically and harness the POWER of Microsoft Excel.

There is no risk for you as a student in this course. I have put together a course that is not only worth your money, but also worth your time. This course encompasses the basics of Microsoft Excel functionality and I urge you to join me on this journey to learn how to dominate the data analysis world with the most powerful tool: Microsoft Excel.

Who is the target audience?
  • This course is suited for everyone interested in data analysis
  • No prior Microsoft Excel knowledge is neccessary
Students Who Viewed This Course Also Viewed
Curriculum For This Course
36 Lectures
Introduction to Microsoft Excel
3 Lectures 15:57
Step 1: Preparing Data for Analysis
10 Lectures 51:52
Importing Data from Web Page in Microsoft Excel

Importing Data from Text File in Microsoft Excel

Importing Data from MySQL Database in Microsoft Excel

Sorting Columns in Microsoft Excel

Setting Filters in Microsoft Excel

Text to Columns in Microsoft Excel

Data Validation in Microsoft Excel

Grouping and Ungrouping in Microsoft Excel

Subtotals in Microsoft Excel

Find and Replace in Microsoft Excel
Step 2: Formatting Data in Excel
8 Lectures 52:06
Themes in Microsoft Excel

Shortcuts for Moving Around in Workbook and for Selecting Data in Micrsoft Excel

Sizing Columns and Rows in Microsoft Excel

Formatting Tables in Microsoft Excel

Creating Borders Around Data in Microsoft Excel

Formatting Cells in Microsoft Excel

Conditional Formatting in Microsoft Excel

Headers and Footers in Microsoft Excel
Step 3: Applying Formulas on Data in Excel
8 Lectures 44:47
Basic Functions in Excel in Microsoft Excel

If-Else in Microsoft Excel

Nested If Statements in Microsoft Excel

Sum and Sumif Function in Microsoft Excel

Data Warehouse Calculator Application in Microsoft Excel

Count and Countif Function in Microsft Excel

Average and Average IF Functions

Array Functions in Excel - MINIF and MAXIF Code By Hand
Step 4: Creating Visualizations in Excel
7 Lectures 33:59
Setting Aggregations Table for Chart Creation in Microsoft Excel

Adding Bar and Column Charts in Microsoft Excel

Formatting Bar Charts in Microsoft Excel

Adding Pie Charts in Microsoft Excel

Combo Charts in Microsoft Excel

Area-Magnitude Charts in Microsoft Excel

Creating Line Charts in Microsoft Excel
About the Instructor
Dhruv Bais
4.2 Average rating
2,798 Reviews
42,255 Students
23 Courses
Master Programmer and Machine Learning Robot

Hi! I'm Dhruv Bais. I am a Machine Learning and SAP Expert. But you can call me a coding geek.

I started very early in my career with Java and Python and wanted to know what all tech capabilities I can acquire. I have come a long way (about 7 Programming Language units) and mastered Python, R, Java, SAP FICO, SAP HANA, SAP ABAP, and many other software tools that aid me in my work of creating backend Information Technology Solutions for my clients.

I'm passionate about teaching Coding and SAP and want to share my love for these topics with other students. I also work as a Freelance programmer and have lots of experience creating Financial algorithms, data dashboards, server backends, SAP Integrations, SAP supply chains, and lots of other fun things that use my IT skills.

You wouldn't believe how big the market for SAP consultants is. Sign up and find out for yourself how you can get on this trend before it is too late. I teach SAP Module courses like Materials Management (MM), Financial Accounting and Controlling (FICO), and Sales and Distribution (SD) to give you a functional base for how SAP is integrated and operated inside companies. You can use this knowledge as a stepping stone to learn more complex SAP technology as progress through the knowledge I provide through my courses. I genuinely believe this training is the best on the market and if you don't agree, I'll happily refund your money.

Sign up and join me in this amazing adventure today.