This tutorial explains differences among Function, Sub, Method, Property Excel / Access VBA. You may also want to read: Difference between Dim and Set Excel VBA Option Explicit to force declaration of variables Difference between ByRef ByVal Function, Sub, Method, Property Differences In my blog, I have categorized different VBA topics by their properties. If you don't understand Fun...

What is Macro? Macro is a set of actions that are intended to be repeating all over again. Macro is not a word just for Excel, you can find many other software help users record a set of actions for Windows or even for specific games. The first Macro I used was EZ Macro about 15 years ago, which helped me repeat a set of actions in an online game endlessly in order to get my skill points up. Toda...

This Excel tutorial explains how to use Excel FIND Function for Excel worksheet, and also explains the differences between INSTR and SEARCH function. You may also want to read: Extract text in brackets Remove text in brackets Excel Find Function Excel Find function is used to search a substring (part of the string) within a string and return the position of the first occurrence, n...

This Excel tutorial explains the Excel Search Function for Excel worksheet, and also explains the differences between INSTR and FIND function. Excel Search Function Excel Search function allows Wildcard to search a substring (part of the string) within a string and return the position of the first occurrence. Excel Search Function is not case sensitive, you should consider using Excel FI...

This Excel tutorial explains how to import Chinese CSV to Excel with correct encoding. (解決CSV轉EXCEL亂碼) You may also want to read: Export Chinese Excel to CSV Import Chinese CSV to Excel When you import Chinese CSV to Excel, some Chinese characters will become a question mark "?" or convert to unexpected Chinese characters, same will happen for symbols and other languages such as Japanese, ...

This Excel tutorial explains how to export Chinese Excel to CSV, the method is also applicable to other languages. (解決Excel轉CSV亂碼). You may also want to read: Import Chinese CSV to Excel Export Chinese Excel to CSV When you export Chinese Excel to CSV (Comma-separated values), some Chinese characters will become a question mark "?", same will happen for symbols and other languages such as ...

This Excel tutorial summarizes a list of Excel shortcut key as well as Windows short cut key which are applicable to Excel. Excel Shortcut key Below is a table that summarizes most Excel shortcut key. I referred to the Microsoft website for the Excel shortcut key, removed some unimportant Excel shortcut key, and then combined with some Windows short cut key that are also applicable in Excel and ...

What is Microsoft Office Specialist for Excel exam? Microsoft Office Specialist (also known as MOS) is a certificate that can be earned if you pass an exam. Microsoft Office Specialist has exams for different Office products, which include Microsoft Word, Powerpoint, Excel, Access, Outlook, SharePoint, OneNote. Microsoft Word and Excel are slightly different, each of them have two levels, one ...

Excel AutoCorrect Excel AutoCorrect literally means to correct a misspell text to a correct text automatically, but you can also make use of this function to make a mapping list, to convert a text to another text automatically, so Excel AutoCorrect is more than just "Correction". Some people use it to convert abbreviation, convert language. For example, if your mapping list maps M as Mother, a...

Excel iterative calculation and circular reference To understand what is Excel iterative calculation, you should first understand what is circular reference. Circular reference happens when you type a formula in one Cell which refers to another Cell, but that Cell also refers back to the Cell. For example, Cell A1:  = 1+A2 Cell A2: = 1+A1 The above formula refer to each other, this i...