Have you seen our new Excel Quiz feature? Look at the bottom of any Tip & Tricks page and see if you can answer them. Much more coming soon!
Training, Tips, Tricks
Below some of our latest Excel tips and tricks.
- Method to avoid nested IF statements
- Remove filter item WITHOUT scrolling through whole list
- Advanced Excel Face2Face and Virtual-6-8 June 2022 (See Course Outline)
- Budgeting/ Financial Modelling Face2Face and Virtual-14-15 July 2022 (See Course Outline)
- Column chart without gaps
- Intermediate to Advanced Online Excel course
Consulting
Below some case studies of the consulting we offer. We are looking for contractors to assist with overflow work. Please reply to this email if you are available for some part time work.
- Automating existing Excel spreadsheets
- Property company management accounts
- Reuters Excel Templates
- IPP Financial Models
YouTube Excel Training
Become a subscriber and watch a new Excel tip every weekday with your coffee- AuditExcel YouTube channel.
Solving for Excel’s weak points
MS Excel is brilliant, but there are 2 things that you may need which Excel CANNOT do very well.
For these there is a little help:
- Learn how to find spreadsheet errors– Find the errors in your spreadsheet
- Easily import PDF’s into Excel – Import PDF’s into Excel
Contact Us
If you need any:
- MS Excel Training (all levels), or
- Spreadsheet Consulting assistance by MS Excel experts
feel free to contact us.
Keep up to date/ Help Others
If you want to be informed immediately of any new tip, trick or video clip please follow us on YouTube, Facebook, Twitter, Instagram or LinkedIn.
If you have missed a newsletter or want to find an old tip, look at the Newsletter Archive.
If you find these newsletters useful, please help us grow by telling others