Skip to content
Julia the PC GP

Julia the PC GP

Individual support for your home and small business computing needs

  • Welcome
  • Sales
  • Support
  • Training
    • Resources
  • Tips & Advice
    • Articles
      • Handy keyboard shortcuts – Control key
      • Handy keyboard shortcuts using the Windows key
  • About Julia
    • Julia Info
    • Community
    • Testimonials
  • Enquire now
  • Sign up
  • Toggle search form

Tag: cashflow

Managing your money in Excel (Cashflow)

Posted on August 3, 2022August 3, 2022 By JuliaEEvans No Comments on Managing your money in Excel (Cashflow)
Managing your money in Excel (Cashflow)

Did you know that you can use Excel’s SUMIF feature to automatically generate a Cashflow spreadsheet? The screen below shows the one I use for monitoring my business income and expenditure across the year:- The 3 fields (Range, Criteria and Sum_range) enable Excel to constantly monitor them for any changes. This means that I change…

Read More “Managing your money in Excel (Cashflow)” »

Microsoft, MS Office

Recent Posts

  • Cloud storage on a budget
  • Viewing all open windows at a glance
  • Managing your money in Excel (Cashflow)
  • Calendar reminders by email
  • Using “Split Pane” option in MS Word

Recent Comments

  1. JuliaEEvans on Windows shortcuts
  2. Mary Vadala on Windows shortcuts

Archives

  • August 2022
  • July 2022
  • June 2022

Categories

  • Accessories
  • Internet
  • Microsoft
  • Mobile devices
  • MS Office
  • Online
  • Shortcut keys
  • Smartphones
  • Uncategorized
  • Windows 10
Tweets by juliathepcgp

Copyright © 2022 Julia the PC GP.

Powered by PressBook WordPress theme