Skip to content
Ask Accounting

Ask Accounting

Financial Accounting Services

  • Home
  • About Us
  • Financial Services
  • News & How-To Guides
  • Contact Us
  • Client Portal

Excel

Excel, How-To Guides

Xero Account Transactions report

One of the great things about Xero is that they are always improving the programme. Recently, they have made changes to the Account Transactions report, a report that we use all the time in schools. I’ve detailed the changes below, and included some recommendations.

Continue reading “Xero Account Transactions report” →
March 1, 2023November 2, 2023Excel
Excel, How-To Guides

Excel Tip – Inserting Blank Rows

Ever had to insert blank rows in between existing rows in a data set? Well, you could insert rows one by one, but here’s a quick, easy way to do it.

Continue reading “Excel Tip – Inserting Blank Rows” →
August 9, 2021August 9, 2021Blank rows, Excel
Excel, How-To Guides

Find and Replace in Excel

You probably know that you can use Find and Replace to replace multiple occurrences of text.

Ctrl-F, and then click on the Replace tab, or Ctrl-H to go straight to the Replace tab.

Continue reading “Find and Replace in Excel” →
August 28, 2020May 30, 2024Excel, Hints & Tips
Excel, How-To Guides, Hubdoc, Xero

Our first newsletter!

Writing to you from the depths of lockdown in Auckland. Hope that all of you are keeping safe, wherever you are and whether you’re still working at school or at home.

Continue reading “Our first newsletter!” →
August 24, 2020April 24, 2021Hints & Tips, Hubdoc, Newsletter, Xero
Excel, How-To Guides

Using the Find command in Excel

The easiest way to find specific text is to type Ctrl-F.  The find box will pop up.

Continue reading “Using the Find command in Excel” →
August 20, 2020May 30, 2024Excel, Hints & Tips

Posts navigation

Older posts

Recent Posts

  • Making Hubdoc work for you June 27, 2025
  • Quick Credit Notes in Xero March 15, 2024
  • How To Merge Duplicate Contact Records March 6, 2024
  • Capital Works Projects In Xero February 25, 2024
  • Fraud and Verifying Bank Account Alterations January 14, 2024

Archive

  • June 2025 (1)
  • March 2024 (2)
  • February 2024 (1)
  • January 2024 (1)
  • December 2023 (1)
  • November 2023 (1)
  • October 2023 (1)
  • August 2023 (1)
  • April 2023 (1)
  • March 2023 (1)
  • August 2021 (1)
  • May 2021 (3)
  • April 2021 (1)
  • March 2021 (1)
  • October 2020 (2)
  • August 2020 (3)
  • July 2020 (1)
  • June 2020 (1)
  • May 2020 (2)

Categories

Book a Training Session Today!

We want our clients to have the knowledge they need to understand their school finances and the skills to make their lives easier. That’s why we offer specialist training in accounting practices and concepts, and in Xero and Excel, so you have the skills and knowledge you need to work faster, smarter and with confidence.

Follow us

  • facebook
  • instagram

Enquiries

Nellie Shaw 027 612 9537

© Copyright Ask Accounting 2020