Svoboda | Graniru | BBC Russia | Golosameriki | Facebook
SlideShare a Scribd company logo

9 handy Excel demos

•
•

This document provides tips to improve Excel skills in order to work faster, look more professional, impress your boss, and grow your career. It includes nine demonstrations on better using Excel covering topics like custom formatting, moving averages, combining annual and monthly data, using trial balances, identifying and removing duplicates, data relationships, flexible budget models, toggling macros, and consistent styles. Videos and other resources from CPA Australia on Excel for finance professionals are also promoted.

1 of 15
Download to read offline
Work faster, look professional, impress your boss and grow your career Work faster, look professional, impress your boss and grow your career with these Excel tips. EXCEL YOURSELF intheblackleadership . strategy . business Your essenTiaL business updaTe
HEREYOU’LLFINDA COLLECTIONOFNINEHANDY DEMONSTRATIONSONHOW TOUSEEXCELBETTER. CLICKTHROUGHONEACH SLIDETOLEARNMORE.
Marcus Small CPA Australia’s webinar presenter TheSmallMan.com “ “ Leveraging Excel’s time-saving, quality-enhancing, multipurpose functions will help generate real time business critical data. As such, mastery and knowledge of Excel’s inner workings will help distinguish you in your finance career.
CUSTOM FORMATTING MADE EASY How to display a numeric code with dashes between three sections and also be able to do calculations using code. READ MORE
HOW TO MASTER MOVING AVERAGES IN EXCEL A formula to allow the user to specify how many months to average in a moving average calculation. FIND OUT MORE
COMBINE ANNUAL AND MONTHLY DATA IN EXCEL WITH THESE SIMPLE STEPS Create a single chart that has both full year and monthly measures. READ MORE
HOW TO USE TRIAL BALANCES TO STREAMLINE DATA IN EXCEL Suggestions for consolidating ledgers when an organisation has multiple entities with separate general ledgers. FIND OUT MORE
IDENTIFY AND REMOVE DUPLICATES IN EXCEL How to remove duplicates when your data is across several fields and is incomplete. FIND OUT MORE
EASY STEPS TO MAKE DATA RELATIONSHIPS WORK IN EXCEL FIND OUT MORE Beyond VLOOKUP: Find out how you can easily report on multiple tables in Excel 2013.
SIMPLE TIPS TO USE FLEXIBLE BUDGET MODELS IN EXCEL READ MORE Ways to convert a single budget model into a multi- scenario budget model.
HOW TO CREATE MACROS THAT TOGGLE IN EXCEL Discover the secret to using one macro to turn an option off and on. FIND OUT HOW
HOW TO USE CONSISTENT STYLES IN EXCEL Easy ways to achieve consistent formats throughout a file. READ MORE
USEFUL ‘HOW-TO’ VIDEOS • Add substance with styles • How to spot the doubles in excel • How to custom format in excel WATCH NOW
MORE RESOURCES FROM CPA AUSTRALIA: • Microsoft Excel for finance professions • Workshops • Online • Webinars FIND OUT MORE
INTHEBLACK.COM facebook.com/ ITBmagazine twitter.com/ ITBmagazine linkedin.com/ company/inthe black-magazine Newsletter intheblack.com/ newsletter

More Related Content

9 handy Excel demos