Patrick Louie

Bookkeeping, Tax & Revenue Specialist

Patrick has 10 yrs of experience in Finance, Bookkeeping and Accounting working for companies both in the USA and outside of the USA, including Bureau of Internal Revenue.

Patrick contributes weekly to Fundsnet with his long list of experience in Bookkeeping and forensic accounting, as he has first hand, real-world experience in many accounting related subjects.

Using MOD in Excel (and VBA)

By March 6, 2023 6:45 pm

Assign a Number Value to Text

By March 6, 2023 6:12 pm

How to Reverse the CONCATENATE Function in Excel

By March 6, 2023 4:16 pm

How to Find the Latest (or Earliest) Date Along With a Corresponding Value in Excel

By February 28, 2023 5:28 pm

Clear Cell Contents in Excel with VBA

By February 24, 2023 5:33 pm

Count Distinct Values with Excel’s PivotTable

By February 22, 2023 8:12 pm

What is the #NUM! Error?

By February 22, 2023 7:47 pm

Use Wildcards With VLOOKUP in Excel

By February 10, 2023 4:39 pm

Merge Multiple Excel Files Into One Workbook

By February 10, 2023 4:11 pm

Using Excel’s COUNTIF Function

By February 9, 2023 5:04 pm

Delete Hidden Columns and Rows in Excel

By February 9, 2023 4:23 pm

Make Leading Zeros Appear in Excel

By February 7, 2023 4:08 pm

Perform Reverse VLOOKUP in Excel

By February 3, 2023 2:18 pm

Create a Tornado Chart in Excel

By February 2, 2023 2:24 pm

Apply Conditional Formatting to a Pivot Table in Excel

By February 2, 2023 2:16 pm

Apply Horizontal Filter in Excel

By February 1, 2023 3:09 pm

Remove The First Character from a Cell in Excel

By January 31, 2023 5:48 pm

Rotate Charts in Excel

By January 30, 2023 3:04 pm

Perform a Two-Way ANOVA in Excel

By January 30, 2023 2:56 pm

Create a Lineweaver-Burk Plot in Excel

By January 26, 2023 5:17 pm