Hills Computing & Training Services

Microsoft Office Training and Data Analysis

Focused on Productivity

Rather than just teaching the standard information, Hills Computing & Training Services focuses on those features, tips and tricks which will help you and your staff save time and be more productive.

Focused on Making Your Data Work for You

We can create Excel tools and workbooks, including pivot tables, formulas, macros, and dashboards to help you make sense of your data and apply the analysis to help your business grow.

Focused on Making Your Life Easier

We can also provide assistance in automating Excel workbooks, creating Word documents, developing and remediating Access databases.

  • Device Content Image
  • Device Content Image
  • Device Content Image

Since our inception, Hills Computing and Training Services have been focused on providing a customised solution for small businesses in Roleystone, Perth and Bunbury.

Our focus is on meeting your needs and solving your issues, not just "delivering training". We use your examples and will work with small groups and individuals within your organisation to provide targeted training and solutions.

With over fifteen years experience in delivering training to all levels within an organisation we have the knowledge and the experience to help your staff to be more productive.

All of our trainers have Certificate IV in Training And Assessment (TAE40110)

User Avatar

"Our instructor was so patient and had all the answers. Excellent."

Principal Instructor

Julie Dall is our principal instructor across the Microsoft Office suite. She has been using Microsoft products since the mid-90s and has been training since 2000.

Office Excel Word OneNote PowerPoint

Productivity Courses

Click on the headings below to see a sample of the productivity courses we offer:

Excel - Quick Tips
Removing Duplicates, Extracting Unique Values, Quick Charting, SUMIFS function, Duplicating a Sheet, Moving & Selecting Data, Reordering Columns, Changing Formulas to Values, Splitting Data, Combining Data, Conditional Formatting
Highlights of Excel
Highlighting Duplicates, Removing Duplicates, Separating & Combining Data, Formatting Data that meets a Criteria, Using Formatting to Compare Data, Sorting/Filtering Data, Sparklines, Flash Fill, Formulas for Counting and Summing based on Multiple Criteria
Excel - Getting Started with Excel
This session covers the basics of Excel for those who aren't familiar with the product. Focusing on terminology, entering of text and numbers, understanding dates, introduction to formulas and functions, relative Vs absolute referencing
Excel - Working with Data
Highlighting/Removing Duplicated Data, Sorting & Filtering, Conditional Formatting, Subtotalling, Using Functions to Count or Sum Data Based on Criteria, Introduction to Pivot Tables, Introduction to Charting
Excel - Working with Multiple Worksheets
Linking between Worksheets, Linking between Workbooks, Editing Links, Breaking Links, Consolidating Data from Multiple Worksheets
Excel Tables
Understanding Tables, Formatting Tables, Adding Total Lines, Creating Calculated Columns, Removing Duplicates, Filtering using Slicers, Summarising with PivotTables, Adding Data, Resizing Tables, Resetting to Range
Excel - Introduction to Charting
Creating Charts, Formatting Charts, Adding Chart Elements (Title, Labels, Trendlines), Adding Additional Data, Using Two Axes, Moving Charts, Copying Charts and Changing Data Source, Creating a Chart Template, New Chart Types - Sunburst / Treemap / Histogram / Waterfall
Excel - Creating Drop Down Lists and Fill in Forms
Restricting Entry to Cells, Creating Error Messages, Validating Existing Data, Returning Related Data, Protecting Sheets
Excel - Pivot Tables
Understanding Pivot Tables, Preparing your Data, Creating Pivot Tables, Grouping Data, Using Slicers, Inserting a Timeline, Creating Report Pages, Adding Additional Tables
Excel - Working with Dates and Times
Understanding Excel Dates and Times, Formatting Dates and Time, Calculating with Dates and Time, Troubleshooting
Excel - Presenting Data Visually
Conditional Formatting, Sparklines, Charts, Smart Art
Excel - Using Ranges and Creating Dynamic Ranges
Understanding Ranges, Creating Named Ranges, Using Range Names in Formulas, Printing a List of Names in the Workbook, Understanding Name Scope, Using Named Ranges in Data Validation Drop Down Lists, Creating and Using Dynamic Ranges
Excel Functions - The Basics
Understanding Formulas, Understanding Functions, Relative Vs Absolute Referencing, Using Basic Functions: SUM, COUNT, COUNTA, MIN, MAX, AVERAGE, Using the AutoSum Icon
Excel Functions - Beyond the Basics
Functions covered: IF, Nested IF, IFS, AND / OR, COUNTIF/SUMIF, COUNTIFS/SUMIFS, VLOOKUP, Error Handing Functions, IFNA, ISNA
Excel Functions - More
Excel Lists
Splitting data from Single Columns into Multiple Columns, Using Flash Fill to extract and manipulate data, Extract data using functions (LEFT / RIGHT / MID, LEN, FIND), Manipulating Data using functions (PROPER / UPPER / LOWER, CONCATENATE / CONCAT / TEXTJOIN), Highlighting Duplicate Data
Excel - Introduction to Macros
Understanding Macros, Using the Macro Recorder, Understanding Relative Vs Absolute Referencing, Working with Workbook, Worksheet and Range Objects, Interacting with the User
OneNote - Overview
Understanding OneNote:, Notebooks, Sections, Pages, Note Containers, Formatting bullets and numbers, Formatting Headings, Adding text - writing, Using Ink to Text, Searching (both text and writing), Copying and pasting from Internet, Adding Tags
OneNote - Working with Tags
Using Existing Tags, Customising Tags, Creating New Tags, Finding Tags, Creating Tag Summary Page
Outlook - 10 Quick Tips
Rules, Quick Steps, Ignore, Reply with Meeting, Templates, Signatures, Create a new item from your clipboard., Limit desktop notifications., Create search folders., Views
Outlook & OneNote for Managing Meetings
Linking appointments to pages in OneNote, Managing Attendance, Sharing with Participants
Outlook - Rules and Quick Steps
Understanding and Using Rules , Understanding and Using Quick Steps
Getting Started, Understanding Layouts, Adding Slides, Adding Text, Adding Pictures and other Content, Working with Graphics, Adding Screen Recordings, Applying Animations, Working with Transitions, Creating a Slideshow, Creating Handouts
PowerPoint - More
Working with Complex Animations, Using SmartArt to improve Presentations, Working with Audio, Inserting Video, Printing Speaker Notes
Word - Create Visually Compelling Documents
Using Styles / Style Sets and Themes, Inserting Cover Pages, Text formatting, Enhancing images, Clippings & Screen shots, SmartArt
Word - Creating and Modifying Tables of Contents
Prepare headings so they'll be included in the TOC, Generate and update a TOC, Change TOC settings, Modify TOC styles, Remove a TOC
Word - Quick Parts
Working with Quick Parts:, Inserting Existing Objects, Inserting Fields, Customising Fields, Creating New Quick Parts, Deleting Quick Parts
Word - Understanding and Working with Sections
Inserting Continuous Section Breaks, Inserting Next Page Section Breaks, Controlling Headers and Footers across Sections, Controlling Page Numbering across Sections
Word - Using Styles
Understanding Styles, Applying Styles, Modifying Styles, Creating Styles, Creating a Table of Contents based on Styles, Using Styles across Documents
Word - Working with Tables
Creating tables, Converting Text to Tables, Modifying Table Structure, Using Tables to Control Layout, Adding Formulas to Tables, Formatting Tables, Converting Tables to Text
Word - Using Mail Merge
Creating a Mail Merge Letter, Merging with an Excel List, Filtering Recipient List, Adding in standard data if data missing in merge source, Merging to Letters, Merging to Emails

Contact Us

Phone: 0435 939 210

Email: julie@hcts.net.au