Comment in code: R, SQL, PHP, CSS, HTML, Stata | How to comment and uncomment in code in various software programs and languages, including R, SQL, CSS, PHP, HTML, and Stata. Examples and details on keyboard shortcuts, symbols, and how to comment and uncomment using the code editor Notepad++.
Create, format, resize and rename Excel TABLES | Using Tables in Excel has many benefits (we've listed our 10 favourite reasons), and this topic page shows you how to create, format, resize, rename, add totals and summarize data, and use data entry forms with Excel Tables.
Day of the week from date in Excel | How to get the weekday number and day of the week from a date in Excel. Examples with syntax including how to use the WEEKDAY() and TEXT() functions and errors to watch out for.
EVALUATE FORMULA in Excel to find errors | How to find errors in a complex formula, step by step, using Excel's EVALUATE FORMULA function. Where to find the command, method, worked example, and related topics.
Excel BEGINNER tips | If you're new to Microsoft Excel, or to any function software for that matter, there are a few basic approaches to take
Excel IF function | To test IF a value matches a condition, and return one result if TRUE, and another if FALSE.
Excel IFERROR then blank; IFERROR VLOOKUP | Excel's IFERROR function traps errors that could be returned from a formula or calculation, and gives you control over what is returned instead of an error message. Examples with syntax showing IFERROR then blank, IFERROR with VLOOKUP, IFERROR then perform another function.
FORMULATEXT function in Excel – display formulas | It can be useful to inspect a cell's formula visually without having to click in it to display the formula in the formula bar. Excel's FORMULATEXT function enables you to see the formula in another cell.
Keep track of rows in a knitting pattern in Excel | A basic worked example of how to create a row by row tick list for a knitting pattern, to keep track of rows and stitch counts. We use simple commands like copy and paste, flash fill, running total, rotate text and print preview to produce our knitting pattern instruction list.
LEAFLET map in R Shiny | Code to create a map in R Shiny using Leaflet. This example loads a base map, sets the centre and zoom, and has a reset button to return the map to the original view.
Nested IFs in Excel | How to write an IF statement in Excel, and nest IF statements to test for multiple conditions. Key tips and rules about IFs and nested IFs in Excel.
New website | Welcome to the new Excel Quick Help website giving free help for Microsoft Excel 2016!
Power Query dynamic Excel worksheet name | Purpose: use a dynamic Excel worksheet name for a Power Query or Power BI data source When linking to data in another Excel workbook, you may want to update the worksheet name containing your data source, without having to update the Power Query steps. Here’s how to create a dynamic Excel workbook sheet reference for a Power Query data source. Links to sections on this page Overview of steps Store
Power Query dynamic file path | Use cell references in an Excel worksheet to create dynamic file paths for Power Query data sources. See how to name cells in Excel, and create custom objects in Power Query.