#Microsoft office 2016 video tutorials how to
#Microsoft office 2016 video tutorials 720p
#Microsoft office 2016 video tutorials code
#Microsoft office 2016 video tutorials download
#Microsoft office 2016 video tutorials free

Goddess Saraswathi has blessed you, may her blessings be showered upon you into the future, so we all get at least a part of those blessings.

Pranam to you, as a teacher who put in all this time into these video courses and offering it for free. I see lot of people asking for a pat in the back ( like looking for a certificate of completion ), this is a SELF-HELP course, and I am not sure I will have as much information given to me even if I attended a PAID COURSE.Īnd again, since I am learning this on my own to improve MY understanding of spreadsheet program, I can understand and appreciate why some persons want to squeeze a CERTIFICATE out of this as a ticket for a future job. The organisation, time, effort and passion has to be really appreciated.

#Microsoft office 2016 video tutorials free

Like air we breathe, Sunshine we enjoy, moonlight we adore, his free teachings are GOD’s gift to any body that want learn a new skill. With an average enthusiasm to learn, one can learn from these videos and lay a firm and solid foundation to one’s career, using this excellent program called Excel. SB has taken time, mastered the Excel, excited by its capabilities, organised it and prepared to teach his students in a simple and direct way. When it is a good, properly laid, will make one’s home sitting on a solid foundation. Meant to lay a firm and solid foundation to build upon.Įverybody builds their own home on a foundation. The courses offered and the way these are structured are

#Microsoft office 2016 video tutorials how to

How to Assign a Macro to a Button in Excel.For Next Loop in Excel VBA – A Beginner’s Guide with Examples.If Then Else Statement in Excel VBA (explained with examples).Excel VBA Loops – For Next, Do While, Do Until, For Each (with Examples).Understanding Excel VBA Data Types (Variables and Constants).Using Workbook Object in Excel VBA (Open, Close, Save, Set).Working with Worksheets using Excel VBA.

Working with Cells and Ranges in Excel VBA (Select, Copy, Move, Edit).Introduction to the Visual Basic Editor.This video lesson covers the following VBA topics:

#Microsoft office 2016 video tutorials code

If you’re a VBA beginner, recording a macro and understanding the code using it can be a great way to learn. Now you can run this code and Excel will automatically follow all the steps you showed it. When you record a macro, Excel simply follows whatever you do in the workbook and create a code for it. And the best part is that you don’t need to know any coding or VBA to do this. In this video, I will give you a quick introduction to Excel macros and the VB Editor in Excel.īy recording a macro in Excel, you can easily automate a lot of tasks.

Pivot Cache in Excel – What Is It and How to Best Use It.

How to Add and Use an Excel Pivot Table Calculated Field.

Using Slicers in Excel Pivot Table – A Beginner’s Guide.

How to Apply Conditional Formatting in a Pivot Table in Excel.

How to Group Numbers in Pivot Table in Excel.

How to Group Dates in Pivot Tables in Excel.

How to Filter Data in a Pivot Table in Excel.

Creating a Pivot Table in Excel – A Step by Step Tutorial.

This is a fairly long video, and if you want to deep dive into any of the topics covered in this video, have a look at the recommended articles section. In case you want to learn more, click here to check out all my Pivot Table tutorials. In this video, I try to cover a lot about the Pivot Table. Even if you’re using Excel for the first time, you can quickly get a hang of it. Pivot Tables are amazing as it allows you to quickly summarize a huge amount of data with a few clicks. In this video of this Free training, I will show you how to create and use Pivot Tables in Excel.

#Microsoft office 2016 video tutorials download

In case you find the videos useful and would like to support me, you can buy me a coffee ☕Ĭlick here to download the example Excel file In case you’re an intermediate or advanced user, feel free to pick the lessons you want to watch.Īlso, in case you have any questions or any feedback for me, kindly leave it in the comments area (at the bottom of this page).

#Microsoft office 2016 video tutorials 720p

NOTE: In case the video looks a bit blurry, you can change the video quality to 720p (by clicking on the settings gear icon on the bottom right of the video screen) I have also divided these into 7 modules. To make the most of this free training, please go through these Excel training videos in the sequence in which they have been listed. Just scroll down and start watching the videos to learn Excel. You don’t need to sign-up or do anything to get access to the course. This page gives you access to a completely FREE Online Excel Training (26 video lessons with 12+ hours of learning). If you’re an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start.