top of page

This site was designed with the

website builder. Create your website today.Start Now

EXCELLENT EXCEL TIPS

I started posting Excel tips on my Linkedin page in early October 2020, and as of the 16th my "Did you know"post took the form it holds till this day. You can find my posts on Facebook, Instagram and Linkedin, all of which you can access via the links in the right hand column of this website.

October 16, 2020 - Did you know that there is a Copy/Paste function for Conditional Formatting

October 20, 2020 - Did you know that Excel can tell you the date

October 21, 2020 - Did you know that Excel has a function called Flash Fill

October 22, 2020 - Did you know that Excel has more than just "equal to" (=)

October 23, 2020 - Did you know that you can use Conditional Formatting to find duplicates

October 26, 2020 - Did you know that Excel has a Datedif formula

October 27, 2020 - Did you know that Excel can sum you top/bottom three values from a range

October 28, 2020 - Did you know that Excel can grade values by using an IF formula

October 30, 2020 - Did you know that Excel can even allow you to nest IF within an IF formula

November 2, 2020 - Did you know that Excel can splice together text with Concatenate

November 3, 2020 - Did you know that Excel can splice together text and symbols with Concatenate

November 4, 2020 - Did you know that Excel lets you analyze text based on a sample set

November 5, 2020 - Did you know that Excel Conditional Formatting allows you to color empty cells

November 6, 2020 - Did you know that Excel has a great tool called Subtotals

November 9, 2020 - Did you know that Excel has a VBA code that lets you hide your formulas

November 10, 2020 - Did you know that Excel will let you color your charts however you want

November 11, 2020 - Did you know that Excel has an amazing tool called Slicers

November 12, 2020 - Did you know that Excel has 7 error messages, here they are

November 13, 2020 - Did you know that Excel has a formula called Cell that is super useful

November 16, 2020 - Did you know that this is day 1 of 5 with Excel Data Validation

November 17, 2020 - Did you know that this is day 2 of 5 with Excel Data Validation

November 18, 2020 - Did you know that this is day 3 of 5 with Excel Data Validation

November 19, 2020 - Did you know that this is day 4 of 5 with Excel Data Validation

November 20, 2020 - Did you know that this is day 5 of 5 with Excel Data Validation

November 23, 2020 - Did you know that this is day 1 of 5 with the Excel IF formula

November 24, 2020 - Did you know that this is day 2 of 5 with the Excel IF formula

November 25, 2020 - Did you know that this is day 3 of 5 with the Excel IF formula

November 26, 2020 - Did you know that this is day 4 of 5 with the Excel IF formula

November 27, 2020 - Did you know that this is day 5 of 5 with the Excel IF formula

November 30, 2020 - Did you know that Excel allows you to identify which days are holidays

December 1, 2020 - Did you know that this is day 1 of this years Excel Advent calendar

December 2, 2020 - Did you know that this is day 2 of this years Excel Advent calendar

December 3, 2020 - Did you know that this is day 3 of this years Excel Advent calendar

December 4, 2020 - Did you know that this is day 4 of this years Excel Advent calendar

December 5, 2020 - Did you know that this is day 5 of this years Excel Advent calendar

December 6, 2020 - Did you know that this is day 6 of this years Excel Advent calendar

December 7, 2020 - Did you know that this is day 7 of this years Excel Advent calendar

December 8, 2020 - Did you know that this is day 8 of this years Excel Advent calendar

December 9, 2020 - Did you know that this is day 9 of this years Excel Advent calendar

December 10, 2020 - Did you know that this is day 10 of this years Excel Advent calendar

December 11, 2020 - Did you know that this is day 11 of this years Excel Advent calendar

December 12, 2020 - Did you know that this is day 12 of this years Excel Advent calendar

December 13, 2020 - Did you know that this is day 13 of this years Excel Advent calendar

December 14, 2020 - Did you know that this is day 14 of this years Excel Advent calendar

December 15, 2020 - Did you know that this is day 15 of this years Excel Advent calendar

December 16, 2020 - Did you know that this is day 16 of this years Excel Advent calendar

December 17, 2020 - Did you know that this is day 17 of this years Excel Advent calendar

December 18, 2020 - Did you know that this is day 18 of this years Excel Advent calendar

December 19, 2020 - Did you know that this is day 19 of this years Excel Advent calendar

December 20, 2020 - Did you know that this is day 20 of this years Excel Advent calendar

December 21, 2020 - Did you know that this is day 21 of this years Excel Advent calendar

December 22, 2020 - Did you know that this is day 22 of this years Excel Advent calendar

December 23, 2020 - Did you know that this is day 23 of this years Excel Advent calendar

January 12, 2021 - Did you know that there is an Excel artist named Tatsuo Horiuchi

January 13, 2021 - Did you know that Excel allows you to autosize multiple columns

January 14, 2021 - Did you know that Excel allows to size multiple columns to the same width

January 15, 2021 - Did you know that Excel rows can be manipulated like their columns

January 18, 2021 - Did you know that Excel allows you to enter the same formula in multiple cells

January 19, 2021 - Did you know that Excel has something called Absolute References

January 20, 2021 - Did you know that Excel lets you show your formulas in a sheet

January 21, 2021 - Did you know that Excel and aesthetics go hand in hand

January 22, 2021 - Did you know that Excel allows you to freeze your top row

January 25, 2021 - Did you know that Excel allows you to freeze even more than your top row

January 26, 2021 - Did you know that Excel will keep headers at the top of your page in a Table

January 27, 2021 - Did you know that Excel has several great functions within the table header filter

January 28, 2021 - Did you know that Excel allows you to copy a screen print right to a Microsoft Clipboard

January 29, 2021 - Did you know that Excel has several special paste functions

February 1, 2021 - Did you know that Excel has SPARKLINES

February 2, 2021 - Did you know that Excel easily can Remove Duplicates

February 3, 2021 - Did you know that Excel can easily remove blank rows for you

February 4, 2021 - Did you know that Excel

February 5, 2021 - Did you know that Excel

October 2020

November 2020

December 2020

January 2021

February 2021

bottom of page