Happy #formulafriday Excellers. Today we are going a little left of field, and looking at the really useful LEFT Function in Excel. This a a really useful function to have in your Excel toolbox which I use more than I thought I would over the years for manipulating and extracting data in my Excel worksheets. What Does The LEFT Function Do? The Excel LEFT Function extracts a given number of characters from the left side of a supplied text string. Here is quick … [Read more...]

## Formula Friday – Shhhhh…Want To Hide Your Excel Formulas?????….

Happy Friday Excellers, something a little different for today's #formulafriday blog. Instead of showing our Excel formulas I want to show you how to HIDE your Excel formulas. Sometimes you really don't want your hard working Excel formulas to be viewed, you maybe don't want your colleagues to know your Excel secrets or it maybe you don't want clients to know how you have calculated costs as they are based on a predicted sales figure?. So Let's Get Hiding Those Formulas! Hiding the … [Read more...]

## Formula Friday – Calculate How Many People Are Working At The Same Time using the COUNTIFS Function In Excel

Happy Friday and time for more #formulafun on #formulafriday and today we are going to look at a fun calculation that will show us how many people are working at one time in a retail store every hour, you could just as easily use this for a factory or some other place of work where you need to see how many people are working at any one time during the work shift hours. We base this on the clocking in and clocking out time (or scheduled shift times of workers) versus the time of day. Let's … [Read more...]

## Formula Friday – Use The SubTotal Function To Number Rows In An Excel Table.

by Barbara —4 Comments

Hello Excellers time for some handy #formulafriday tips. This week let's take a look at using the SUBTOTAL Function to easily number our rows in an Excel Table. You may want to number the rows within the table itself instead of relying on the rows numbers in Excel on the left of the screen, which may not always correspond to where your table is on your worksheet. This allows the table to be placed anywhere on the worksheet and your rows numbers will always be correct even if … [Read more...]

## Formula Friday – Full Marks! Calculating Weighted Exam Percentages…For The Final Grade.

Hello and time for some more #formulafriday fun. Today we are going to look at calculating some weighted average percentages. I looked up the meaning of weighted average and according to Investopedia - It is an average in which each quantity to be averaged is assigned a weight, and these weightings determine the relative importance of each quantity on the average. This is a great method when some parts of something are more important than others. An obvious example of this is exam … [Read more...]

- 1
- 2
- 3
- …
- 34
- Next Page »