Microsoft excel course for beginner to advanced learners
MODULE 6 - PIVOT TABLE & EXCEL EXTRAS
Lesson 24 - Overview of Excel Pivot Table
The video covers the following topics:
- Introduction to Pivot Tables
- Creating a Pivot Table in Excel
- Formatting the Pivot Table
- Grouping data in an Excel Pivot table
- Calculated Field/Items in Pivot Table
- Pivot Table Slicers
- Pivot Charts
Pivot Tables are an excellent feature in Excel that allows you to quickly summarize large amounts of data with just a few clicks. Even if you are new to Excel, you can easily grasp the concept.
This video covers a lot about Pivot Tables. However, if you want to learn more, you can check out all the Pivot Table tutorials available.
The video is quite long, so if you want to dive deeper into any of the topics covered in the video, you can refer to the recommended articles section.
Lesson 25 - Protection in Excel
In this free Excel training video, I will be demonstrating how to protect and lock cells, worksheets, and workbooks in Excel.
The following topics will be covered in the video:
- Introduction to protecting cells, worksheets, and workbooks
- Locking cells in Excel
- Protecting worksheets and workbooks in Excel with and without passwords
- Security vulnerabilities in Excel's built-in protection
Lesson 26 - Introduction to Macros and VB Editor
In this free Excel training video, I will introduce you to Excel macros and the Visual Basic (VB) Editor in Excel.
With macros, you can automate many tasks in Excel without the need for coding or VBA knowledge. By recording a macro, Excel generates a code that follows your actions, which you can then run to automate repetitive tasks.
If you're new to VBA, recording a macro and examining the code it generates can be a useful way to learn.
This video covers the following macro-related topics:
- How to record a macro in Excel
- Absolute and relative cell references in macro recording
- Introduction to the Visual Basic Editor in Excel.
Congratulations on successfully completing the Excel course! Your hard work and dedication have paid off, and now you have a valuable skill set that will benefit you in many areas of your life. Keep up the good work!