What you'll learn:
- By the end of the course, you will be producing real world results with Excel.
Hi there, Welcome to this Microsoft Excel BootCamp. Together we’re going to learn how helpful Excel is in nearly every part of our professional lives.
This course is for beginners. You do not need any previous knowledge of Excel. We will stick closely to the powerful built in features of Excel and will not get bogged down in confusing code & complicated formulae.
This training course is project based. We start with a simple company branded invoice and explain how to calculate totals & tax. Using a complex and messy spreadsheet we will clean it up using Excels automatic features. With our new tidy data you’ll learn how easy pivot tables can turn long and hard to understand information into simple tables & beautiful graphs. Before you’re finished you’ll be making helpful drop down menus to help you fill out & sort your financial data.. You will learn how toturn uninspiring profit & loss statements into a good looking, easy to use documents.
Note:Mac users won't have the same experience of Excel as PCusers as the software is slightly different and doesn't contain the exact same features. For example theMac version of Excel doesn't currently support Flash fill so please make sure you're okay with missing out on some small things.
Class Projects
Create a quote & invoicing form.
Cleaning & formattingmessy imported data.
Inventory spreadsheet.
Pivot tables
Regional Sales Report
Profit & loss spreadsheet.
GST & Tax calculations
Graphs for use in Word, PowerPoint, InDesign & Illustrator
Creating spreadsheets that work within Word documents.
