Search results for: Microsoft Excel

Creating graphs

Learn how to create visually compelling graphs in Excel 2016, unlocking a powerful method of data representation and interpretation

Practise exercise

Immerse yourself in practical Excel exercises designed to consolidate your knowledge and sharpen your skills in spreadsheet handling and data manipulation

Repeating formulas

Understand how to replicate formulas in Excel 2016, simplifying complex calculations and enhancing your spreadsheet's functionality.

Sorting & Reordering

Unearth the potential of Excel's sorting and reordering functions, optimising the way you organise data by name, price, or date for efficient data analysis

Splitting cell contents

Discover how to split names into separate columns in Excel 2016, enhancing your data organisation for better readability.

Removing duplicates

Learn the easy steps to remove blank rows and columns from your Excel spreadsheets, leading to cleaner, more organised data presentation.

Remove blank rows & columns

Learn how to efficiently delete blank rows and columns in Excel 2016 spreadsheets to maintain a tidy and organised workspace.

Date & currency formatting

Master how to clean-up date and currency formatting in Excel 2016, presenting your data in a professional and consistent manner

Cleaning up messy spreadsheets

Acquire skills in tidying up messy spreadsheets in Excel 2016, enabling efficient data analysis and an organised data presentation

Using pre-made templates

Learn how to utilise pre-made templates in Excel 2016 to expedite your workflow and enhance your document's professional appearance

Printing & exporting PDFs

Learn how to print your Excel quotes or invoices to a single page, and how to export them as PDFs for emailing - an essential skill for business communication

Creating a template

Learn how to design professional quote or invoice templates in Excel 2016, significantly streamlining your financial documentation process.

Borders & lines

Master the technique of adding borders and lines around cells in Excel 2016, a simple yet effective method for enhancing data readability and aesthetic appeal

Date formatting

Master how to display the date correctly in Excel 2016, ensuring clarity and consistency in your data representation

Cheat Sheet & Shortcuts

We will show you some interesting and useful cheat sheets and shortcuts to improve your workflow with in Excel. Boost productivity in Microsoft Excel.

Profit & loss spreadsheet

Discover how to construct a Profit & Loss spreadsheet in Excel with drop-down menus, a crucial skill for business financial management

How to make a Pivot Table

Dive into the versatile world of Pivot Tables in Excel 2016 with our beginner-friendly guide, expanding your data analysis capabilities

Graphs for Word, PowerPoint, InDesign & Illustrator

In this lesson we’ll look at how to create charts in Excel for use in Word & PowerPoint, InDesign & Illustrator documents.

Formulas to calculate sales tax

Learn how to use Excel formulas to calculate quotations or invoices with sales tax, GST, or VAT, significantly enhancing your financial management skills

Adding text & aligning cells

Discover how to add text to your Excel quotes and align text and numbers effectively, ensuring clear communication and professional presentation of data.