Free Excel Pro Templates. This website uses cookies to improve your experience while you navigate through the website. Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool. Take your analytics to the next level with Excel.

For years, Microsoft Excel has represented the gold standard when it comes to spreadsheet software. Although firm market share figures specific to Excel use are hard to come by, Microsoft Office, the productivity suite in which Excel comes packaged, still claims approximately 80% to 96% of worldwide user share. As PCMag wrote in 2013, Excel is “far and away the most powerful, and now the easiest to use worksheet app… the first and only choice for manipulating numeric data.”

Believe it or not, there are countless ways to supercharge your Microsoft Excel experience: some built directly into the program’s interface, and some available as free external plug-ins. Nobody ever said Excel was easy, and nobody can ever become a master of the complex program. But following the 10 methods below can help you wring more productivity and efficiency out of Excel.

1. Use Ctrl+Shift to select a data set. Using the mouse and dragging the cursor can be slow compared to this quick and easy keyboard shortcut. Click the first cell you want to select, hold down Ctrl+Shift, and use the arrow keys to collect all the data you want to copy or cut. Press Ctrl+Shift+End to jump to the lowest right-hand cell and select everything in between, or use Ctrl+Shift+* and select the whole data set no matter which cell is selected. Alternatively, clicking the corner button of any worksheet will select the entire data set in seconds.

2. Apply similar formatting to multiple sheets at the same time. This critical task is a breeze with Excel’s grouped worksheets feature. Click the tabs of the sheets you want to group together while pressing CTRL and they’ll all turn white; while the sheets are grouped, any formatting entered on one sheet also shows up in the others. After formatting grouped sheets, make sure to click on tabs to ungroup them before entering or removing data.

3. Remove duplicates from a data set. If you’re working with a large body of data, you’ve probably got duplicate content lurking around somewhere. Luckily, removing it is easy: highlight the row or column you want to assess for duplicate entries, click the Data tab, then Tools, then select Remove Duplicates. A pop-up will prompt you to confirm which information you want to work with and remove to prevent data loss.

4. Insert rows and columns with ease. A good Excel spreadsheet is always ready to grow. Quickly adding rows and columns can be done in a variety of ways: clicking Insert > Rows or Columns; right-clicking on rows or columns and choosing Insert; or pressing the CTRL and + or CTRL, SHIFT, and + keys.

5. Rely on simple calculations to save time and energy. Excel’s formulas can be legendary for their complexity, but simple calculations can often give you the most immediate boost in productivity. To add, use the + key; to subtract, use the – key; to multiply, use the * key; and to divide, use the / key.

6. Insert Excel data into Microsoft Word or PowerPoint. If you’ve ever tried this before, you might laugh. But transferring data from a spreadsheet to a text document is possible. Just be careful to click the clipboard that shows up after you paste to decided whether you’d like to keep the original Excel formatting or have the pasted data match the format of your existing Word or PowerPoint document.

7. Dig deep into data with PivotTable reports. This interactive Excel option allows users to see the big picture contained within a data set by automatically extracting, organizing, and summarizing data. Select either a whole table or individual cell and click on Insert > PivotTable —then visit Microsoft’s PivotTable Support page for further tutorials.

8. Use AutoFill. This works great for repetitive tasks: filling in dates, times, or other values that follow a sequence. Start with the first entry, then move the cursor over the lower right section of the final cell, which brings up a fill handle. Once it changes to a plus (+) sign, click and select all the cells you need to fill with your chosen pattern. You can even go up a column or left and right on a row.

9. Open multiple worksheets with one double-click. Working on multiple worksheets one day and know you’ll do it again the next? Before you shut down Excel, click on View > Save Workspace, then enter a name and location for your saved view. An icon will appear in the location of your choice — clicking on that icon takes you back to the same worksheet set.

10. Hide data in protected worksheets. If you want to share some data with other users but not all of it, consider hiding it. The easy way is to right click and select the Hide function. But you can be even safer by using the Format Cells function by clicking Home>Font>Open Format Cells>Number Tab>Custom>Type. That way, your data can stay truly safe.

Whether you’re a seasoned Excel pro on the hunt for fresh usability tricks, or a new user scrambling to make sense of it all, these tips should beef up your program experience. If you’re considering an upgrade to Office 2013, or looking for other ways to make your technological life more productive and efficient, contact CMIT Solutions today. We’re here to make technology work for your business, not against it.

You can open Microsoft Office Excel tables directly in ArcGIS Pro and work with them in the same way as other tabular data sources. For example, you can add them to the map, open them in the fields view, and use them as inputs to geoprocessing tools.

Install the Microsoft Access Database Engine driver

If you attempt to access an Excel file in ArcGIS Pro without the appropriate driver installed, you will receive the error Required Microsoft driver is not installed.

To work with Excel files in ArcGIS Pro, you must download and install the Microsoft Access Database Engine 2016 Redistributable from the Microsoft Download Center.

Clicking Download on the page will present you with a choice of two downloads, 32 bit or 64 bit:

• If you are using ArcGIS Pro 2.4, choose the 32-bit driver download.
• If you are using ArcGIS Pro 2.5 or later, choose the download that matches your currently installed Microsoft applications.

The download options are:

• AccessDatabaseEngine.exe—32-bit driver
• AccessDatabaseEngine_X64.exe—64-bit driver

If you try to install the downloaded AccessDatabaseEngine.exe file on a machine that already has a Microsoft 64-bit application, you will get an error message saying that you cannot install a 32-bit version of the database engine because you currently have 64-bit Office products installed. A similar error message will display if you try to install the AccessDatabaseEngine_X64.exe file on a machine that already has a Microsoft 32-bit application.

To work around this problem, you will need to perform a silent installation of the downloaded file by doing the following:

1. Save the downloaded file to your computer, on the C: drive.
2. Using the Windows search box on the task bar, type Command Prompt to find and open the Command Prompt application.
3. Right-click the Command Prompt application and select Run as administrator.
4. The command prompt will open to a default directory. Type cd C: to change the directory to the C: drive where you've saved the downloaded file.
5. To run the .exe as a silent installation, type AccessDatabaseEngine.exe /quiet or AccessDatabaseEngine_X64.exe /quiet, depending on the file you've selected to download from the Microsoft Download Center.
It is recommended that you restart your computer after the installation.

Use Microsoft Excel files in ArcGIS Pro

You add Excel files to a project in the same way as other data: click the Add Data button on the Map tab. When you browse to an Excel file, you must choose the table you want to open. For example, if you have an Excel workbook named Sales_Figures.xlsx that contains three worksheets—Sales, Month, and Year to Date—each worksheet is a separate table in ArcGIS Pro.

When accessed from ArcGIS Pro, a worksheet is shown as a table with a dollar sign ($) at the end of its name. Worksheets with names containing spaces will have the spaces replaced by underscores.

Once the table is added to the map, you can open it in the Contents pane. However, you cannot edit the table or export records to an Excel format.

The following example contrasts how a multisheet document is exposed in Microsoft Excel and on the Add Data dialog box:

• Three worksheets are shown as they appear on the Sheet tab bar at the bottom of the Excel window.
• Available worksheets are shown in the Sales_Figures workbook on the Add Data dialog box.

Format a table in Microsoft Excel for use in ArcGIS Pro

You can work with Microsoft Excel files in ArcGIS Pro in the same way as other tabular data sources, but there are a few limitations. Follow these general best practices when creating Excel data to be used in ArcGIS Pro:

1. Make sure the first row of the worksheet is properly formatted, since it will be used for the field names in ArcGIS.

   Follow these best practices for field naming, particularly if you want to join an Excel table to another table:

   • Field names must start with a letter.
   • Field names must contain only letters, numbers, and underscores.
   • Field names must not exceed 64 characters.
2. If you have cells with numeric data, dates, and so on, ensure that the content is consistently formatted—in other words, make sure all numeric data is actually numeric. If there are other types of data in those rows, the field is converted to text when the table is opened in ArcGIS Pro.

Add a Microsoft Excel table to the map

Excel Project Management Template

You add Excel files to a project in the same way as other data: click the Add Data button on the Map tab, or use the Catalog pane.

1. Click the Add Data button on the Map tab on the ribbon.
2. Browse to the Excel workbook file when the Add Data browse dialog box appears.
3. Double-click the Excel workbook file.
4. Click the table you want to add to the map.
5. Click Select.
Alternatively, you can also drag an Excel table onto the map from the Catalog pane, or right-click the table and click Add To Current Map .

Limitations

Excel Project Management Template

When working with Microsoft Office Excel files, keep the following in mind: Florens technology development driver download for windows.

Excel Property Management

• ArcGIS supports both Excel 2003 and earlier .xls files and Excel 2007 .xlsx files. One advantage of Excel 2007 is that it allows much larger worksheets (1,048,576 rows by 16,384 columns) than you can have in Excel 2003 (65,536 rows by 256 columns).
• Excel tables are read-only in ArcGIS Pro; however, they can be edited in Excel while you have a worksheet open in the Contents pane (stand-alone table layer). The layer will only display the updated (saved) values for edits made outside of ArcGIS Pro when ArcGIS Pro has been closed and reopened.

  Note:

  If you make edits to a worksheet outside of ArcGIS Pro while it is open in the Contents pane, and then try to remove and re-add the layer without restarting ArcGIS Pro first, you may receive an unsupported data type error.

• Field names are derived from the first row in each column of the worksheet. You can view the properties, set aliases for the field names, set field visibility, and set numeric formatting for the layer in the fields view.
• Excel does not enforce field types for values during data entry the way standard databases do. Therefore, the field type specified in Excel is not used in determining the field type exposed in ArcGIS. Instead, the field type in ArcGIS is determined by the Microsoft driver. If the driver finds mixed data types in a single field, that field will be returned as a string field, and the values will be converted to strings.
  • If the Excel table will be exported, the desired size of text fields should be considered.
• You can directly export to Excel using the Table To Excel tool. You can also export tabular data to dBASE format, which can be opened in Excel 97–2003 and saved as an .xls file. Microsoft discontinued support for .dbf files in Office 2007.

• When an Excel worksheet is added to a map, ArcGIS Pro will attempt to maintain all characters present in the sheet or field name and display this in the stand-alone table.

  For example, a sheet called Year to Date in Excel will display in the Catalog or Contents pane as 'Year to Date$', placing the name in quotes since it contains spaces. When used in a geoprocessing tool, the underlying table is used directly, so you may notice a slight change in the name. Using the same example, if you drag the Excel sheet Year to Date into a geoprocessing tool, or select it from an input drop-down menu, it will be represented as T_Year_to_Date$_.

  Note:

  If the table name does not contain an expected character, it may have been replaced by the Microsoft driver before ArcGIS Pro accessed it. This is known to occur for a small subset of characters in which .![] becomes #_(), respectively.
• Excel files with password protection are not supported.