How To Get Excel

1. How To Get Excel For Free
2. Microsoft Word And Excel Download Free
3. More News For How To Get Excel
4. Get Excel For Free With Excel Online - Excel Exercise

You can open and create Word, Excel, and PowerPoint documents right in your browser. To access these free web apps, just head to Office.com and sign in with a free Microsoft account. Click an application icon—like Word, Excel, or PowerPoint—to open the web version of that application. To work with Excel online, you can go on www.office.com or www.onedrive.com Then, you select one one of your Microsoft account (like xxxxx@hotmail.com). There, you see your name or your picture on the right-upper corner. You can now create an Excel document by clicking on the menu icon (the 9 dots) and select the Excel menu.

An Excel drop down list or dropdown menu can make it easier for the average Microsoft Excel user to enter data on a worksheet or workbook. Using a drop down menu in web forms, surveys, or polls can limit the entry choices for a selected cell, speeding data entry and reducing data entry error. In this Excel tip, we'll show you a quick and easy way to create a dropdown list or drop down menu using the spreadsheet application's Data Validation feature.

You need only two things: A list and a data entry cell. Figure A shows a simple drop down list in an Excel sheet. You can work with your own data or download the demonstration .xlsx and .xls files.

Figure A

To add the drop down list in our example to an Excel sheet, do the following:

1. Create the data validation list in cells A1:A4. Similarly, you can enter the items in a single row, such as A1:D1.
2. Select cell E4. (You can position the drop down list in most any cell or even multiple cells.)
3. Choose Data Validation from the Data ribbon menu.
4. Choose List from the Allow option's drop down list. (See, they're everywhere.)
5. Click the Source control box and drag the cursor to highlight the cells A1:A4. Alternately, simply enter the reference (=$A$1:$A$4).
6. Make sure the In-cell dropdown option is checked. If you uncheck this option, Excel still forces users to enter only list values (A1:A4), but it won't present a drop down list.
7. Click OK.

SEE: How to create a drop-down list in Google Sheets (TechRepublic)

You can add the drop down list to multiple Excel cells. Select the range of data input cells (step 2) instead of a single Excel cell. It even works for noncontiguous Excel cells. Hold down the Shift key while you click the appropriate Excel cells.

A few quick notes:

• You can only see the drop down box if you click on the Excel cell used for data entry.
• Your users can now only choose one of the options in the drop down. If they try to enter their own data, then they'll receive an error message.
• You can copy-and-paste this drop down cell to any other Excel cells in your spreadsheet, and you can create as many different drop downs like this as you'd like.

SEE: 10 Excel time-savers you might not know about (free PDF) (TechRepublic)

A Microsoft Excel bonus tip

This Excel tip is featured in the free PDF 30 things you should never do in Microsoft Office.

Rely on multiple links

Links between two Excel workbooks are common and useful. But multiple links where values in workbook1 depend on values in workbook2, which links to workbook3, and so on, are hard to manage and unstable. Users forget to close files, and sometimes they even move them. If you're the only person working with those linked Excel workbooks, you might not run into trouble, but if other users are reviewing and modifying them, you're asking for trouble. If you truly need that much linking, you might consider a new design.

Get more Excel tips

Read 56 Excel tips every user should master and the tutorials on how to add a condition to a drop down list in Excel, how to add color to a drop down list in Excel, how to create an Excel drop down list from another tab, how to change an Excel conditional formatting on the fly and how to combine Excel's VLOOKUP() function with a combo box for enhanced searching. Also, check out this free PDF download: 13 handy Excel data entry shortcuts.

The current date and time is a very common piece of data needed in a lot of Excel solutions.

The great news is there a lot of ways to get this information into Excel.

In this post, we're going to look at 5 ways to get either the current date or current time into our workbook.

Video Tutorial

Keyboard Shortcuts

Excel has two great keyboard shortcuts we can use to get either the date or time.

These are both quick and easy ways to enter the current date or time into our Excel workbooks.

The dates and times created will be current when they are entered, but they are static and won't update.

Current Date Keyboard Shortcut

Pressing Ctrl + ; will enter the current date into the active cell.

This shortcut also works while in edit mode and will allow us to insert a hardcoded date into our formulas.

Current Time Keyboard Shortcut

Pressing Ctrl + Shift + ; will enter the current time into the active cell

This shortcut also works while in edit mode and will allow us to insert a hardcoded date into our formulas.

Functions

How To Get Excel For Free

Excel has two functions that will give us the date and time.

These are volatile functions, which means any change in the Excel workbook will cause them to recalculate. We will also be able to force them to recalculate by pressing the F9 key.

This means the date and time will always update to the current date and time.

TODAY Function

This is a very simple function and has no arguments.

It will return the current date based on the user's PC settings.

This means if we include this function in a workbook and send it to someone else in a different time zone, their results could be different.

NOW Function

This is also a simple function with no arguments.

It will return the current date and time based on the user's PC date and time setting.

Again, someone in a different time zone will get different results.

Power Query

In Power Query, we only have one function to get both the current date and current time. We can then use other commands to get either the date or time from the date-time.

How to get pokemon on my phone. We first need to add a new column for our date-time. Go to the Add Column tab and create a Custom Column.

In the Custom Column dialog box.

1. Give the new column a name like Current DateTime.
2. Enter the DateTime.LocalNow function in the formula section.
3. Press the OK button.

Extract the Date

Now that we have our date-time column, we can extract the date from it.

We can select the date-time column ➜ go to the Add Column tab ➜ select the Date command ➜ then choose Date Only.

This will generate a new column containing only the current date. Power query will automatically generate the above M code with the DateTime.Date function to get only the date.

Extract the Time

We can also extract the time from our date-time column.

We can select the date-time column ➜ go to the Add Column tab ➜ select the Time command ➜ then choose Time Only.

This will generate a new column containing only the current time. Power query will automatically generate the above M code with the DateTime.Time function to get only the time.

Power Pivot

With power pivot, there are two ways to get the current date or time. We can create a calculated column or a measure.

To use power pivot, we need to add our data to the data model first.

1. Select the data.
2. Go to the Power Pivot tab.
3. Choose the Add to Data Model command.

Power Pivot Calculated Column

A calculated column will perform the calculation for each row of data in our original data set. This means we can use the calculated column as a new field for our Rows or Columns area in our pivot tables.

It turns out Power Pivot has the exact same TODAY and NOW functions as Excel!

We can then add a new calculated column inside the power pivot add in.

1. Double click on the Add Column and give the new column a name. Then select any cell in the column and enter the TODAY function and press Enter.
2. Go to the Home tab ➜ Change the Data Type to Date ➜ Change the Format to any of the date formats available.

Microsoft Word And Excel Download Free

We can do the exact same to add our NOW function to get the time and then format the column with a time format.

Power Pivot Measure

Another option with power pivot is to create a measure. Measures are calculations that aggregate to a single value and can be used in the Values area of a pivot table.

Again, we can use the same TODAY and NOW functions for our measures.

Add a new measure.

1. Go to the Power Pivot tab.
2. Select the Measures command.
3. Select New Measure.

This will open up the Measure dialog box where we can define our measure calculation.

1. Give the new measure a name.
2. Add the TODAY or NOW function to the formula area.
3. Select a Date Category.
4. Select either a date or time format option.
5. Press the OK button.

Now we can add our new measure into the Values area of our pivot table.

Power Automate

If you're adding or updating data in Excel through some automated process via Power Automate, then you might want to add a timestamp indicating when the data was added or last updated.

SEE: 10 Excel time-savers you might not know about (free PDF) (TechRepublic)

A Microsoft Excel bonus tip

This Excel tip is featured in the free PDF 30 things you should never do in Microsoft Office.

Rely on multiple links

Links between two Excel workbooks are common and useful. But multiple links where values in workbook1 depend on values in workbook2, which links to workbook3, and so on, are hard to manage and unstable. Users forget to close files, and sometimes they even move them. If you're the only person working with those linked Excel workbooks, you might not run into trouble, but if other users are reviewing and modifying them, you're asking for trouble. If you truly need that much linking, you might consider a new design.

Get more Excel tips

Read 56 Excel tips every user should master and the tutorials on how to add a condition to a drop down list in Excel, how to add color to a drop down list in Excel, how to create an Excel drop down list from another tab, how to change an Excel conditional formatting on the fly and how to combine Excel's VLOOKUP() function with a combo box for enhanced searching. Also, check out this free PDF download: 13 handy Excel data entry shortcuts.

The current date and time is a very common piece of data needed in a lot of Excel solutions.

The great news is there a lot of ways to get this information into Excel.

In this post, we're going to look at 5 ways to get either the current date or current time into our workbook.

Video Tutorial

Keyboard Shortcuts

Excel has two great keyboard shortcuts we can use to get either the date or time.

These are both quick and easy ways to enter the current date or time into our Excel workbooks.

The dates and times created will be current when they are entered, but they are static and won't update.

Current Date Keyboard Shortcut

Pressing Ctrl + ; will enter the current date into the active cell.

This shortcut also works while in edit mode and will allow us to insert a hardcoded date into our formulas.

Current Time Keyboard Shortcut

Pressing Ctrl + Shift + ; will enter the current time into the active cell

This shortcut also works while in edit mode and will allow us to insert a hardcoded date into our formulas.

Functions

How To Get Excel For Free

Excel has two functions that will give us the date and time.

These are volatile functions, which means any change in the Excel workbook will cause them to recalculate. We will also be able to force them to recalculate by pressing the F9 key.

This means the date and time will always update to the current date and time.

TODAY Function

This is a very simple function and has no arguments.

It will return the current date based on the user's PC settings.

This means if we include this function in a workbook and send it to someone else in a different time zone, their results could be different.

NOW Function

This is also a simple function with no arguments.

It will return the current date and time based on the user's PC date and time setting.

Again, someone in a different time zone will get different results.

Power Query

In Power Query, we only have one function to get both the current date and current time. We can then use other commands to get either the date or time from the date-time.

How to get pokemon on my phone. We first need to add a new column for our date-time. Go to the Add Column tab and create a Custom Column.

In the Custom Column dialog box.

1. Give the new column a name like Current DateTime.
2. Enter the DateTime.LocalNow function in the formula section.
3. Press the OK button.

Extract the Date

Now that we have our date-time column, we can extract the date from it.

We can select the date-time column ➜ go to the Add Column tab ➜ select the Date command ➜ then choose Date Only.

This will generate a new column containing only the current date. Power query will automatically generate the above M code with the DateTime.Date function to get only the date.

Extract the Time

We can also extract the time from our date-time column.

We can select the date-time column ➜ go to the Add Column tab ➜ select the Time command ➜ then choose Time Only.

This will generate a new column containing only the current time. Power query will automatically generate the above M code with the DateTime.Time function to get only the time.

Power Pivot

With power pivot, there are two ways to get the current date or time. We can create a calculated column or a measure.

To use power pivot, we need to add our data to the data model first.

1. Select the data.
2. Go to the Power Pivot tab.
3. Choose the Add to Data Model command.

Power Pivot Calculated Column

A calculated column will perform the calculation for each row of data in our original data set. This means we can use the calculated column as a new field for our Rows or Columns area in our pivot tables.

It turns out Power Pivot has the exact same TODAY and NOW functions as Excel!

We can then add a new calculated column inside the power pivot add in.

1. Double click on the Add Column and give the new column a name. Then select any cell in the column and enter the TODAY function and press Enter.
2. Go to the Home tab ➜ Change the Data Type to Date ➜ Change the Format to any of the date formats available.

Microsoft Word And Excel Download Free

We can do the exact same to add our NOW function to get the time and then format the column with a time format.

Power Pivot Measure

Another option with power pivot is to create a measure. Measures are calculations that aggregate to a single value and can be used in the Values area of a pivot table.

Again, we can use the same TODAY and NOW functions for our measures.

Add a new measure.

1. Go to the Power Pivot tab.
2. Select the Measures command.
3. Select New Measure.

This will open up the Measure dialog box where we can define our measure calculation.

1. Give the new measure a name.
2. Add the TODAY or NOW function to the formula area.
3. Select a Date Category.
4. Select either a date or time format option.
5. Press the OK button.

Now we can add our new measure into the Values area of our pivot table.

Power Automate

If you're adding or updating data in Excel through some automated process via Power Automate, then you might want to add a timestamp indicating when the data was added or last updated.

More News For How To Get Excel

We can definitely add the current date or time into Excel from Power Automate.

We will need to use an expression to get either the current date or time. Power Automate expressions for the current time will result in a time in UTC which will then need to be converted into the desired timezone.

This expression will get the current date in the EST timezone. You can find a list of all the timezone's here.

This expression will get the current time in the EST timezone.

Get Excel For Free With Excel Online - Excel Exercise

Conclusions

Like most things in Excel, there are many ways to get the current date and time in Excel.

Some are static like the keyboard shortcuts. They will never update after entering them, but this may be exactly what we need.

The other methods are dynamic but need to be recalculated or refreshed.

Do you have any other methods? Let me know in the comments!