Instructor Profile

Are you tired of spending hours formatting your documents? 

Styles are here to save the day! With consistent formatting throughout your document, you can create a professional look in no time. Plus, Styles can instantly create a Table of Contents that updates automatically as you make changes.

A Table of Contents is like a roadmap for your readers, giving them a high-level view of your document's structure and segments. It can include titles, descriptions, and page numbers for sections or chapters. And the best part? You don't have to create it manually - Styles does it for you!

But that's not all - indexing takes your document to the next level. By marking keywords and phrases and presenting them alphabetically at the end of your document with page numbers, you make it easy for readers to find what they're looking for and with automated indexing, you can index multiple documents in minutes.

If you want to take your reports, complex documents, and manuals from average to professional, including a Table of Contents and index is a must. Let Styles do the heavy lifting for you and watch your documents transform before your eyes.

Skills to effectively manage, present and communicate data are now vital in the competitive financial and business analysis fields and offer vast opportunities to expand accounting client services and career paths.

Microsoft Excel offers powerful 'market-leading' tools and features to equip you with the essential skill sets and practical abilities needed to gain a major market superiority in this rapidly growing frontier.

This power-packed 90-minute online course is presented by experienced Excel trainer and Business Analyst Ray Evans and includes professional courseware and student files.

Imagine impressing your team, executives and clients with your new skills, presenting data visually in engaging professional charts! Effective charting is a strongly “in-demand” and valuable skill to possess in government, private and education sectors.

Charts (graphs) can present information for decision makers and researchers in appealing presentations, making it easier to interpret data. A visually-oriented audience responds especially well to graphs and often understands the information better without complex tables and text.

With 16 chart types in MS Excel including the new funnel chart, there are many choices to present information in a clear, engaging, and professional manner. Each chart type has up to 7 sub-chart variations plus a massive range of formatting options and variations.

Maximize your use of this powerful Excel feature and take data analysis and interpretation to an effective and appealing level, helping your audience visualize and understand your information, research, and analysis. Charts emphasize key information and trends, make data presentation more convincing, and can provide a far clearer and more concise way of presenting information than displaying a bulk of numerical data and tables.

Join us for this informative and value-packed 90-minute webinar with your team to boost efficiency and maximize your return on investment’ in MS Office.

Linking between spreadsheets, workbooks, and applications offers huge efficiencies but needs a clear understanding to work accurately and avoid risks that linking can pose.

Understand and apply the power of linking techniques within Excel and other key MS Office applications to boost productivity and efficiency for you and your organization.

Object Linking and Embedding (OLE) makes content that is created in one location or program available in another program.

As an example, in Excel, you can link or reference to other cells in a worksheet or other worksheets, external workbooks, external files, and pages on the internet or your intranet.

Dynamic links ensure changes in source data, graphics, charts, etc. are reflected in all “dependent linked” files. Proficiency in link management is a vital marketable skill that equips you to master the linking of information using MS Office and MS Excel.

Plan and initiate your projects with confidence, knowledge and consistency.

Task scheduling is often the most challenging and important phase in projects and is critical to project success, achievement of deadlines, attainment of budgets and efficient use of resources. With Microsoft Project, you can represent the work breakdown structure by using task IDs or by assigning your own WBS code to each task.

Enter the world of professional project management. Forget scheduling on paper, whiteboards or spreadsheets, MS Project automatically re-calculates timelines and critical path saving you significant time! 

Understand the powerful capabilities of MS Project and how you can "work smarter... not harder".

Excel macros can automate and streamline tasks, eliminate repetition, and can potentially save you and your team thousands of hours year after year.

A macro is a term for a series of commands and functions that you store in a Microsoft Visual Basic module and can be run via your keyboard, ribbon or custom buttons whenever you need to perform the task(s) associated with those commands.

Harness this valuable feature in Excel to boost your efficiency, output and job satisfaction. Working with macros is not intuitive and requires clear explanation and demonstration of key principles to ensure your practical understanding.

This presentation will effectively help you understand and apply this powerful tool.

Pivot Tables are considered by many to be the most powerful data analysis feature in Excel, combining the ability to sort, filter, subtotal, calculate and chart data in minutes. 

A Pivot Table displays a summary of a selected data set in a condensed format of rows, columns, data fields and pages. These components can be “pivoted” with your mouse allowing you to expand, isolate, calculate, and group the particular data in real-time. This table empowers the user to view and analyse large amounts of information.

Pivot Tables are a “must have” reporting tool enabling quick business decisions, crucial in business, government and academic fields.

Pivot Charts provide added enhancement through the powerful graphical presentation of PivotTable data.

Ray Evans helps you to understand this power-packed capability of Excel and how you can create PivotTables in minutes “working smarter ... not harder”!