Welcome to the Useful Excel for Beginners course.
In this course, you will learn the fundamentals of Excel and become an effective user. The target audience for the course are those who have never used Excel before and those who are beginner level users. You would need a copy of Microsoft Excel for Windows since you will be practicing along with the course. I use Excel 2010 for Windows in the videos but any version with Excel 2007 for Windows or later would work. Excel Versions prior to 2007 have a different user interface but concepts will apply.
As the course is targeting beginners, it has been developed to be very easy to follow. We will be working with data related to a book store in the exercises. The files are available for download and you can follow along the videos while practicing.
The course covers the topics that you would need to know, to become a functional user. You can download the Table of Contents document from Chapter 1, to see all the topics the course will address. The course has 89 videos and runs for 9.5 hours.
If there are any questions about the course, please e-mail at indzara at gmail.com
Questions on the material covered in Chapter 2: Basics of Excel.
QUESTIONS RELATED TO THE MATERIAL COVERED IN CHAPTER 3: ENTERING DATA
QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 4: FORMATTING
QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 5: EDITING
QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 6: SAVING
QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 8: CALCULATIONS
QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 9: VISUALIZING
QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 10: PIVOTTABLES
My background is in data mining and business analysis. I have worked in large corporations for more than 10 years. I have also led teams of data analysts and managers in large corporations, working on data analysis and reporting. I have more than 12 years of experience working with Microsoft Excel.
I like to share what I know about Excel and data mining. I strongly believe that Excel can be leveraged better at home and at work, to make smarter decisions. I hope this course can help those who are new to Excel, learn the basics and become effective users.
I am also building and sharing Excel templates that can help people do day to day tasks more efficiently. Please find them online on my site. There are also simple video tutorials on my YouTube channel.