Feb 10, 2019 3 min read Excel Shortcuts for PC Many business professionals spend countless hours in Excel daily. In this post, we review the essential shortcuts you need to work faster in Excel.
Oct 6, 2018 5 min read Top 10 Tips & Tricks You Need to Know in Microsoft Excel Microsoft Excel is a powerful spreadsheet and data analysis tool with wide-ranging capabilities. In this article, we'll review the top 10 things you…
Nov 27, 2018 1 min read 5 Benefits of Taking Excel Classes Microsoft Excel is a powerful spreadsheet and data analysis program with wide-ranging capabilities. In this article, we will review the advantages gained by…
Nov 27, 2018 2 min read What Should You Learn After Excel? Compare tools that complement Excel and choose a next step based on the work you want to do.
Dec 24, 2018 4 min read Top Excel Shortcuts You Need for Financial Modeling Financial modeling can be a tedious process with multitudes of rows and columns of data. Excel shortcuts are crucial to any financial analyst's success. In this…
Sep 27, 2019 1 min read Basic Data Entry in Excel Review different means for entering numbers and text in Excel.
Dec 11, 2019 4 min read Printing In Excel: A Quick Tutorial Learn how to print in Excel with ease. Printing can be controlled through the PAGE LAYOUT tab.
Dec 11, 2019 2 min read Absolute Cell References Quick Tutorial Use absolute and mixed references to control how Excel formulas change when copied.
Dec 11, 2019 3 min read Excel Charts Quick Tutorial Learn about three different types of Excel charts to decide which one(s) best fits your needs. Follow our step-by-step examples to create your own engaging and…
Dec 12, 2019 2 min read Excel Navigation and Paste Special Work smarter, not harder, in Excel. Learn about keyboard shortcuts for fast, efficient navigation, and use Paste Special to copy complex items and paste them…
Dec 12, 2019 2 min read Splitting and Joining Text in Microsoft Excel Knowing how to split and join text in Excel is a highly useful skill that will allow you to work efficiently and accurately.
Dec 12, 2019 2 min read Naming Ranges and Data Validation in Excel Learn how to name ranges and restrict data entry in Microsoft Excel in order to create complex spreadsheets efficiently and accurately.
Dec 17, 2019 1 min read Excel Sort and Filter Quick Tutorial Learn how to use Sort & Filter in Microsoft Excel to find and organize data in large databases.
Dec 17, 2019 1 min read Removing Duplicates From Microsoft Excel Learn how to remove duplicates from Microsoft Excel to keep your spreadsheets tight and clean.
Dec 18, 2019 2 min read VLOOKUP Function in Excel VLOOKUP is an extremely useful function for finding information in one column and then returning information in a column to the right in the same…
Dec 18, 2019 1 min read HLOOKUP Function in Excel Use HLOOKUP to find information in one row and return information from the same column of another row.
Dec 18, 2019 2 min read VLOOKUP and the Closest Match Use approximate VLOOKUP for ordered ranges such as grade thresholds. Learn when it is appropriate and why the lookup column must be sorted.
Dec 19, 2019 1 min read Excel And & Or Tutorial Learn to use the And and Or functions to test whether multiple conditions are true, or not true.
Dec 19, 2019 1 min read Excel IF Statements Tutorial Learn how to use IF statements in Microsoft Excel to return output based on the contents of another cell.
Dec 19, 2019 1 min read Grouping Dates in Pivot Tables Excel Pivot Tables allow the user to group certain fields such as dates or values. Dates can be grouped by weeks, months, quarters or years. Values can be…
