Excel Training Series 101d: Working with Excel Table 2 (Name Ranges & Da...



Ensure you see the Part 1, Part 2 and Part 3 of these Series before you see this Video (Part 4)

This is a Video Tutorial on basic Excel Tips. This is the part tree of our Excel Training Series. Most of our Videos are on how to use our Excel Templates. But we have realized that some of our users can't use all the functions of our Templates and so we decided to explain some basic stuff on Excel to enable Users use our Templates and other Excel Templates better.

Feel Free to ask any questions and be kind enough to LIKE this Video and also SHARE to your Colleagues and Associates. You will be surprised that a lot of people still find it difficult performing some basic, simple and routine tasks on Excel. Ensure that you see the entire Videos in this 101 Series.

After seeing this Part 4 Video you should be able to;

1. Calculate a Data Set outside the Excel Table

2. Calculate a Data Set Outside the Excel Table in another Worksheet
3. Using Name Ranges in an Excel Table
4. Using Data Validation in an Excel Table


The main objective of this series is to enable you analyze a data set efficiently on Excel. You can work along with us as we process in this Series.

Get the Raw Data Excel File from this link; http://www.theaccountsolutions.com/p/.... Download this file and join us in the training. Watch out for the Part 5 of this Excel Training series.

Enjoy and Cheers!

Comments