This is a brief summary showing you the steps in working with the app – a set of screen shots is used in this video. There are a few shortcuts and tips that you’ll definitely find useful. I’ve used this video in many classes – if you are using this app, make sure you are on a SECURED network! Happy selling!
Windows 10 – brief tutorial on moving/sizing apps, putting them into groups, and personalizing your windows 10 screen – this is a quick video that shows you a few basic tips – much easier to watch this video than to read 10 pages of instructions! Enjoy!!
This video (done in version 2013, yet applicable to earlier/later versions) shows you how to do subtotals in a spreadsheet. This example has over 400 rows – we need to determine the pay for a group of subcontractors for the work they’ve done for our company. By sorting and doing subtotals, we can get the payroll done in a few minutes.
Some tips on how to print the spreadsheet are included.
This video shows a few of the new features in version 2016 – if you’re providing visuals, there are some very exciting techniques to display images.
I apologize for the watermark on the video – I use Camtasia which is a great program – however if you’re using version 7, it will NOT work in Windows 10 (ugh). I am saving up my $$ to do the upgrade. As I’m not making any money or using this for commercial purposes, this is ok.
If you wish to learn Excel or improve current skills (and add a few intermediate ones), this class that I developed will definitely help. It is in 12 modules in which you can learn skills in 15-45 minutes (depending on your familiarity). Each lesson is self contained and includes written instructions and videos to demonstrate what is taught.
This class is offered through Top Hat, one of the top producers of online course materials for higher education throughout America and Canada
Below is an outline of what this class consists of:
Lesson 1 – Introduction – You’ve been hired to be the payroll manager and need to create the payroll for The Daily Planet. This means calculating the gross pay, withholding taxes, and what they will be paid.
Lesson 2 – Managing expenses – determine the car you can afford with its monthly payment and using goal seek. You just got a job that pays $62,000 a year and can afford to spend 19% of your income on the vehicle.
Lesson 3 Formatting tips – using the format painter, cell styles, creating your own cell styles, and keyboard shortcuts
Lesson 4 Absolute and relative references – this lesson is definitely a bit geeky yet you will learn a lot in this by knowing whether to lock in a cell, a column, a row, or none at all. Taught in the first lesson, this build upon this even more as you’ll do some complex formulas.
Lesson 5 Working with large worksheets – discover how to move around it quickly using the keyboard instead of the mouse. Learn how to sort and output data. Alphabetize the data or use filters to view necessary information. Within minutes, you will do another payroll of over 400 records for many people, including print set up.
Lesson 6 Charts – Graphically present your data – taught in version 2013/365, there are some differences between this and earlier versions. They are essentially the same with a few enhancements with the quick analysis tool in 2013. In addition, discover the differences between the XLS (2003 and earlier versions of Excel) and XLSX (2007 to present).
Lesson 7 Vlookup and Naming Ranges – learn how to do a look up of data so that calculations or display of information can be presented. There are two examples, one determining cost to ship based on size of item, the other will be a gradebook. In addition, learn how to name a range of cells. A range name such as Insurance_Value is much easier to work with than the absolute range of $B$12:$D:$19.
Lesson 8 Miscellaneous and useful tips – Put a password on a spreadsheet so unauthorized people do not get into it. Protect your worksheet from data goofs. Create a template that can be used for payroll, inventory, and more. Discover how to copy a spreadsheet (or chart) and paste link into a Word or PowerPoint document so that it will change should the spreadsheet be altered.
Lesson 9 Working with text functions – know how to separate lengthy text string into columns, join data in several columns into visually attractive output.
Lesson 10 Printing the worksheet – Learn how to print out just one section; know how to find data within it. Add comments (as documentation, reference) and discover how to include them in the printout). Know how to display the formulas.
Lesson 11 Mail Merge – create letters, labels, envelopes and more in Word with this function – great for invitations for events, invoicing, and much more.
Lesson 12 Working with several worksheets – often you may need to either extract data from another file or wish to copy (or move) a worksheet from one file to another. Organization is key in this example – make sure you always keep your files in the same folders.
I’ve written about this before – the ones I mentioned before are paid for. I upgraded to Windows 10 and often need to preview PSD and/or NEF files – seeing them before opening saves a lot of time. (I also try to delete unnecessary files as they can take up room, that’s another story – all I’ll say is that if you think the photo is iffy now, chances are 98% you’ll still think it is iffy if not worse when you review the image 45 days later)
I am now using Fast Picture Viewer Codec Pack. There are some “free” ones you can get in the Windows store, and some of the reviews sounded dreadful – ads block half the image so you’re practically forced into buying the actual program. (you get what you pay for with free). This is reasonably priced, about $10 for a single user (it was on sale from $15 when I got it) with discounts for multi-users.