# Free Excel Course

### Introduction

‘Useful Excel for Beginners’ is a free on-demand video-based course tailored for beginners who are interested in learning Microsoft Excel.

This course is a series of 89 videos running for slightly more than 9.5 hours. You can watch the videos at your own schedule and pause/replay as you would like. The course covers the concepts and features that I believe will help you get started and become a functional user of Excel.

### Course Highlights

Highlights of the course

• 9.5 hours of videos covering all the key concepts and topics
• Tailored for those who have never used Excel before and beginner level users
• Easy to follow video demonstrations where all the operations are performed on screen
• Create report on a fictional book store’s employees’ monthly work hours and salaries
• Analyze product sales, customer and sales trends for the book store
• 25 most used functions covered with examples
• Important keyboard shortcuts highlighted
• Includes Conditional Formatting, PivotTables and Tables
• Downloadable exercise files so that you can easily follow the course

1. Introduction (7 m)
2. Basics of Excel (11 m)
3. Entering Data (2 h 45 m)
• Keyboard shortcuts
• Navigating in a worksheet
• Selecting Cells
• Number Formatting
• Inserting & Deleting
4. Formatting (37 m)
5. Editing (1 h 10 m)
• Auto Fill
• Cut, Copy, Paste
• Sort & Filter
• Find & Replace
6. Saving (10 m)
7. Viewing (7 m)
8. Calculations  (2 h 6 m)
• Formula
• 25 functions
• Errors
9. Visualizing  (1 h 20 m)
• Charts
• Conditional Formatting
• Illustrations
10. Analyzing (31 m)
• Pivot Tables
• Slicers
11. Tables (16 m)
12. Sharing (12 m)
• Saving and Sending
• Printing

## 58 thoughts on “Free Excel Course”

1. I need Excel POS that can determine profit per day, Weekly & even monthly.
That is you can input cost per item.

Dnomariba@gmail.com

1. Please see Retail Business Manager https://indzara.com/product/retail-business-manager-excel-template/ which can calculate profit by month. Thanks.

2. Many thanks to Your. I”m very happy to see your excel prog….

1. You are very welcome. Thanks for your feedback. Best wishes.

3. Great worksheets! Thanks!

1. Thank you for taking the time and providing feedback. Best wishes.

4. THAK U INDZARA

5. Hi,

The Inventory Template wae very helpful, I am also doing cash management in another sheet.

As we can see each product inventory status separately on dash board when we pass any entryin the sheet it automatically updates, similarly when any cash entry is pass i want that amount to be minus from the openeing balance of that customer reflecting the current balance on the dashboard likwise the individual product current inventory status.

what can i do ??

1. I am glad to know that the Excel template was helpful.

I am not following your scenario completely. Please email the file at indzara at gmail dot com and clarify your need. I will look into it. Thank you.

6. Really interest to know more in excel.

1. Thank you. This is the only course I offer. Best wishes.

7. Great template sets. My only regret is that I wanted to learn Excel from those but free templates seem to be write-protected and formulas hidden.
Can you briefly explain how the “automatic copy” works in indzara_Project_Planner_Basic_ET0030022010001 from the “Projects” Tbl_Project_List to the “Summary Report” Project’s Summary ?
Thank you.

1. Thanks for your feedback. All the free templates can be unlocked using the password indzara. Please let me know if there are questions. Thanks.

8. First of all Thank you very very much for school attendance register .
I try report card as well but the problem is that it count the marks in percentage what if it count the marks as no. and one more think that we have to reduce the obtained marks into 5 and another 5 is to be added by us then it will become 10 ………
actually we have to create a average of marks obtained.
So please guide me to cited above.

1. You are very welcome. I need to build the next version of Report Card template to address your questions. It is in my list to do, but I haven’t had a chance yet. I am sorry. As soon as I can find time, I will publish the next Report Card template. Thanks.

9. good

1. Thank you. Best wishes.

10. Dear thank you so much for making so nice application in excel sheet. i want to learn excel as you know but i don’t have studies materials so please help me i this area

1. You are welcome.

This course is ideal for beginners. All the videos are in the playlist above. They are uploaded to YouTube and can be accessed any time. I will post the exercise files here soon. For now, you can see them on Udemy. https://www.udemy.com/useful-excel-for-beginners/

I hope this helps.