Iphone 7 Delete All Solution

Finally - A solution -How to Delete ALL Emails on My Iphone 7.

I finally found a solution to deleting all the emails in my InBox at once. Why oh why did Apple get rid of the Delete All option?  It definitely needs to be added back.

I found the answer on this site  and it was very easy to do once you know the trick.

1. Go to your Inbox and click Edit.
2. Select a single email.
3. Press and hold down  the Move button at the bottom of the screen and then uncheck the email you selected.
4. A page will pop up and you can select if all the emails should go to Trash or Junk.
5. Make your selection and all your emails disappear!
You may have to hold the Move button for a good couple of seconds, depending upon on how mail you have. 
If you don't see the page, it may just automatically got to Trash.I have had that happen a couple of times.

Make sure that you really want to delete everything in your Inbox before you do this. 
Don't forget that this just deleted them from your inbox- you still need to clean out your trash folder at some point.

Date and Day Functions

Date and Day Functions

I found an interesting site on Excel for SEOs.
Actually, most of the information on the site pertains to anyone using Excel.
One of their pages was on dates and days. I find a lot of people struggle with date functions
.
=NOW() and =TODAY() are the most common  Date functions.
 They are called volatile functions because they change as the date changes. =NOW() is the more versatile of the two as it tracks both date and time, however, you can format it so that it displays just the date, just the time or both. Whereas, =TODAY only displays and tracks the current date.
They can be very useful. For example, if you create and print a lot of versions of a document, such as a budget. include =NOW(), at the top or in the document header. The =NOW() will display the time - you can even  format down to the second- so you are confident that you have the latest version of your document as you go off to your presentation.

This site has some other date functions that you may be interested in  - particularly NETWORKDAYS and YEARFRAC.
I hope you find them useful.
http://www.acuitytraining.co.uk/white-paper/the-seos-guide-to-excel

12 Months Data -13 Months Data in a Chart

An interesting Excel feature is that as you make the 12-month chart smaller and smaller, Excel drops the last (right-most) label from the X axis although the column or line still may appear in the chart itself. So, you may want to consider including thirteen months of data when putting together your dashboard.

Excel 2016 Charts - X Axis Date Units

Date Units on the X Axis- Excel

I was working on a dashboard in Excel 2016 and I ran into something a bit frustrating. So, I thought I would share it since I am assuming others have run into the problem as well.
Below is a picture of my data and my chart - See anything wrong with it?
OK- now don't get too picky - this is before I formatted or updated anything - so what's wrong with it?

Take a look at my X axis..
The X axis shows 1/1/2016, 2/1/2016 instead of what is actually shown in Column A, which is the last day of each month.  I have used this same data and charted it in other versions and never ran into this particular issue so I was a  bit surprised.
Apparently Excel 2016 and probably Excel 2013's unit default is month.
To fix this problem, right-click on the X axis and on the Format Axis pane, change the Base to Days.

Once you do that, magically the dates in my chart now match the dates in my worksheet.

Updating Your Pivot Table

Automatically update your Pivot Table 

Whenever I start showing people Pivot Tables, one of the first questions asked is: “What happens when additional data is added to the source data?” 
First, changes to the existing data are automatically updated when you select the REFRESH button  located on the contextual Options tab.

If you add additional rows of data, Excel does not automatically add that information to the Pivot Table.

There are two ways to get Excel to automatically update the Pivot Table for any additional data.

ÜStarting with Excel 2010  you can turn your data into a table. If you do this, then Excel will automatically update the Pivot Table. This is by far the easiest way to do it.

Create a Table

Turn your data list into a table and it displays alternating row shading and AutoFilter drop down boxes.

1.      Click in the data.

2.      Click Insert tab.

3.      Click Table.

4.      Verify the data range and click OK.

That is it! Excel now considers your data to be a table and it will incorporate new rows and columns of information as  they are added.  If you open your Pivot Table and re-select your data source, the Pivot Table will now update as the range changes.  As data is added it will automatically be incorporated into the parameters of the original source data.

If you don’t control the data, then you may not be able to turn it into a table. In that case, the process is a bit more involved as you need to create a dynamic range, but it is definitely worth the effort.

Create a Dynamic Range

1.      Click in the source data.

2.      Select the Formulas tab and click on Define Name.

3.      In the New Name dialog box, name your data. In this example, I named it sales_data.

4.      The scope should stay at the default level of Workbook.

5.      In the Refers to: section type the following:

6.      =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))

7.      Click OK.

What we have created  is  a dynamic range called sales_data. The OFFSET formula is telling Excel that on Sheet1, look at cell A1,  count how many cells are in Column A, and then it  counts how many cells are in row 1, so it will count and include new data as it is added.

Warning:  Make sure there is no other data below your dynamic range. If there is, this will not work.