Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Microsoft Excel 2016 Bootcamp - Zero to Hero Training

Daniel Scott, Adobe Certified Trainer & UI/UX Expert

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
24 Videos (1h 54m)
    • Introduction

      1:43
    • Exercise Files

      1:44
    • Setting up a US letter or A4 sized page in Excel 2016 so it can be printed

      2:37
    • How to add an image or logo to an Microsoft Excel 2016 spreadsheet

      1:39
    • Adding text to our Excel Quote & aligning text & numbers

      7:16
    • How to display the date correctly in Excel for the month first or month second formats

      3:43
    • Adding borders & lines around cells in Excel 2016

      5:12
    • Use these formulas to calculate a quotation or invoice with sales tax GST or VAT in Excel 2016

      5:26
    • Making a quote or invoice template in Excel 2016

      4:48
    • Printing your Excel quote or invoice to one page plus exporting a Excel PDF for emailing

      3:52
    • Using pre made templates

      1:42
    • Cleaning up Tidy up messy spreadsheets in Excel 2016

      4:02
    • Cleaning up date formatting & currency formatting in Excel 2016

      3:56
    • Remove blank line rows columns from Excel 2016 spreadsheets

      2:25
    • Remove duplicates in Excel 2016

      4:27
    • Splitting or seperating names into separate columns in Excel 2016

      4:17
    • Sorting & Reordering a Excel spreadsheet by name price or date

      2:29
    • Repeating formulas in Excel

      2:31
    • Practise exercise

      2:29
    • How to create a graph in Excel 2016

      7:33
    • Create chart in Excel for use in Word & Powerpoint, InDesign & Illustrator documents

      7:22
    • Microsoft Excel Pivot Table Tutorial for Beginners Excel 2016

      11:00
    • How to make a profit & loss spreadsheet in Excel with drop down menus

      17:23
    • Excel 2016 Cheat Sheet & Shortcuts

      4:29

About This Class

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. Click here to grab your awesome Exercise Files. 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.

18 of 18 students recommendSee All

Fantastic. Dan is a wonderful teacher, clear and concise. Good length. I'm pretty experienced in Excel but you never know where you're going to learn something you missed, or just haven't heard about yet, and I wrote down about 10 great tips I picked up from this course. Thanks, Dan!
Exactly what any excel user needs: practical, simple tools that are applicable to the work we're all doing. Great course, highly recommend it.
Just what I needed! Thank you Dan.

371

Students

--

Projects

Daniel Scott

Adobe Certified Trainer & UI/UX Expert

I'm a Digital Designer & teacher at BYOL international. Sharing is who I am, and teaching is where I am at my best, because I've been on both sides of that equation, and getting to deliver useful training is my meaningful way to be a part of the creative community.

I've spent a long time watching others learn, and teach, to refine how I work with you to be efficient, useful and, most importantly, memorable. I want you to carry what I've shown you into a bright future.

I have a w...

See full profile