Microsoft Excel from Zero: Functions, Formulas & Shortcuts
What you'll learn
- Basics like cells, rows, and columns
- Adding/deleting rows and columns
- Cell formats
- Basic Mathematical functions
- Keyboard shortcuts
- Data cleaning
- Data analysis
- Learn everything you need to start working on Excel!
Requirements
- Microsoft Excel 2016, or any other version
Description
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
Who this course is for:
- Beginner level users of Excel who are looking for a solid foundation
- Students, business owners, entrepreneurs and professionals
- Students with Zero knowledge of Excel
Featured review
![Deepak Sharma](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
Course content
6 lectures • 34minLevel 1: Getting to know Excel
- Preview07:51
- Preview05:41
- Preview03:08
- 01:37Autofill
- 06:10Basic Mathamatical functions
- 09:57Practice on real data
6 lectures • 25minLevel 2: Cleaning data
5 lectures • 21minLevel 3: Transforming Data
4 lectures • 30minLevel 4: Compiling data
14 lectures • 53minLevel 5: Getting ready for Data Analysis
8 lectures • 34minLevel 6: Basic Data Analysis (Ad hoc Data Analysis)
11 lectures • 47minLevel 7: Data Analysis
6 lectures • 33minPreparing Dashboard
2 lectures • 7minKeyboard Shortcuts Masterclass
Instructor
- 4.3 Instructor Rating
- 3,959 Reviews
- 116,106 Students
- 4 Courses
Experienced finance professional with practical experience of teaching accountancy and finance.
I am Certified Chartered Accountant (ACCA-UK), with a rich experience of providing finance and accountancy services to large organizations of banking, FMCG and professional services sectors. I have worked as a Consultant at "PwC" and as Finance Manager at a FTSE 100 MNC. Now I am leading Accountancy Service of "Excelsious" where we provide Accountancy and Finance services to small and medium sized entities.
Throughout my career I have been associated with professional education as a visiting member of faculty at prestigious professional colleges and universities for ACCA, CA and MBA. Over this time, I have helped more than 4000 students successfully achieve their aspirations and professional education goals. I am really excited about the enhanced learning experience of teaching online and sharing my knowledge and expertise with a wider audience.