It's a Date!
Meet Microsoft Excel's 30+Date and Time functions. DATE(year, month, day) Date based on the provided year, month, and day. Example:...
top of page
ACCOUNTING CONCEPTS GROUP
Laura Dee
- Jan 27, 2023
- 2 min
Key Excel Skills Needed on Your Résumé
Employers often look for a variety of Excel skills when hiring for a job that involves working with data. Some of the most commonly...
380
Philip Seigel
- Jan 24, 2023
- 4 min
Excel: Good & Bad Habits
Excel is popular because it is a powerful and versatile tool for organising, analysing, and manipulating data. It offers a wide range of...
90
Philip Seigel
- Jan 6, 2023
- 1 min
Excel's Flash Fill. Your new best friend
Excel's Flash Fill feature is a powerful tool that allows you to quickly fill in a range of cells with data that follows a pattern.
110
Philip S
- Jan 3, 2023
- 2 min
Accounting Skills for Non-Accountants
The reality of being a successful business manager or owner is having a solid grounding in talking and understanding the language of account
80
Philip S
- Dec 30, 2022
- 2 min
How cash flow forecasts can help you
Managing cash flow is a vital part of running a successful business. Some business owners think managing cash flow simply means keeping...
100
Philip Seigel
- Dec 29, 2022
- 7 min
What is Power Query, Power Pivot, Power BI
…and why do you need them? The terms “Power Query,” “Power Pivot,” “Power BI,” and other “Power” terms often appear in articles and...
90
Philip Seigel
- Dec 28, 2022
- 1 min
Mastering Excel: Impress Your Boss
By adding one or more of these tricks to your skillset, you'll improve productivity, become a wizard at distilling and analysing data and be
90
Laura Dee
- Dec 1, 2022
- 1 min
Power BI Sample Job Interview Q&A
Think you know your DAX from your DBA, your metadata from your multi-dimensional? Prepare yourself with questions (and sample answers)...
110
Philip S
- Nov 18, 2022
- 2 min
Accounting Job Interviews. Here are some tips...
Preparing for an accounting job interview is important to help you stand out from other candidates and make a good impression. Here are...
60
Philip S
- Nov 13, 2022
- 2 min
Watch Out! Common Bookkeeping Errors
With the growing reliance on affordable and semi-automated accounting and payroll software, it is still too easy to fall into the trap of...
90
Philip S
- Nov 10, 2022
- 4 min
Cash vs. Accrual Accounting Explained
Cash and accrual accounting are two different methods of accounting that are used to record and report financial transactions. Cash...
70
Guest Writer
- Oct 23, 2022
- 2 min
Data Analytics are Catching-On
Australian businesses that leverage customer and staff data can raise their revenue by about 10 per cent, according to an...
40
Philip Seigel
- Oct 14, 2022
- 2 min
10 Steps to Protect You From Ransomware
Ransomware attacks can be devastating, encrypting your files and rendering them inaccessible until a ransom is paid or a clean system...
60
Philip Seigel
- Sep 29, 2022
- 3 min
Understanding & Dealing with Excel Errors.
From the dreaded #DIV/O to the frustrating #VALUE! annoying and unexpected error alarms, this article will help you understand and avoid...
210
Gary W.
- Sep 24, 2022
- 4 min
Easily Trap & Handle Excel Formula & Function Errors
IFERROR() is a basic Excel function that can be used to catch and handle errors in a spreadsheet program. It is a very useful tool for...
40
Laura Dee
- Jul 8, 2022
- 1 min
XLOOKUP vs. VLOOKUP
XLOOKUP is considered to be an improvement over VLOOKUP because it has several additional capabilities that VLOOKUP does not have. Here...
60
Philip S
- Jul 8, 2022
- 4 min
Accounting Terminology Explained (Briefly)
General Ledger was not a military officer and a Trial Balance has nothing to do with a court case. We've created an 'Accounting...
60
Emily
- Jun 9, 2022
- 2 min
Excel's New XLOOKUP Function
XLOOKUP is a function in Microsoft Excel that allows you to look up a value in a range of cells and return a corresponding value from a...
30
Philip S
- May 13, 2022
- 2 min
Why the Balance Sheet is Important
Most small businesses look at the profit and loss statement regularly, but many don’t understand the importance of the balance sheet....
50
Guest Writer
- Jun 14, 2021
- 1 min
Cultivating Digital Skills
According to research from RMIT Online and Deloitte, 87 per cent of Australia's jobs now require digital skills. Digital tools are...
50
Philip S
- May 13, 2021
- 3 min
An Excel Covid-19 Debacle
In October 2020, the incompetent use of an outdated version of Excel resulted in nearly 16,000 unreported Covid-19 positive cases in...
70
News & Blog Articles
bottom of page