9 min readAbsolute Cell References in Excel CalculationsLearn how to use absolute cell references in Excel to lock a specific cell in your formulas, essential for calculations involving sales tax and percentages.
3 min readCombining & Filtering Data from Multiple WorksheetsLearn how to combine data from two different sources with varying column arrangements and use formulas to filter and manipulate the data to achieve desired...
4 min readCell ReferencingImprove your understanding of Excel's cell referencing system, including the use and implications of absolute and mixed cell references and how they impact...
4 min readWorking with Shapes in ExcelDive into the intricacies of shape manipulation in digital drawing, from rotating and formatting shapes to working with Z-order and altering points, providing...
3 min readCreating Grand Totals in ExcelExplore various formulas to calculate the grand total in an Excel worksheet, discussing alternative methods, the potential for errors, and the optimal solution.
4 min readFiltering Data in ExcelDiscover the various ways to filter data in Excel and utilize this feature to efficiently organize and analyze your datasets.
8 min readConditional Formatting in ExcelExplore the wide-ranging capabilities of Excel's conditional formatting, including the ability to format cells based on specific conditions, highlight cells...
5 min readData Validation in ExcelExplore how to use data validation to set restrictions on cell entries, alert users, and prevent incorrect values from entering your data cells, with examples...
8 min readNumber Formatting in ExcelExplore the different ways to effectively format numbers in Excel, including shortcuts, custom categories, and understanding the use of individual characters.
4 min readUsing Shortcut Keys in ExcelEnhance your proficiency with practical key combinations that facilitate various operations such as opening, closing, saving workbooks, copying, pasting, and...
3 min readCollection of Excel Tips and Tricks, Part 1Explore this comprehensive guide for insightful Excel tips and tricks to enhance your productivity, ranging from simple shortcut keys to advanced VBA code and...
5 min readHow to Add Headers & Footers in Excel: More Fun with Excel's Page Layout TabExplore the detailed guide to understanding the Page Layout tab and other features in Excel, along with a step-by-step explanation on customizing headers,...
4 min readHow to Set a Picture as a Background in Excel: Using the Page Layout Tab to Add Graphics to Your SheetsContinue your understanding of Excel's Page Layout tab with insights into the "Background" and "Print Titles" commands, where you can customize your sheet's...
4 min readIntroduction to Excel’s Page Layout Tab: Setting Margins, Page Orientation, Size, Print Area, & Breaks in ExcelExplore an in-depth guide on how to navigate the Page Layout tab in Microsoft Excel, covering commands such as Margins, Orientation, Size, Print Area, and...
4 min readCollection of Excel Tips and Tricks, Part 2Discover various tips and tricks for Excel that can enhance your efficiency, including how to put totals in certain cells, best formulas for grand totals, how...
5 min readAdvanced Filtering in ExcelLearn how to use Excel's Advanced Filter to handle more complex filtering operations such as filtering based on relationships between columns or unique records...
5 min readMaking Magic Dynamic ArraysUnveil the power of Excel's new feature, the dynamic array functions, which includes SORT, FILTER, UNIQUE, SORTBY, and RANDARRAY, to create dynamic...
5 min readData ValidationLearn how to ensure data consistency and accuracy within your worksheets using Data Validation, a powerful tool that establishes standards for data entry...
6 min readGet Started with UserForms: Create Simple Forms with VBA in ExcelLearn step-by-step how to create a simple UserForm in Excel using VBA coding which allows users to input information into a form that can be stored or used...
2 min readUsing the JUSTIFY Command: Reflow Text in Microsoft ExcelLearn how to use the built-in Justify command in Excel to reflow and arrange your text, with examples and step by step instructions.
5 min readHow to Separate First & Last Names in Excel: Move Names to Individual CellsExplore four methods to separate first and last names in Excel including using formulas, Text-to-Columns, Flash Fill, and new functions TEXTBEFORE and...
4 min readWorking with Rows & Columns in Excel: How to Hide Them, Show Them, & Change the Height or WidthDiscover the various methods to hide, show, and change the dimensions of rows and columns in Excel. This inclusive guide primarily focuses on operations...
4 min readCell Styles in Excel: How to Style Cells for Quick & Easy ModificationDiscover the time-saving capabilities of cell styles in spreadsheet software, allowing easy formatting adjustments across thousands of cells with just a few...
3 min readUsing Shapes, Lines, Icons, and Text Boxes in ExcelDiscover how to enhance your Excel worksheets by adding and formatting shapes, lines, icons, and text boxes to create visually striking data presentations.
5 min readFinding Data with XLOOKUPDiscover the powerful, versatile XLOOKUP function in Excel, which has replaced and improved upon the older VLOOKUP and HLOOKUP functions, enabling both...
6 min readCreating a Subtotal ReportLearn how to create a subtotal report in Excel, a tool that allows you to sort and group your data, apply functions like summing and averaging, and then...
4 min readAbsolute References vs. Relative AddressingUnderstand Absolute vs. Relative Addressing in Excel.
5 min readControlling Content Placement in Worksheet CellsLearn how to Control Content Placement in Worksheet Cells.
4 min readAdding, Naming, Moving, & Copying WorksheetsLearn how to Add, Rename, Move, and Delete Excel Worksheets.
14 min readExcel Data Analysis with StatisticsIn this article, we are going to look at how Data Analysis with Statistics can be done efficiently through the use of Microsoft Excel.
15 min readUsing Excel's Analyze Data ToolDiscover how to harness the power of Excel's Analyze Data tool to simplify data analysis, offering intuitive, automatic analysis of key data segments,...
10 min readExcel’s Latest InnovationsIf you subscribe to Office 365, every time you fire up one of the applications, you’re getting the latest version of the software. While we used to have to buy...
15 min readEvent Planning with ExcelIn this article, we are going to look at how Event Planning can be done efficiently through the use of Microsoft Excel.
6 min readDemystifying VLOOKUP, XLOOKUPLearn about the unique properties and uses of an Excel table, which offers additional functionalities that can significantly enhance data management and...
19 min readFunctions Built to Work with a DatabaseIn this article, we are going to look at how to build functions to work with a database in Microsoft Excel.
3 min readRearranging Data with New Functions in ExcelIn this article, we’ll explore these new functions: TOCOL, TOROW, WRAPCOLS, WRAPROWS, CHOOSECOLS, and CHOOSEROWS.
12 min readDesigning Impressive Reports with ExcelIn this article, we're going to look at how to build complex and thorough reports in Microsoft Excel
15 min readTracking Expenses in ExcelIn this article, we are going to look at how to organize Expense Tracking in Microsoft Excel
5 min readFormatting Cells in ExcelIn this article, we are going to look at the many ways you can Format Cells in Microsoft Excel
12 min readUsing Excel's Power Query EditorIn this article, we are going to look at how to use the Power Query Editor in Microsoft Excel
4 min readProtection in ExcelIn this article, we are going to look at how to "Protect" your work in Microsoft Excel
14 min readUsing Excel’s Analyze Data ToolIn this article, we are going to look at how to use the Analyze Data Tool in Microsoft Excel.
6 min readUsing Excel TablesLearn how to manage and utilize Excel Tables more effectively with this comprehensive guide, covering everything from creating tables and selecting rows or...
10 min readMultiple Pivot Tables ExcelLearn advanced features of Pivot Tables like adding percent totals, creating slicers, and creating multiple Pivot Tables off the same dataset.
7 min readExcel Go to SpecialLearn to use Go to Special to perform several time-saving tasks in your Excel spreadsheet.
5 min readExcel AND OR Logical FunctionsIn this section, we'll take a look at how you can use the AND OR functions to test if multiple criteria are all true, or at least one of them is true.
7 min readExcel COUNTIFs and SUMIFsLearn to use SUMIFS and COUNTIFS to quickly get counts and sums based on a single column criteria or multiple column criteria.
4 min readCombo ChartsCombo charts combine two or more charts into a single chart with the option of adding a secondary axis.
10 min readExcel Advanced Cell LockingLearn to create powerful formulas by locking either a column, a row, or both in Excel.
6 min readExcel HotkeysLearn to use a keyboard shortcut to access any commands on the ribbon on a PC.
7 min readExcel Advanced Conditional FormattingLearn to use advanced conditional formatting to format cells based on values in another location.
6 min readExcel IF Statement with AND ORLearn to use an IF statement with either an AND function or an OR function to expand the functionality of the IF function by adding an AND or an OR criteria...
5 min readPivot Table Sales Report Variances In this Excel tutorial, we're going to create a Pivot Table. In order to do this, we're going to have to use one of the Value Field Settings calculations that...
8 min readExcel Pivot Tables, Calculated Fields and ItemsIn this Excel video tutorial, we'll cover Pivot Tables, Calculated Fields and Calculated Items.
5 min readPivot Charts in ExcelLearn how to work with Pivot charts in Microsft Excel. Pivot charts are dynamic graphical representations of Pivot Table data that work in tandem with pivot...
4 min readExcel MATCH FunctionLearn to use the MATCH function to find the relative position in a column or a row of a lookup value in Microsoft Excel.
6 min readExcel VLOOKUP and MATCH FunctionLearn to create a more accurate VLOOKUP by enhancing the determination of the column index number by using the MATCH function in Microsoft Excel.
6 min readExcel Index MatchLearn how INDEX and MATCH efficiently return a value in a row or column that matches a value in another row or column in Microsoft Excel.
5 min readExcel Macros ReportIn this video, we'll create a macro that's going to format a report that we are going to imagine we need to create every single day.
4 min readExcel ConsolidationLearn to use the Consolidate function to consolidate information across multiple sheets in Excel.
6 min readExcel Date FunctionsIn this section, we'll take a look at five Excel date functions you can use to calculate dates in the future or the total number of days between any two dates,...
7 min readExcel Nested IF StatementsIn this section, we're going to cover how you can nest multiple IF statements together to account for more than just two possibilities.
6 min readExcel Data TablesLearn to use Excel Data Tables to show the range of effects of one or two different variables on a formula.
7 min readExcel Conditional SUMPRODUCTLearn to use conditional SUMPRODUCT to extract the subset of the information that you want and exclude everything else.
6 min readExcel Index Double MatchLearn to use Index Double Match for its flexibility when we're looking up information in a table.
6 min readExcel WindowsIn this section, we're going to talk about how to work with windows inside of the Windows operating system. This particular topic is not applicable to Macs.
4 min readWorking Across Sheets ExcelLearn to work across multiple sheets if you need to apply formatting or summarize calculations across multiple sheets.
4 min readPrinting Worksheets, Workbooks, and RangesLearn how to print Worksheets, Workbooks, and Ranges
3 min readCustomize the Excel Quick Access ToolbarLearn how to customize the Excel Quick Access Toolbar.
4 min readSelecting Cells, Ranges, Rows, and ColumnsLearn how to select cells, ranges, rows, and columns.
9 min readProject Management with ExcelDownload the project file Being a project manager is a lot like being a juggler. You’ve got to keep a lot of things—people, resources, schedules, tasks,...
4 min readWorking with Page Breaks & Print Areas in ExcelLearn how to work with Page Breaks and Print Areas in Excel.
6 min readApplying Basic Font & Alignment Formatting in ExcelLearn how to apply Basic Font and Alignment Formatting in Excel.
4 min readInserting Current Dates and Times with FunctionsLearn how to insert Current Dates and Times with Functions.
6 min readInserting and Deleting Cells, Columns, and RowsLearn how to Insert and Delete Cells, Columns, and Rows.
5 min readUsing Cut, Copy, Paste, and Paste SpecialLearn how to use Cut, Copy, Paste, and Paste Special.
7 min readIF StatementsIn this section, we’ll cover IF statements. IF statements allow you to check to see if something is true or false and then take different actions depending on...