By Curt Frye | Thursday, November 20, 2014
Setting up worksheets often means entering long strings of data, such as row numbers or dates, to create a framework for your data. This work can be repetitive and boring. What’s worse, it takes time away from analysis.
Let me show you how to make it go faster—with Excel Flash Fill, fill handle, and more.
By Curt Frye | Monday, October 13, 2014
Business users of Microsoft Excel take advantage of many of the program’s built-in functions. One of the most popular tools is the VLOOKUP function, which lets you search an Excel worksheet as if it were a database table.
By Starshine Roshell | Tuesday, August 19, 2014
Over a billion people use Microsoft Office software: Word, Excel, PowerPoint, etc. That’s one in seven people—on the planet.
If you’re one of them, you need the essential time-saving tips in our new Weekly Office Workshop. (Or as we like to call it around here, “W.O.W.”)
By Jess Stratton | Friday, August 01, 2014
Microsoft has just released the first major update for its Office for iPad suite of apps, including PowerPoint, Word, and Excel for iOS. Every update has been made in response to vocal user feedback in the first iterations of using the Office suite on a tablet, and we see some nice new features including gestures, print options, and presentation tools.
By Curt Frye | Thursday, June 26, 2014
Excel is a powerful and versatile tool you can use to analyze data—but not every capability you might want is built in.
Using the Visual Basic for Applications (VBA) language, you can script custom processes in Excel. VBA is an object-oriented language, which means that elements of Excel—such as workbooks, worksheets, and the program itself—are represented as objects. An object has three main components:
By Jolie Miller | Thursday, March 27, 2014
If you watched Microsoft’s San Francisco press event earlier today, you know there’s big news–the much anticipated Office for iPad applications are available for download in the App Store today as of 11 Pacific. Excel, PPT, and Word are all available individually and for free download. If you’re looking to just read Office documents from your iPad, you can use the apps for free, but editing rights will cost you an Office 365 subscription.
With the auto-save feature ensuring you won’t lose your work and the friendly ribbon interface and document editing abilities, you’ll see a lot of familiar features as you download each app. Plus, access your Camera Roll photos to add to docs or presentations, and get used to the 123 numerical keyboard in Excel. Get used to making your PowerPoint presentations on the iPad and then presenting them from it.
Downloaded the new Office for iPad apps and ready to dive in? Be sure to watch Jess Stratton’s free course Office for iPad First Look to get a head-start.
By Scott Fegette | Wednesday, January 15, 2014
Explore this course at lynda.com.
When looking up information in Microsoft Excel, you’ll regularly need to compare data against a table—and tables can be found in a variety of locations and formats. For example, in the image above you may need to find the appropriate tax rate in the table on the right for a given employee’s salary listed in the table on the left.
On the Formulas tab in the Excel ribbon, you’ll see a categories function called Look up and Reference. The two key functions for this type of task are VLOOKUP (V meaning vertical) and its companion function HLOOKUP (H meaning horizontal).
Why two functions instead of one? As shown in the image below, data tables can be found in horizontal and vertical orientations—so with two dedicated functions, you’re covered either way.
By Curt Frye | Monday, August 20, 2012
Recognizing when your numbers don’t add up is key to successful operations management, which is why organizations of all types and sizes use the Excel spreadsheet program to manage their operations and inventory. A real-world example of this might be conducting a monthly inventory analysis that compares the number of products in your system with the units counted in your warehouse.
In Excel 2007 and 2010, you can quickly check for differences between these two inventory numbers. First, you select the numbers in your worksheet.
Next, go to the Home tab on the ribbon, click the Find & Select button, and then click Go To Special.
Your Excel data is laid out in two columns, so you want to look for differences between the two cells within each row (A2 compared to B2, A3 compared to B3, and so on). To do this, select the Row differences radio button in the Go To Special dialogue box and click OK.
When you click OK, Excel examines the selected cell range for differences between cells in the same row and highlights cells in the right-hand column that are different from their mates in the left-hand column.
In this case, cells B4 and B7 contain values that differ from their mates in cells A4 and A7.
If your data were arranged in rows, you could highlight cells with different values by selecting the data cells in the worksheet and clicking the Column differences radio button in the Go To Special dialog box.
The Go To Special dialog box is often overlooked by even advanced Excel users, but it’s worth exploring all its useful options.
Interested in more?
Suggested courses to watch next:
Curt Frye is the author of over a dozen lynda.com courses and more than 20 books on Microsoft Excel, including Microsoft Excel 2010 Step by Step for Microsoft Press. He is also a popular speaker, presenting his Improspectives® keynote addresses and workshops for corporate clients.
You can change your email preferences at any time. We will never sell your email. More info
Thanks for signing up.
We’ll send you a confirmation email shortly.
Sign up and receive emails about lynda.com and our online training library:
Keep up with news, tips, and latest courses with emails from lynda.com.
We've updated our terms and conditions (now called terms of service).Go Review and accept our updated terms of service.