Top Tips

Download our guides and code samples

Our team have put together a collection of guides and code samples based on questions we have been asked in the field. We hope you find them useful!

Motion graphic.

VBA

Excel VBA Row & Region Selection Tips

VBA Integer Arithmetic Problem

VBA Functions in MDX Scripts

MDX Ranking & Ordering

Oracle

Extracting Last Word in Oracle

Extracting Words in Oracle

Microsoft Word

Word Keyboard Shortcuts

Microsoft Word Top Tips

Microsoft Excel

Excel Week & Working Day Counts

IFERROR

Freezing Panes

Excel Conditional Formatting

Working With Dates in Excel

Excel - Using INDIRECT Functions

Excel - Using COUNTIFS Function

Excel Function Keys

Excel Time Savers

SQL Server

SQL Server EXECUTE Statement With RESULT SET Clause

SQL Server Aggregate Functions and OVER

SQL Server - Create Detail from Summary Data

SQL - Display List of Indexes With Columns

SQL Server - Display Details of Automatic File Growths

Request & Session Resource Usage

Top Queries IO Usage

SQL Server SQL CROSS APPLY Statement

SQL Server & Virtualisation

SQL Server Audit & Security - Password & Privlege Checking

SQL SSRS - Working With Charts

SQL SSRS - Repeat Page Headers On Every Page

SQL Query - Difference between 2 dates in years, months and days

SQL Query - Calculate age of employee

SQL Query - Week number of order date and last day and weekday of orders month

Business Benefits From Microsoft SQL Server Business Intelligence Solutions

SQL Query - Day of the week for 1st and last day of month

SQL SSRS - Export to Excel With Each Region on a Separate Named Worksheet