Excel
-
Blog
How to Use the OFFSET Function in Excel
Quick Links A Basic Example of OFFSET Using OFFSET in the Real World Excel’s OFFSET function lets you create a reference that is—quite literally—offset from a starting point. It allows references to adjust dynamically to changes in your spreadsheet’s data and structure. The OFFSET Syntax Before we look at how it works in practice, let’s run through the syntax. The…
Read More » -
Blog
Is the Excel Mobile App Worth Using?
If, like me, you’re an avid user of Microsoft Excel, having the program in your pocket to use whenever and wherever you are can be quite handy. But is the mobile app as good as the desktop app? While some people prefer to use the Microsoft 365 mobile app because it neatly organizes all their productivity programs in one place,…
Read More » -
Blog
9 Tips to Get Perfect Excel Printouts
Printing an Excel spreadsheet perfectly can sometimes be more difficult than creating it. Data could get cut off or move to a different page, which wastes your time and incurs extra costs for reprinting. If you frequently encounter this issue, here are some tips to ensure you get it right the first time. 1 Adjust Page Layout and Orientation Excel…
Read More » -
Blog
How to Use the SWITCH Function in Excel
Excel’s SWITCH is a logical function that is primarily used for data manipulation. It evaluates an expression against a list of values, and returns a result corresponding to the first matching value. Its popularity comes from its relative simplicity compared to other Excel functions that perform similar tasks, meaning it’s easier to read the formula and debug any issues. In…
Read More » -
Blog
WEEKNUM vs. ISOWEEKNUM: What's The Difference in Excel?
As well as being a number cruncher, Excel’s time and date functions mean the program can also work as a makeshift timekeeper. Let’s look at Excel’s two functions that calculate a week number based on a given date, and how you can use these to keep track of your tasks and deadlines. Source link
Read More » -
Blog
Excel in Your Job with Database Expertise
TL;DR: Get The 2024 All-in-One Database Course Bundle for $24.99 (reg. $199) and develop professional-grade skills in database management and GitHub. In this data-driven world, employers are seeking professionals who can confidently manage and optimize databases. The 2024 All-in-One Database Course Bundle offers the practical skills needed to stand out in the tech landscape — covering MS SQL Server, T-SQL…
Read More » -
Blog
/cdn.vox-cdn.com/uploads/chorus_asset/file/24740705/titan_side_view_bks.jpg)
OceanGate’s ill-fated Titan sub relied on a hand-typed Excel spreadsheet
A former OceanGate contractor, Antonella Wilby, testified before a U.S. Coast Guard panel on Friday that the company’s Titan submarine, which imploded last year during a dive to the Titanic’s wreckage, relied on an incredibly convoluted navigation system. As Wilby described it during the US Coast Guard Marine Board of Investigation hearing, the Titan’s GPS-like ultra-short baseline (USBL) acoustic positioning system…
Read More » -
Blog
The 10 Most Common Excel Charts and What They’re Used For
There are 17 different types of charts in Excel, so it can sometimes be difficult to choose which one to use. In this article, we’ll look at 10 of the most useful for your everyday data, and how to use them. To create a chart, select your data, open the “Insert” tab, and click the icon in the corner of…
Read More » -
Blog
How-To Geek’s A to Z of Key Microsoft Excel Jargon
Do you know the difference between an array and a range? How about differentiating between a function and a formula? Excel has hundreds of key terms, and some are more intuitive than others. Understanding some of the jargon will go a long way to helping you understand other aspects of the program. Microsoft has its own Excel glossary containing hundreds…
Read More » -
Blog
How to use slicers in Excel – Computerworld
To do this, click 2018 in the year slicer. This will deselect 2017, 2019, and 2020, leaving only 2018 selected. Then in the Category slicer, click Equipment to deselect everything except Equipment. The result? The table now shows only three rows, all of which contain equipment sales from 2018. The table data has been filtered according to our selections, showing…
Read More »