InstructorTayla Coman
TypeOnline Course
PriceRs.12495Rs.599
Buy NowBook Now

Course Overview

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 to turn uninspiring profit & loss statements into a good looking, easy to use documents.


Class projects

  • Create a quote & invoicing form.
  • Cleaning & formatting messy 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.

Who should attend

  • This course is designed for people who have little or no previous experience in Microsoft Excel. You will start right at the beginning and cover all the basics.
  • Only basic computing skills are necessary – if you can send emails and surf the internet then you’ve found the right training.
  • By the end of the course, you will be producing real world results with Excel.

What do you need?

  • No previous Microsoft Excel experience necessary.
  • You’ll need Excel 2016 installed on your laptop. The standard installation of Excel 2016 or the Microsoft Office 365 version is fine.
Section 1Overview
Lecture 1Introduction
Lecture 2All the files
Section 2HOW TO MAKE A QUOTE & INVOICING FORM
Lecture 3Setting up printable page sizes
Lecture 4Adding images & logos
Lecture 5Adding text & aligning cells
Lecture 6Date formatting
Lecture 7Borders & lines
Lecture 8Formulas to calculate sales tax
Lecture 9Creating a template
Lecture 10Printing & exporting PDFs
Section 3USING TEMPLATES
Section 4CLEANING UP MESSY DATA
Lecture 12Cleaning up messy spreadsheets
Lecture 13Date & currency formatting
Lecture 14Remove blank rows & columns
Lecture 15Removing duplicates
Lecture 16Splitting cell contents
Lecture 17Sorting & Reordering
Lecture 18Repeating formulas
Lecture 19Practise exercise
Section 5GRAPHS IN EXCEL
Lecture 20Creating graphs
Lecture 21Graphs for Word, PowerPoint, InDesign & Illustrator
Section 6PIVOT TABLES
Section 7HOW TO MAKE A PROFIT & LOSS SHEET
Section 8CHEAT SHEET & SHORTCUTS

Leave a Reply