Search Results

Download this free Monthly Excel Calendar with holidays and appointments. It automatically adds standard holidays like Easter and New Year’s – you can also use it to keep track of your appointments.

Find out the how the balance sheet works with this simple demo. It involves orange juice and water. After this you’ll be able to understand the accounting equation. Assets equal Liabilities plus Equity or if we rearrange: Equity equals Assets minus Liabilities. A higher value for assets, a lower value for liabilities equals higher equity.

Printing Excel sheets is really easy – you just need to know which printing option to use. There are a few important features that will address your most common Excel printing problems. For example, printing on one sheet – or how to print selected areas, how to print without the report being too small.

Quickly learn how to import data from a web page into Excel with these 2 practical examples. The advantage of importing data this way is that whenever the data on the website is updated, you’ll just need to “refresh” the data in Excel to get the latest information. It’s super easy!

This Excel dashboard combines 4 strange features to create a dynamic and practical dashboard. It includes FILTER function with XLOOKUP, XOR function, Linked Picture as well as an Icon. You’ll find a lot of hidden gems in the way this Excel dashboard was created.

Apply your theoretical accounting knowledge to practical bookkeeping. Learn how to record debits and credits using T-accounts and journal entries. In order to figure out the debits and credits for the transactions, you will use our secret weapon, ADEx LER (Accountants Don’t Expect Low Earning Rates).

The merge shapes tool allows you to create a professional PowerPoint presentation. This way you can create custom shapes and even insert an image into a shape. Using Intersect or Fragment options you can also create custom PowerPoint typography.

Finally understand what Debits and Credits are and remember it easily with this simple trick: ADEx LER – (Accountants Don’t Expect Low Earning Rates) – This way you’ll know whether the account should be debited or credited.

Excel’s New & Improved XLOOKUP function will be the answer to most of your Excel Lookup problems. Learn from these 5 examples to see how you can apply the new XLOOKUP function to your files.

If you’d like to do a lookup to the left in Excel use the new XLOOKUP function. Forget about using INDEX MATCH or a VLOOKUP workaround. Just go with XLOOKUP.

New to Accounting? Learn the fundamentals of accounting through a simple story. This article gives you an introduction to accounting and explains the concepts of income statement (Profit & Loss), balance sheet and the accounting equation (Assets = Liabilities + Equity).

Here is an Excel trick when using the Advanced Filter Feature in Excel. It’s about copying a filtered result to another sheet. Did you know that you can copy the filtered results for the columns that you need, and you can ignore the columns that you don’t need?