#Office365Challenge HLOOKUPS are used to retrieve data from other tables or ranges horizontally. A common field is needed to match and return stated values. Day: 164 of 365, 201 left Tools: Microsoft Office Excel Description: Using HLOOKUP in Excel In... Continue Reading →
#Office365Challenge VLOOKUPS are used to retrieve data from other tables or ranges by row. A common field is needed to match and return stated values. Day: 163 of 365, 202 left Tools: Microsoft Office Excel Description: Using VLOOKUP in Excel... Continue Reading →
#Office365Challenge The next couple of posts will be all about the various functions available in Excel to help you clean data you've received from other sources etc. Today we'll take a look at using TRIM to remove unnecessary spaces. Day:... Continue Reading →
#Office365Challenge The next couple of posts will be all about the various functions available in Excel to help you clean data you've received from other sources etc. Today we'll take a look at the Left, Mid and Right Function with... Continue Reading →
#Office365Challenge The next couple of posts will be all about the various functions available in Excel to help you clean data you've received from other sources etc. Today we'll take a look at the Left, Mid and Right Function which... Continue Reading →
#Office365Challenge The next couple of posts will be all about the various functions available in Excel to help you clean data you've received from other sources etc. Today we'll take a look at the Concatenate Formula. Day: 159 of 365,... Continue Reading →
Tracy van der Schyff 