Questions
Student Gallery
Be the first to share something.
Course info
Overview
- 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.
- 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.
- 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.
Course duration 2 hours
Daniel Scott
Founder of Bring Your Own Laptop & Chief Instructor
I discovered the world of design as an art student when I stumbled upon a lab full of green & blue iMac G3’s. My initial curiosity around using the computer to create ‘art’ developed into a full-blown passion, eventually leading me to become a digital designer and founder of Bring Your Own Laptop.
Sharing and teaching are a huge part of who I am. As a certified Adobe instructor, I've had the honor of winning multiple Adobe teaching awards at their annual MAX conference. I see Bring Your Own Laptop as the supportive community I wished for when I was first starting out and intimidated by design. Through teaching, I hope to bring others along for the ride and empower my students to bring their stories, labors of love, and art into the world.
True to my Kiwi roots, I've lived in many places, and currently, I reside in Ireland with my wife and kids.
Downloads & Exercise files
Transcript
Hi there, now, as part of this class you'll get exercise files you can download, there'll be a little pop noise, and a link down here by Tayla, right there, and you can go and download those files to play along. What I've also got as part of this course is the completed files. What that means is that, at the end of every video that I do, there's a few videos in this course, at the end of every video I'll save my file to where it's at that it's working, so if you're doing it, and yours doesn't quite work, or you're not sure how I actually did something, you can check it against the completed file to see the difference between yours and my one. Now, there'll be a link on every video to those particular files.
The other thing that's quite useful is the cheat sheet. So I've made, both the video version, and a printable PDF version, so you can check out this link here, and that will get you to the printable version, where you print it off, stick it off next to your desk, be awesome. There's a video version, it's one of our last videos in this course.
Now the last thing is something I want from you, and it's a review. Now it's a bit early for reviews I know, but whenever you feel it's time, post a review, post a comment. Thumbs Up, Text Share, whatever the platform that it is, they will use interactions, like reviews, or shares, or likes, as a way of determining how good a video is, so the more reviews I get, the better that video does, the better I do as a trainer. Whenever you're ready, leave a review, be honest, go to bad, leave a review, actually no, don't leave any bad reviews. I lie.
That's it. So, here's the files, you've got the cheat sheets, post a review, let's get on with the course.
