Top online PDF file converters

Today, converting the PDF files to any other desired format does not look a nerve-racking task. By using a smart and advanced PDF converter tool, it is easy to transform the PDF documents into various formats and files. During the conversion time, there will be no change with the original format of the documents. These portable document format files always contain necessary data, and they make sharing a little bit much easier. Whether it is about sharing documents between different operating ...
Read More

Excel Pivot Table Distinct Count to count unique value

This Excel tutorial explains how to use distinct count in Pivot Table to count number of unique value in a column grouped by other fields. Excel Pivot Table Distinct Count to count unique data In Excel 2013, there is a new aggregate function in Pivot Table called Distinct Count, which counts number of unique value in a column. For example, if a column contains employee names, you can use the distinct count function to count number of unique employee names in the column such as below. In thi...
Read More

Excel VBA Import CSV into Excel using Workbooks.OpenText Method

This Excel VBA tutorial explains how to import CSV into Excel automatically using Workbooks.OpenText Method. You may select different delimiters such as Tab, semicolon, comma, space. You may also want to read: Import Chinese CSV to Excel Excel VBA convert CSV to Excel Excel VBA Import CSV into Excel using Workbooks.OpenText Method In Excel workbook, you can manually import a CSV file into Excel (Data > From Text / CSV). However, you have to select some options in advance such as delimi...
Read More

Excel VBA Convert Text in Columns and Rows into Matrix Table

This Excel VBA tutorial explains how to convert text in columns and rows into Matrix Table. The Matrix table will display text instead of aggregated numbers. You may also want to read: Access Crosstab Query Excel VBA Convert Text in Columns and Rows into Matrix Table Using Excel Pivot Table, it is easy convert data into a Matrix Table with the help of Aggregate Functions such as Count, Sum, standard deviation. The information in the Matrix Table is displayed in aggregated numbers. Below ...
Read More

Excel VBA search text in multiple Workbooks in folder

This Excel VBA tutorial explains how to search text in multiple Workbooks in a folder and subfolders, and display the result in a summary page, including which workbook, which worksheet, and which Cell contains the text. You may also want to read: Excel VBA INSTR Function Excel loop workbooks in folders and subfolders with FSO Excel VBA search text in multiple Workbooks in folder Suppose you have multiple workbooks in a folder, and you want to know if any workbook contains a text yo...
Read More

MS Access select the first record of each group using First Function

This MS Access tutorial explains how to select the first record of each group using First Function. MS Access select the first record of each group When I create human resources report, I have always come across a situation where one employee has more than one records. For example, I want to create a staff list where one employee only has one row of record. If I add emergency contact field to the report and if an employee has more than one emergency contacts, then the Query will return one emp...
Read More

How to Change Default Excel Date Format (such as MMDD to DDMM)

This Excel tutorial explains how to change default Excel Date Format from Change Date and Time Format in Control Panel. How to Change Default Excel Date Format In the country I live, we normally use date format dd/mm/yyyy. However whenever I work for the US company, the system defaults to mm/dd/yyyy. This is annoying and it causes Excel error. For example, if I mistakenly type UK format 31/12/2019, the date will be recognized as a text because there is no such month as 31. It is even risky if ...
Read More

Group Date and Ungroup Month in Excel Pivot Table

This Excel tutorial explains how to group dates and ungroup month in Excel Pivot Table to prevent auto grouping of Pivot Table in Excel 2016. Group Date and Ungroup Month in Excel Pivot Table Since Excel 2016,  when you drag a date field to a Pivot Table Pivot Table Row, the dates are  automatically grouped by months instead of showing each date. This is extremely annoying because  it is tricky to ungroup the months if it is the first time you encounter this issue. In this post I am going t...
Read More

How to convert Excel to PDF

This Excel tutorial explains how to export Excel to PDF in Microsoft Excel and convert Excel to PDF using different online tools. How to convert Excel to PDF Excel spreadsheets are widely being used in today’s world in order to manage data. The ability to organize data effectively has contributed a lot towards the popularity of the Excel files. However, the Excel files are not portable and it is not the best method available for you to send out a document. That’s because there is a possibility...
Read More

Access VBA delete Table records with SQL using DoCMD.RunSQL Method

This Access VBA tutorial explains how to use VBA delete Table records with SQL without alert using DoCMD.RunSQL Method. You may also want to read: Access VBA run Query or run Action Query Access delete Table records In my previous post, I have explained how to delete Table records without using VBA, below is a quick recap. Suppose we have created a table called student in Access, which contains 5 student records. student Student ID Student Name 001 Apple 002 Bet...
Read More