Search Results

Our most popular onsite course that is Ideal for most regular Excel users. The course focuses on analysing data and presenting data. The first modules cover the most popular analysis functions including SUM, COUNT, IF and lookup functions. Later modules in this course cover Tables, Charts, Conditional Formatting along with Pivot Tables. Learning Objectives At the end of the course participants will be able to build a spreadsheet with functions and analyse and present large sets of data. Prerequisites This course is designed for people that are already using Excel multiple times in a week. They will be familiar with navigating in Excel and will have had some exposure to calculations, charts and larger data sets. This course covers all the important features in Excel in half a day, a manual and exercise file is provided, and attendees are encouraged to practice afterwards to retain their learnings. • Excel formula construction using addition, subtraction, multiplication, and division. • Understanding and controlling the order of operation • Using Functions to make formula construction faster (SUM, AVERAGE, MINIMUM, MAXIMUM & COUNT) • Using AutoSum • Difference between a formula and a function • What does absolute and relative referencing mean? • Switching between absolute and relative referencing • Understanding how IF function operates • Create an IF Statement • What is V Lookup? • Create a V Lookup function. • What is X Lookup? • Create a X Lookup function • Using the Quick Analysis tool set to create charts, sparklines, and apply conditional formatting • Creating and editing a Chart • Creating a chart with a secondary axis • Embedding a char in Word or PowerPoint • Convert data to a Table • Features and benefits of a table • Sorting and Filtering in a Table • Using Conditional Formatting to highlight data • Using a table to create a Pivot Table

Spend 60 minutes with a Projectworks expert to help get the most from your software. We can focus on: - Checking WIP - Creating reports - Custom Templates - Using Budgets - Using Resources After booking your consultant will make contact to discuss your specific requirements

Details During this 120 -minute session attendees will learn how to construct basic formula, enforce the order of the calculation and quickly create simple functions. Key topics covered in this course: How to construct formulas Understanding and controlling the order of calculations Using Absolute vs. Relative Formulas Function Construction (SUM, MIN, MAX, AVERAGE & COUNT) Quick Analysis

There are two important updates that will automatically rollout on October 1, 2024 Brand Change The Templafy brand is changing and will be updated in the application.  If you are on the general release channel (which most are) the update will happen automatically starting October 1st. There is no change to the user experience, just visual changes to the Templafy buttons, and pop ups. A I Assistant included for all Templafy Library Users During October the AI Assistant will be enabled and included in the subscription for all Templafy Library users. Key features include: Default Prompts The ability to create your own prompts Ability to incorporate your own tone of voice Lean More: Product Overview: Support Article: User Videos: Templafy Academy New courses on AI Assistant, use access code "templafyadmin" Important Points Templafy AI will be turned on automatically in October, if you do not want this to happen you need to opt out Templafy AI uses Azure Open AI, see detailed security details here :  Ripped Orange Templafy AI Assistant Webinar   We are running a webinar on Monday 30 September at 2pm NZ / 11am AEST time to demonstrate and answer any questions.

Download Exercise Files: Shared File

With Workflow Max by Xero being closed on June 26th, it’s important to close the account correctly and export your data. After 26 June 2024 you won’t have any access to Workflow Max by Xero and the data in it. Step One – Exporting Your Data It’s best to export everything you need, this can be done from Business/ Settings / Export All Data Select Document Export Account Data Export (Chose both CSV and XML) File Export (Use this if you want a list of clients) Custom Template Export Once you have these safely tucked away in Microsoft 365 or Dropbox you can close the account Step Two – Closing your Account Remove the mail to Workflow Max email address Jobs / Collaboration Manager / Configuration Cancel Your Subscription Business / Subscription / Cancel Subscription (If you pay someone else for Workflow Max then get them to do this)

Templates Template Distribution Setup of Organisaton asset library in Microsoft 365 Have a set of great templates but people are not using them? Setting up an organisation asset library is an easy way for Microsoft 365 users fine and use the latest templates across your organisation. Includes Initial discovery session Setup of Organisation asset libraries Population of content to library Quick guide for content administrators Quick guide for all users Investment Indication 2-3 hours ($370 - $550) Get in touch Ripped Orange helps businesses achieve the productivity gains that software promises. We have helped business users achieve this through training, coaching, or adapting selective solutions to better meet their needs. We understand technology, but more importantly, we understand the benefits a business can achieve by using it well. First Name Last Name Email Phone How can we help? Submit

Excellent for manufacturers and more | Job Management System Workflow Max Alterntives WorkGuru More Manage all your timesheets, stock control, purchasing and invoicing in one easy to use platform. It’s an all-in-one solution that eliminates time consuming paperwork and allows you to ensure your jobs are profitable. Workguru is ideal for firms that sell items and time. https://www.youtube.com/watch?v=AlhOqISAVjY Nothing to book right now. Check back soon. Over 10 years of Job Management Experience Coaching Save time and learn from experienced experts Reports Get setup with the right reports to run your business Custom Templates Custom branded Quotes, Invoices and Job Briefs Process Manual Custom Process manual designed to support long term success Our services Ripped Orange have been using Workflow Max and other job management systems internally for over ten years. Because we use the software daily, we are uniquely posited to set up and support your organisation. Our capabilities We are experienced in: Custom Template Design Setup Review Workflow Max Integrations, including: Xero, Dropbox, Google SuiteFiles, Planright Xero - Integration Coaching Process Manual Design Our experience We focus on ensuring any system is a good fit for your business. We have implemented systems across a wide range of industries including: Engineers Lawyers Builders Roading Contractors Architects

Templates PowerPoint Template Set PowerPoint template with multiple slide masters and layout Everything you need to create consistent and great looking PowerPoint presentations. Includes: Custom colour theme Two slide master sets 10 slide layouts Custom colour theme Deliverables: Initial design discovery session One PowerPoint template with five sample slides 10 page report or proposal template Quick guide on how to use the template Investment Indication 4 - 6 hours ( $750 - $1000) + style setup if required Get in touch Ripped Orange helps businesses achieve the productivity gains that software promises. We have helped business users achieve this through training, coaching, or adapting selective solutions to better meet their needs. We understand technology, but more importantly, we understand the benefits a business can achieve by using it well. First Name Last Name Email Phone How can we help? Submit