Dec 19, 2019 2 min read Create Multiple Pivot Tables in Excel Pivot Tables allow you to summarize large quantities of data quickly and easily. Read further to find out how to add multiple Pivot Tables to the same worksheet…
Dec 19, 2019 1 min read Ranking Data in Excel The Excel RANK function returns the position of a number in a list of numbers. RANK can rank values from largest to smallest and is a useful tool for anyone who…
Mar 19, 2020 5 min read Excel vs. SQL: CASE WHEN In this article, we'll explore the differences between SQL and Excel in performing a text-based grouping exercise. Our hands-on exercise will take you inside…
Dec 19, 2019 1 min read COUNTIFS Function in Excel COUNTIFS counts positions where all specified criteria are met across corresponding ranges.
Dec 19, 2019 1 min read SUMIFS Function in Excel SUMIFS adds values whose corresponding entries satisfy all specified criteria pairs.
Dec 19, 2019 1 min read Combining Charts in Microsoft Excel Learn how to combine two or more Excel charts into a single chart, with the option of adding a secondary axis.
Jan 18, 2020 2 min read Choosing Excel Classes in Boston Compare Boston-area and live online Excel training by level, instructor format, location, and current course details.
Mar 12, 2020 2 min read Excel User Interface Explore Microsoft Excel's basic user interface in this free tutorial for easier navigation.
Mar 12, 2020 1 min read Excel Conditional Formatting Use conditional formatting to format cells based on the cell’s value.
Mar 12, 2020 1 min read Excel Rows and Columns A quick tutorial for inserting, deleting, hiding, and grouping rows and columns in Excel.
Mar 12, 2020 1 min read Excel Calculations Learn basic Excel calculations for simple computations.
Mar 12, 2020 2 min read Excel Autosum Finding the sum of a column or row of numbers is a breeze with Excel. When using AutoSum, Excel automatically does the work for you. Read to find…
Mar 13, 2020 1 min read Excel Text Functions Learn how PROPER, UPPER, LOWER, and TRIM transform text in Excel, from changing letter case to removing extra spaces.
Mar 13, 2020 1 min read Excel True or False Learn how to test whether specific criteria in your spreadsheet are true or false.
Mar 17, 2020 3 min read Absolute Cell References in Excel Use absolute cell references in Excel to reduce duplicate work and speed up your calculations. Cell references allow you to carry formulas across…
Mar 18, 2020 3 min read Conditional Formatting Overview In this article, we give a quick overview of what conditional formatting is and then dive deeper into some of the practical applications of it.
Mar 18, 2020 3 min read Why Excel is Better than a Calculator In this article, we'll go through the basics of Excel calculations and learn why Excel serves us better than using a calculator.
Mar 26, 2020 3 min read Excel Data Table Tutorial In this tutorial, we’ll walk through step-by-step how to use Data Tables in Excel with some simple examples.
