In this Excel tutorial, you’ll learn how to use the handy Quick Analysis tool to shortcut to charts, tables, and other commonly used features. Want to learn more about this and other abilities in Excel? Check out our Excel Training courses, taught by live instructors …
In this Excel tutorial, you’ll see how to create a 3D reference–getting data from the same cell on several adjacent worksheets to calculate results more efficiently. Want to learn more about this and other abilities in Excel? Check out our Excel Training courses, taught by …
In this Excel tutorial, you’ll learn how to use the Data Validation feature to help prevent errors in data entry, whether for yourself or other users. Want to learn more about this and other abilities in Excel? Check out our Excel Training courses, taught by …
In this Excel tutorial, you’ll see the essential steps for creating a user-defined function in VBA. Want to learn more about this and other abilities in Excel? Check out our Excel Training courses, taught by live instructors in our virtual, online or in-person formats.
In this Excel tutorial, you’ll see how to use the Print Titles feature, which helps make large printouts easier to understand with less flipping around in dozens of pages. Want to learn more about this and other abilities in Excel? Check out our Excel Training …
In this Excel tutorial, SkillForge Instructor Seth B. shows how to use the VLOOKUP and MATCH functions together in Excel to lookup data. You’ll also see how to use the Evaluate Formula function in Excel, which can help you understand how a particular formula is …
When Excel 2007 was introduced, the PivotTable Field List included a “Filter” area, where one could drop a field to use as a filter (for example, year, brand name, size, etc. from a block of sales data). If the user filtered for one year, or …