Adding images & logos

Questions

You need to be a member to view comments.

Join today. Cancel any time.

Sign Up

Course info

24 lessons / 2 hours

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.

Course duration 2 hours

Daniel Scott

Daniel Scott

Founder of Bring Your Own Laptop & Chief Instructor

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

Download Exercise Files Download Completed Files

Transcript

Welcome, in this video we're going to look at bringing in images into Excel. We're going to re-size them, and put them in the top left of our quotation. So let's go and do that now.

It's super easy, doesn't really matter where you click, because images can be moved around anywhere you like. Click on the cell, roughly where you want it to go. And then go up to 'Insert', along towards to where it says 'Pictures'.

Go off and find your pictures. If you're working with my course, go and download the exercise files. There'll be a link in the description, along with the comments, on this page. And in 'Exercise Files', we're going to use this Bring Your Own Laptop, or BYOL logo. Bring it in. It's going to come in at whatever size it was created at. It's quite a big image here. So I'm going to select anywhere, and use the bottom right corner. And I'll just go click, hold, and drag.

We're going to drag up towards the top left corner. And you can re-size it. So I'm going to get it to a more appropriate size for our quote. About there. And that is how you bring in an image.

Now, to move it around, you just click anywhere, but the edges. It doesn't really matter, they don't sit in cells like text does. You can put it anywhere you like. You can't put it up past the margins that we set earlier. So if you want to have it a bit further up here, you're going to have to go back into your 'Page Layout', go to 'Margins', and you're going to have to go to 'Custom Margins', we'll just make 'Narrow' margins. And bring it close to the edges here, depending on how you want to do. I'm going to put my ‘Margins' back to 'Wide'. And still in the top left hand corner there.

Great, that's it. Let's go in the next video, and start adding some of our text for our quote.

  • Powered by Marvin
  • Terms of use
  • Privacy policy
  • © Bring your Own Laptop Ltd 2024