by DerekHenry | Jul 3, 2024 | Efficiency, Excel Tips, Shortcuts
Overview Worksheets are a key component of any good Excel file. They help you organize your files and separate the inputs, outputs, and other areas. Whether you work with simple files containing just a couple of sheets, complex files with hundreds of sheets, or...
by DerekHenry | Jun 19, 2024 | Efficiency, Excel Tips
Overview If you’re an accountant charged with preparing or reviewing account reconciliations, chances are you’re using Excel a lot. Even with a variety of purpose-built account reconciliation tools available, Excel is still heavily used throughout the...
by DerekHenry | Apr 24, 2024 | Efficiency, Excel Tips
QLAMBDA and UDF Screenshot Close QLAMBDA Formula Screenshot Close QUDF Formula Screenshot Close Overview Have you ever written a custom function in Excel with a LAMBDA or a User-Defined Function (“UDF”)? They are both great options for building functions...
by DerekHenry | Apr 17, 2024 | Efficiency, Excel Tips
QDynamic Array Function Screenshot Close Overview Have you used any of Excel’s dynamic array functions (DAFs) yet? If not, you’re missing out on possibly the biggest update to Excel, possibly ever. Even though they’ve been around for a few years...
by DerekHenry | Apr 10, 2024 | Efficiency, Excel Tips
QCell Styles Screenshot (Home tab) Close QCell Styles Screenshot (style palette) Close QCell Styles Screenshot (style right-click) Close QCell Styles Screenshot (Home tab) Close Overview Do you format your Excel files one format and one cell at a time? Or do you use...
by DerekHenry | Apr 3, 2024 | Efficiency, Excel Tips, Shortcuts
QExcel Options Menu Screenshot Close QCustom ribbon tab example screenshot Close QQuick Access Toolbar example screenshot Close Overview Customizing Excel is a great way to eliminate a lot of repetitive steps you’re likely taking in almost every one of your...
Recent Comments