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
English [Auto-generated]
Current price: $10 Original price: $100 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • Download Microsoft Excel onto your PC
Description

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
03:18:40
+
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
05:27

Importing Data from Text File in Microsoft Excel
08:51

Importing Data from MySQL Database in Microsoft Excel
03:49

Sorting Columns in Microsoft Excel
07:10

Setting Filters in Microsoft Excel
04:33

Text to Columns in Microsoft Excel
04:57

Data Validation in Microsoft Excel
03:19

Grouping and Ungrouping in Microsoft Excel
03:21

Subtotals in Microsoft Excel
04:47

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

Shortcuts for Moving Around in Workbook and for Selecting Data in Micrsoft Excel
07:59

Sizing Columns and Rows in Microsoft Excel
05:26

Formatting Tables in Microsoft Excel
07:14

Creating Borders Around Data in Microsoft Excel
05:50

Formatting Cells in Microsoft Excel
06:37

Conditional Formatting in Microsoft Excel
09:27

Headers and Footers in Microsoft Excel
05:41
+
Step 3: Applying Formulas on Data in Excel
8 Lectures 44:47
Basic Functions in Excel in Microsoft Excel
10:06

If-Else in Microsoft Excel
04:14

Nested If Statements in Microsoft Excel
03:13

Sum and Sumif Function in Microsoft Excel
08:09

Data Warehouse Calculator Application in Microsoft Excel
04:25

Count and Countif Function in Microsft Excel
04:02

Average and Average IF Functions
02:51

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

Adding Bar and Column Charts in Microsoft Excel
06:09

Formatting Bar Charts in Microsoft Excel
11:15

Adding Pie Charts in Microsoft Excel
02:22

Combo Charts in Microsoft Excel
03:08

Area-Magnitude Charts in Microsoft Excel
02:46

Creating Line Charts in Microsoft Excel
04:30
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.