What you’ll learn
Learn the basics of Microsoft Excel including date arithmetic, looking up of data, sorting and filtering data.
Learn formatting the data beautifully with Microsoft Excel, including conditional formatting and cell styles.
Learn to use Excel in office environment for productivity and be noticed taking this course.
Learn the basic skills of Excel just spending a week on this three hours plus course and be proud of your Excel skills.
Learn how to make beautiful and well meaning Excel Chart, presenting actionable information.
Learn the basics of Microsoft Excel to eventually take advanced courses on Excel step by step.
There is no pre-requisite for this course, except that one should understand the language of instruction, which is English.
No previous experience in Excel is needed, you shall everything from the beginning step by step. Only requirement is you should not skip any step.
Free of unnecessary expansion and dramatization, this course gives you knowledge on the core functionality of Excel. If you are a new bee to Excel, this course is just for you.
After taking the course you shall be learning :
(a) Excel Environment ,
(b) Excel Short-cut Keys ,
(c) Naming of a Cell or Range of Cells,
(d) Absolute reference and relative reference ,
(e) Formatting of a Cell or a range of cells
(f) Excel Formatting tips for aesthetic presentation
(g) Excel Operators,
(h) Date arithmetic with Excel,
(i) Working with Excel tables,
(j) Auditing an Excel Spreadsheet,
(k) Sorting and Sub-totaling of Data,
(l) Excel functions, mostly used functions only
(m) Virtual lookup and nested if
(n) Circular reference
(o) 4 levels of protection in Excel
(p) Excel data validation
(q) Picture Graphs
(r) Other powerful graphs
There is a large downloadable Excel file associated with it, and can be used for practice.
If you are new bee you must first download the file and visit all the worksheets.
You should be able to connect the topics with the name of the worksheet intuitively.
Then you start taking the lesson keeping the Excel file opened in another tab.
This way you can learn the most.
Other exercises are also provided.
If you cannot understand a particular part revisit the lesson video again and then check it with the downloaded file.
The more you spread a spreadsheet, the better.
View it in full screen mode in Desktop, Laptop, Ipad or tablets.
Small screen mobile phones are not very good to view this course.
Happy learning !
Who this course is for:
- All Microsoft Excel enthusiast are the target of this course. They can be students, interns, clerks or a person from the management cadre. Many persons, otherwise very successful in life, also want to learn Excel at some point of time in their mid-life. The course is also for them. This course is also for housewives who are feeling left out and technically challenged. Slow but sequential and systemic following of this course can turn one from Zero to hero in Excel. This course is free and has no expiry as per Udemy standard. So no hurry, if required replay a lesson again to get into the depth of it. Also do not forget to download the accompanying Excel spreadsheet.
- Later on they can learn advanced Excel courses and be expert in a specific area, say Statistics in Excel, Operations Research in Excel or Stock Analysis in Excel.
- This course is priced at a lowest-most level, so that everyone can take it, even when Udemy discounts are not run.