Respected accounting expert and financial analyst Alan Salmon will again offer his full-day seminar on Microsoft Excel and Simply Accounting reporting.
Attendees will spend the morning learning over one hundred tips and tricks to enhance their ability to manage critical business information using Microsoft Excel. Right after lunch, Alan will expose you to the existing reporting in Simply Accounting where you will discover many reports and tools that have never been discovered by most Simply Accounting users. From there he will show you the secret of moving any Simply Accounting report directly to Excel and adding additional information and formatting. That is not a difficult task, but it is something most users redo every time they do the export. Alan will unveil the secret of only doing the setup once and then not having to do it again each time you export a report. Finally, Alan will show you the advanced technique of pulling data directly from Simply Accounting into Excel. For the last hour of the seminar Alan will return to Excel and share with you a series of techniques, such as macros to automate routine work, data filtering and pivot tables that enable you to quickly analyze Excel data.
By the end of the day with Alan you will accomplish far more in less time; create high-impact Excel reports that are professional and polished; plus get your accounting data into Excel where you can use it to effectively manage your business. You’ll do things right the first time. You’ll increase your efficiency with Excel short cuts; you’ll use formulas faster and more accurately; cut your data entry time in half; and you’ll have the numbers you need to effectively manage your business.
Alan Salmon has delivered this seminar to over 9,000 attendees during the last five years. The evaluations are always highly positive. One attendee wrote – "I work for a Not-for-Profit organization and for years I have been spending three days a month creating custom reports for our board of directors. After attending Alan's Excel for Simply Accounting User seminar, I can now do this in three hours instead of three days."
Seminar Highlights
Here are just some of the highlights of the day:
- Excel Tips and Advanced Techniques
- Exploring the reports in Simply Accounting
- Moving Simply reports into Excel and adding formatting and additional data
- Pulling data from Simply Accounting directly into Excel
- Learning the secrets to spreadsheet design
- Configuring and Customizing Excel
- Working with 3-dimensional workbooks
- Printing essentials
- Using macros to automate routing tasks
- The secrets to analyzing your data quickly and effortlessly
- Creating reports
- Creating charts and graphs
Why You Should Attend
- The shortcuts you will learn will immediately make you more productive
- The best way to learn new skills is to get out of the office
- The seminar workbook is your personal guide back at the office
- You will receive a CD containing all of the Excel files used in the seminar plus 5 valuable Excel files that pull directly from Simply Accounting
- Alan knows his stuff and how to share it with you. He is not just a trainer, but a business owner and consultant with over 25 years of experience
- The day is interesting and never boring
Seminar Information
This is not a hands-on workshop. Instruction is presented on a full-colour LCD projection system displayed on a large screen at the front of the room. All participants are provided with a comprehensive workbook which you will use after the seminar, a CD containing all of the files used in the seminar plus the bonus files that pull data directly from Simply Accounting. Please note this course is taught in English. Courses are also available in French.
Note: If you attended Power Microsoft Excel last year, you will not need to take this seminar.
Cost and Registration
Registration fee for the day is only $299 plus GST and must be prepaid. The fee includes the seminar, workbook with CD and refreshments.
The course runs from 8:30 a.m. to 4:30 p.m. Registration begins at 8:00 a.m.
Register now, or review a list of upcoming dates & locations.
