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.

How to Create a Structured Reference in Excel

By March 9, 2023 4:36 pm

Move a Chart to Another Sheet in Excel

By March 9, 2023 3:54 pm

Create an Ogive Graph in Excel

By March 8, 2023 8:15 pm

20 Must-Know Advanced Excel Functions (with Formulas)

By March 8, 2023 7:50 pm

VLOOKUP Vs. INDEX-MATCH

By March 8, 2023 6:48 pm

Flip Data (as Well as Charts) in Excel

By March 8, 2023 5:50 pm

Calculate the Midrange in Excel

By March 8, 2023 4:56 pm

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

Merge Multiple Excel Files Into One Workbook

By February 10, 2023 4:11 pm

Delete Hidden Columns and Rows in Excel

By February 9, 2023 4:23 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

Rotate Charts in Excel

By January 30, 2023 3:04 pm