Skip to content
- VLOOKUP vs XLOOKUP: Which to UseVLOOKUP and XLOOKUP are both lookup functions in Excel, but XLOOKUP is the modern replacement that solves most of VLOOKUP’s limitations. If…Formulas & functions
- Sorting Values in Pivot Table: Quick GuideTo sort values in a pivot table, click the arrow in the row or column label header (or the Value field’s drop-down)…Charts & pivot tables
- SPLIT Function in BigQuery: Syntax & ExamplesThe SPLIT function in BigQuery splits a string into an array of substrings based on a delimiter. For example, SPLIT('a,b,c', ',') returns…Formulas & functions
- Subtotal Formula to Count Cells: Excel GuideThe formula to count cells with the SUBTOTAL function is =SUBTOTAL(2, range) for a simple count, or =SUBTOTAL(103, range) to count only…Formulas & functions
- Shortcut Keys Save As: The Full GuideThe shortcut keys for Save As in most Windows programs are Ctrl+Shift+S (or F12 in many applications), and on a Mac it…How-to basics
- SPLIT Function in Google Sheets: How to Use ItThe SPLIT function in Google Sheets divides text into separate cells based on a delimiter, such as a comma, space, or custom…How-to basics
- US Balance of Trade Data: Latest Figures & TrendsThe US balance of trade is the difference between the value of goods and services the United States exports and imports, and…How-to basics
- How to Use SUBTOTAL and SUMIF in ExcelThis guide shows you how to use Excel’s SUBTOTAL and SUMIF functions to summarize data. SUBTOTAL calculates totals that can ignore hidden…Formulas & functions
- Is SELECT a Clause in SQL? Yes, Here’s WhyYes, SELECT is a clause in SQL — specifically, it is the first and most important clause in a SELECT statement, which…How-to basics
- PySpark partitionBy Multiple Columns: How-ToTo partition a PySpark DataFrame by multiple columns, use df.write.partitionBy("col1", "col2").format("parquet").save("path"). This creates a directory structure like path/col1=value1/col2=value2/, which can dramatically speed…How-to basics
- Countif Not Empty in Excel: Formula & ExamplesThe direct answer: use =COUNTIF(range,"") to count non-empty cells in Excel. This counts every cell in the range that contains any value,…Formulas & functions
- How to Create a Pivot Table in Google SheetsTo create a pivot table in Google Sheets, select your data range, go to Insert > Pivot table, choose where to place…Charts & pivot tables
- Oracle SQL Number Functions: A Practical GuideOracle SQL number functions are built-in functions that accept numeric input, perform a calculation, and return a numeric value, used for rounding,…Formulas & functions
- VBA Selection Cells: How to Use and Avoid ErrorsIn VBA, Selection.Cells refers to the collection of cells within the currently selected range, allowing you to read or modify each cell…VBA & macros
- Can Traffic Light Cameras Detect Speed? FactsYes, some traffic light cameras can detect speed, but most do not. The primary function of a standard red-light camera is to…How-to basics
- How to Sort in a Pivot Table (Excel)Sorting a pivot table in Excel is one of the quickest ways to make your summarized data readable—putting your largest sales figures…Charts & pivot tables
- Count Between Two Dates in Excel: Formula & StepsTo count cells between two dates in Excel, use COUNTIFS with two criteria: =COUNTIFS(range,">="&start_date, range,"=2024-01-01",A2:A20,"=2024-01-01",A2:A20,"="&D1, A2:A20,"=2024-01-01",A2:A20,"="&DATE(2024,1,1),A2:A20,"=2024-01-01",A2:A20,"="&TODAY(),A2:A20,"="&start, range,""&start, range,"="&start, range,"="&start, range1,"Formulas & functions
- Milwaukee M18 38 Right Angle Drill Driver: Specs & UseThe Milwaukee M18 38 right angle drill driver is a cordless, compact right-angle drill that uses the M18 battery platform, designed for…Formulas & functions
- Trade Balance Graph: How to Read ItA trade balance graph plots the difference between a country’s exports and imports over time, with positive values indicating a surplus and…Charts & pivot tables
- Python in Operator for Strings: How It WorksThe in operator in Python checks whether a substring exists within a string, returning True if it does and False otherwise. For…How-to basics
- VBA Select Cell Value: How to Read and Set ItTo select a cell and read or change its value in VBA, use the Range object with the Select method, then access…VBA & macros
- How to Create a Pivot Table in Excel: Step-by-StepPivot tables are Excel’s most powerful feature for summarizing, analyzing, and exploring large datasets without writing a single formula. With a few…Charts & pivot tables
- VBA for VLOOKUP: How to Use It in Excel MacrosThe direct answer: to run a VLOOKUP in VBA, use Application.VLOOKUP or WorksheetFunction.VLOOKUP inside a macro, for example result = Application.VLOOKUP(lookup_value, range,…VBA & macros
- String Functions in Google Sheets: A Practical GuideGoogle Sheets offers a robust set of string functions—built-in formulas that manipulate text—that let you clean, extract, combine, and reformat data directly…How-to basics
- Balance of Trade Data: What It Is and How to Read ItBalance of trade data measures the difference between a country’s exports and imports of goods and services over a specific period. A…How-to basics
- How to Add Speaker Notes in PowerPointSpeaker notes in PowerPoint are the private text you attach to each slide that only you see during a presentation. They help…How-to basics
- All Java String Functions: The Complete Method ListThere is no single exhaustive list of every Java String function because the String class in Java 17 (the current LTS) contains…Formulas & functions
- How to Make a Macro with SteelSeries EngineSteelSeries Engine (now called SteelSeries GG) lets you record keyboard or mouse actions and replay them with a single key press. This…VBA & macros
- F.08 Export to Excel: How to Do ItThe direct answer: “F.08” is not a standard Excel command or function. It most likely refers to a specific report code or…How-to basics
- Extracting Numbers from Text in ExcelThe fastest way to extract numbers from text in Excel is to use the VALUE function combined with MID and ROW for…How-to basics