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.
Although you are learning the PMT function, you may be creating a grid with many formulas, for example, showing amount being financed in columns, and the interest rate in many rows. Rather than having to create 89 formulas separately, by knowing how to lock in the cell, row, or column with the F4 key, you can create the formula once and copy it to all the other cells.
This will work with any version of Excel – even version 97!
Very often we are taking graphics or text from other sources when doing a publication. You may need a chart created in Excel embedded in your publication. This video tutorial will show you how to do this.
Too many of us are not familiar with organization on the computer – too often the files are all stored in My Documents and unnamed properly. This 4 minute tutorial discusses creating folders, moving files, renaming, making a read-only file modifiable. .A few shortcuts are also shown.
If you every wish to rename a file or folder, the simplest way is to tap the F2 key – type in the new name, press the tab key and you can go down the list of files/folders and rename them.