contexturesblog.com Open in urlscan Pro
2606:4700:3033::ac43:91d1  Public Scan

Form analysis
1 forms found in the DOM

GET https://contexturesblog.com/

<form role="search" method="get" class="search-form" action="https://contexturesblog.com/">
  <label>
    <span class="screen-reader-text">Search for:</span>
    <input type="search" class="search-field" placeholder="Search …" value="" name="s">
  </label>
  <button type="submit" class="search-submit"><span class="screen-reader-text">Search</span></button>
</form>

Text Content

Skip to content


CONTEXTURES BLOG

Excel tips and tutorials

Menu
 * Home
 * Aboutexpand child menu
   * Contact
   * Products
 * Excel Topicsexpand child menu
   * Start Here
   * Videos
 * Privacy




FUN WITH MICROSOFT EXCEL: STREAMING RADIO

Pro Tip – Don’t sign up for TikTok! It’s a giant carnival, filled with hypnotic
music, shiny objects, travelling medicine shows, and fortune tellers. You stop
in for 5 minutes, and stagger out hours later, dazed and confused. Sure, there’s
helpful info on TikTok too, but you’ll probably get sidetracked while you look
for it!

Continue reading “Fun With Microsoft Excel: Streaming Radio”

Author Debra DalgleishPosted on May 5, 2022May 14, 2022Categories Excel
tipsLeave a comment on Fun With Microsoft Excel: Streaming Radio


WARNING FOR HIDDEN ROWS AND COLUMNS IN EXCEL

You can hide rows and columns in Excel, and it’s usually easy to unhide those
rows or columns later. But, if you run into problems, these quick tips might
help you show those rows and columns again.

Continue reading “Warning for Hidden Rows and Columns in Excel”

Author Debra DalgleishPosted on April 21, 2022April 19, 2022Categories Excel
tips3 Comments on Warning for Hidden Rows and Columns in Excel


CALCULATE EASTER DATE WITH EXCEL FORMULA

Easter will be here soon, and if you want to know exactly (“eggsactly”?) when it
is, you can calculate Easter’s date with an Excel formula or User Defined
Function. See the example below, and there’s a sample file you can download too,
with several Easter formulas and functions. Oh, and there’s cake!

Continue reading “Calculate Easter Date with Excel Formula”

Author Debra DalgleishPosted on April 7, 2022April 4, 2022Categories Excel
FormulasLeave a comment on Calculate Easter Date with Excel Formula



EXCEL LINE CHART SHOWS TARGET RANGE FOR MONTHLY SALES

See how to create a simple Excel line chart for monthly sales data. Next, add a
target range in the chart, to show which months’ sales fall within that target
range.

Continue reading “Excel Line Chart Shows Target Range for Monthly Sales”

Author Debra DalgleishPosted on March 24, 2022March 23, 2022Categories Excel
charts3 Comments on Excel Line Chart Shows Target Range for Monthly Sales


HOW TO FILL BLANK CELLS IN EXCEL WITH VALUE FROM ABOVE

Some worksheets have blank cells in a column, instead of repeating the headings
in every row. That white space makes it easier to read the report, but will
cause problems if you need to sort or filter the data.

Here’s how you can fill in those blank cells, to avoid messing up your data.
Then, use an easy conditional formatting trick, to hide the duplicate headings.
Continue reading “How to Fill Blank Cells in Excel With Value from Above”

Author Debra DalgleishPosted on March 10, 2022March 8, 2022Categories Excel
tipsLeave a comment on How to Fill Blank Cells in Excel With Value from Above


EXCEL DATA ENTRY TIPS JUMP TO NEXT CELL OR PREVIOUS CELL

It’s been a long week, so here’s a quick Excel data entry tip for you. You’ll
see how to move through a set of data entry cells that are in different rows and
columns, quickly and easily.

Continue reading “Excel Data Entry Tips Jump to Next Cell or Previous Cell”

Author Debra DalgleishPosted on February 24, 2022February 24, 2022Categories
Excel tipsLeave a comment on Excel Data Entry Tips Jump to Next Cell or Previous
Cell



EXCEL WITH OLYMPIC ATHLETE DATA FOR WINTER FUN

Are you watching any of the 2022 Winter Olympics coverage? I hear the medal
count reports on the morning radio, but that’s about all I’ve seen!

Back in 2010, the Winter Olympics were in Vancouver, Canada, so we watched lots
of events that year. I downloaded some athlete bios that year, and had fun
turning that data into pivot tables.

Continue reading “Excel With Olympic Athlete Data for Winter Fun”

Author Debra DalgleishPosted on February 10, 2022February 10, 2022Categories
Pivot TableLeave a comment on Excel With Olympic Athlete Data for Winter Fun


FIND DATE OF NTH WEEKDAY IN MONTH WITH EXCEL FORMULA

Is it Thanksgiving yet? Or Family Day? Or any other holiday? Use an easy formula
to find out, with a couple of Excel date functions.

Continue reading “Find Date of Nth Weekday in Month with Excel Formula”

Author Debra DalgleishPosted on January 27, 2022January 22, 2022Categories Excel
FormulasLeave a comment on Find Date of Nth Weekday in Month with Excel Formula


FUN WITH A WORD CLOUD IN EXCEL

When people think about spreadsheets, they usually think of numbers, formulas
and calculations. But spreadsheets are great at organizing words too! Here are a
few of the functions you can use with text, and a fun word cloud tool to try.

Continue reading “Fun With a Word Cloud in Excel”

Author Debra DalgleishPosted on January 13, 2022January 9, 2022Categories Excel
FormulasLeave a comment on Fun With a Word Cloud in Excel



HOW TO FIX PROBLEMS WITH EXCEL DATES

Dates can be tricky in Excel, especially in December and January! In those
months, you often have to type the year too, because Excel defaults to the
current year. There are other Excel date problems too, like dates where you
can’t change the formatting, and dates for the GetPivotData function. Here’s a
quick look at dealing with those issues.

Continue reading “How to Fix Problems With Excel Dates”

Author Debra DalgleishPosted on January 6, 2022January 3, 2022Categories Excel
Formulas10 Comments on How to Fix Problems With Excel Dates


POSTS NAVIGATION

Page 1 Page 2 … Page 132 Next page
Search for: Search

 * Contextures Excel Tips
 * Debra's Blog
 * Pivot Table Blog
 * Spreadsheet Day Blog

As an Amazon Associate I earn from qualifying purchases


 * Home
 * Aboutexpand child menu
   * Contact
   * Products
 * Excel Topicsexpand child menu
   * Start Here
   * Videos
 * Privacy

Contextures Blog Proudly powered by WordPress

Update Privacy Preferences