Microsoft Excel Functions, Formulas, Analysis, & Dashboards
- Description
- Curriculum
- FAQ
- Reviews
If your work requires working with numbers or large amounts of data, Microsoft Excel is your software.
Microsoft Excel is one of the most powerful data management and data analysis tool.
This course enables students to start using Excel in an effective manner. It starts from the very basics and within a few minutes, you will be having a good command over basic excel functions and even some advanced and frequently used features.
About this course:
Designed to teach Microsoft Excel to absolute beginners, this course will take you from scratch to a level where you can effectively store, manage, clean, transform, consolidate, analyze, and visualize data.
Prerequisites:
There is absolutely no prerequisite to start this course. Even 8 years old can take this course to learn Excel.
Who should take this course:
First-time learners, who have no idea about Excel and want to start the right way. This includes:
-
Students
-
Professionals, especially those who have to work with numbers.
-
Daydreamers who wish to bring financial sense to their dreams.
-
Anyone who wants to learn a better way to manage the numbers and calculations.
Software Requirement:
You should have Microsoft Excel installed on your computer. Any version above Excel 2010 will be okay. I will be using Excel 2016 in this course. If you do not have Excel currently, please download Office 365 free trial from the Microsoft website. Just google Office 365 free trial and it will take you to the page.
Money-Back Guarantee:
Nothing to lose! If you won’t be satisfied with the course, Udemy offers 30 days money-back guarantee!
Introduction to the teacher:
Chartered Accountant | 12 years of work experience | 12 years of teaching experience as visiting faculty | 4000+ in-class students | 100,000+ Udemy students | In love with Excel for 15 years
-
1Introduction to Spreadsheet, Cell, Column and RowVideo lesson
-
2Learning keyboard shortcuts to navigatge in a sheet, to add columns and rowsVideo lesson
-
3Understanding cell formatVideo lesson
-
4AutofillVideo lesson
-
5Basic Mathamatical functionsVideo lesson
-
6Practice on real dataVideo lesson
-
22Manipulating dates - Date | Month | YearVideo lesson
-
23Manipulate dates - Name of the Day | Name of the MonthVideo lesson
-
24Manipulating dates - Day of the week | Week of the yearVideo lesson
-
25Day of the YearVideo lesson
-
26Quarter of the YearVideo lesson
-
27Dynamic TODAY | Tomorrow | YesterdayVideo lesson
-
28Calculating AgeVideo lesson
-
29Adding conditional columns based on IFVideo lesson
-
30NESTED IFVideo lesson
-
31IF ORVideo lesson
-
32IF OR Multiple ColumnVideo lesson
-
33IF OR OR OR PracticeVideo lesson
-
34IF ANDVideo lesson
-
35IF AND AND AND PracticeVideo lesson
-
44Introduction to Data Analaysis and DataVideo lesson
-
45Summay by a parameterVideo lesson
-
46Adding parameters with drill down and drill upVideo lesson
-
47Breaking down information by ColumnVideo lesson
-
48Filtering the data in reportsVideo lesson
-
49Understanding Value Field SettingsVideo lesson
-
50Working with Dates in rowsVideo lesson
-
51Grouping exampleVideo lesson
-
52Compiling data on one sheetVideo lesson
-
53SlicersVideo lesson
-
54TimelineVideo lesson

External Links May Contain Affiliate Links read more