Excel Tips

Download and install the OLEDB Excel 2010 driver

How to download and install the OLEDB drivers and components for Excel 2010 Download and install the set of Excel drivers components, also called Drivers Database Access 2010. Or Redistributable Microsoft Access 2010 Database Engine. It facilitates the transfer and connections between Microsoft Office Access 2010 files and Microsoft Office Excel 2010 files to databases like SQL Server (2005, 2008, 2008 R2 and 2012).

Excel Tips

Download and install the Excel OLEDB 2007 driver

Download OLEDB Driver for Excel 2007 allows to read Excel files from applications using ODBC or OLEDB connections. The driver for Excel 2007 is needed for example to load Excels files from SSIS. Here are the 3 steps to follow to use your files from ODBC or OLEDB connections. How to download and install the Excel OLEDB 2007 driver? First of all, you have

Excel Tips

Pivot Excel table rows into columns

Excel tables are very useful to analyse and compute financial data with formulas. Sometimes a table is provided in a format that is not practical in lines; so you need them in columns. This tutorial explains step by step how to pivot the Excel table rows into columns. How to pivot Excel table rows into columns? It’s really simple. You just need to select

Excel Tips

Disable the direct edit option in Excel

With Microsoft Excel, how to disable the direct edit option in Excel to edit spreadsheet cells? That is, the function of automatically modifying the content of a cell when it contains a formula? Indeed, by clicking on a cell containing a formula, this click sends you back to the first cell quoted in this formula. Indeed, this is very practical, but it can also

Excel Tips

Create an Excel pivot table

How to create an Excel pivot table to analyse data? Tutorial to create an Excel pivot table When analysing a lot of data, it can be difficult to analyse all the information in your spreadsheet. Especially large tables with several thousand rows. Pivot tables make spreadsheets more manageable by summarising the data and allowing it to be arranged in different ways. This tutorial explains

Excel Tips

Unhide Excel spreadsheets

How to unhide a hidden spreadsheet with Microsoft Excel? Display hidden Excel spreadsheets in a workbook A hidden Excel worksheet is handy in a shared workbook to not allow all users to change data or settings. For example, if the Excel workbook is locked with a password, then the hidden data is protected from changes. With Microsoft Excel, how to unhide an Excel spreadsheet,

Excel Tips

The best Excel shortcuts to manage pivot tables

Here is a selection of the best keyboard shortcuts to manage Excel pivot tables. Excel Pivot Tables, Excel Pivot table in English, or DCT for short, allow you to cross reference data in a file very efficiently. Whether the source is a flat CSV file, another Excel tab, an SQL source such as a SQL Server table or an SSAS cube. First of all,

Excel Tips

Create an Excel table

Create an Excel table from a data area. How to create an Excel table and sort, format and filter its columns? Then filter the data? First create the required rows and columns. Fill the table with data and turn it into a table with headers. In the form of a table, it is possible to sort and filter the data easily. An Excel table

Excel Tips

How to remove #VALUE! #NA! #DIV0 Excel errors?

How to remove #VALUE! #NA! #DIV0 Excel errors with any version of Excel like 2003, 2007, 2010 or Excel 2016? Common messages are for example: #VALUE!, #N/A, #DIV/0!, #REF!, #NAME?, #NULL!, #NUM! Indeed, there is a trick to solve this little problem that occurs more than often with Excel formulas. Using the IFERROR() function in Excel allows you to return a value if the

Excel Tips

Create and open a new Excel workbook

How to create and open a new Excel workbook? What is the Excel spreadsheet? Excel is a software from the Microsoft Office suite. An Excel file is also called an Excel workbook. Like a traditional physical workbook, it consists of sheets but also tables and cells. First of all, the Excel sheets are actually tabs. Tables and lists can be created. These tables and