This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Wise Owl Blogs - Home (page 24 of 25)

Showing blogs 461-480 (out of 487)

How to get Excel to speak to you in a female voice, or slower/faster!

Posted by Andy Brown on 13 August 2013

A previous blog showed how to get Excel to speak to you; this one shows how to change the voice in which it does it!

Tags:
Excel > General

How to get Excel to speak to you - reading out the contents of cells

Posted by Andy Brown on 12 August 2013

Deep within its bowels Excel contains a feature allowing it to read out the contents of cells (you can also get your VBA macros to talk to users). This blog goes to those deep places hidden within Excel!

Tags:
Excel > General

Drop Lines in Excel Charts: Ah, that's what I needed!

Posted by Michael Allsop on 24 May 2013

Ever had the feeling that you're missing something obvious? This blog highlights one particular chart option that you may well have overlooked.

Tags:
Excel > Charts

Want to wind up your neighbour? Try this annoying Excel VBA code!

Posted by Andy Brown on 18 September 2024

If you have a colleague who trusts you, you could always betray this trust by sending them a workbook which misbehaves: it won't close and you can't leave it!

Tags:
VBA macros > Events Writing VBA > Other

Problems with Shared Datasets and Subreports in SSRS

Posted by Andrew Gould on 23 April 2013

If you're using shared datasets to populate subreports in Reporting Services you might have encountered an error when you preview your reports. This short blog explains what the problem is and offers a few simple suggestions to work around the issue.

Tags:
SSRS > Lists, subreports

SSIS: Executing SQL statement for each file

Posted by Andy Brown on 05 April 2013

How to store the name of each file in a folder in a SQL Server table using an Integration Services package.

Tags:
SSIS > Files and folders SSIS > Variables, expressions

Problem with using VBA to create chart labels

Posted by Andy Brown on 04 April 2013

If your chart has more than a thousand data labels, this blog explains why you may experience problems.

Tags:
Excel > Charts VBA macros > Working with charts Writing VBA > Other

Rounding numbers in Excel

Posted by Michael Allsop on 17 October 2012

Up, down, ceiling, floor or multiples… and you thought rounding numbers was simple!

Tags:
Excel > Excel functions

Prevent Reporting Services from caching data

Posted by Andy Brown on 01 October 2012

By default SSRS will create files with extension .rdl.data to cache data. This blog gives two and a half ways to ensure you're always seeing the latest data in a report.

Tags:
SSRS > General

Use SQL, parameters and bookmarks to create a grid of clickable links

Posted by Andy Brown on 06 August 2012

To make report navigation easier, you can create a 2-dimensional matrix of clickable links at the top of a report. This blog shows you how!

Tags:
SSRS > Matrices SQL > Stored procedures T-SQL > Other

Make an SSRS matrix dynamic, like a pivot table

Posted by Andy Brown on 06 August 2012

Create a matrix whose row, column and data fields are all selectable from dropdown lists.

Tags:
SSRS > Matrices

Using a Parameter to set the Data Source for a Report

Posted by Andy Brown on 06 August 2012

A single report in Reporting Services can serve many masters. This blog shows how to allow a user to choose which data a report should display, using a dropdown parameter.

Tags:
SSRS > Parameters SSRS > Linking to data

Reporting Services - report and group variables

Posted by Andy Brown on 21 June 2012

If you're not sure when - or whether - you should be using report or group variables in SSRS, read this blog to find out how to speed up your reports and solve other problems.

Tags:
SSRS > Variables

Using Excel VBA to Label Multiple Series in a Chart

Posted by Andrew Gould on 30 May 2012

This follow-up article to a previous blog describes how to label the data points in multiple series in Excel using VBA.

Tags:
VBA macros > Working with charts Writing VBA > Other

Controlling the number of rows per page in Reporting Services

Posted by Andrew Gould on 11 May 2012

Unfortunately, Reporting Services doesn't have a simple setting that allows you to control the number of rows you see on each page. However, you can control this using a clever combination of an expression with a grouping level. Read this blog to find out how!

Tags:
SSRS > Tables SSRS > Designing reports

Protecting Worksheets and Workbooks in Excel

Posted by Andrew Gould on 28 February 2012

If you've ever been annoyed by somebody else changing parts of your Excel workbooks it's a good idea to learn about protection to prevent them from doing it again!

Tags:
Excel > Validation, protection

Using Data Validation in Microsoft Excel

Posted by Andrew Gould on 28 February 2012

If you're constantly frustrated by other people entering the wrong values in your spreadsheets why not learn how to use data validation to prevent them? This blog series explains how you can control what other people can do to your spreadsheet.

Tags:
Excel > Validation, protection

Scheduling Data Imports in SQL Server

Posted by Andrew Gould on 02 August 2023

If you frequently import data into a SQL Server database from the same source you'll probably be sick of going through the import wizard again and again. So why not learn how to schedule an automatic import of your data using SSIS packages and the SQL Server Agent? This blog explains how to do exactly that!

Tags:
SQL > Tables and columns T-SQL > Other

Using Scenarios in Microsoft Excel

Posted by Andrew Gould on 27 February 2012

Scenarios are incredibly useful when performing "what-if analysis". They allow you to quickly swap a range of input values to test different possibilities without having to retype any values. Read on to find out how they work!

Tags:
Excel > What-if analysis

Goal Seeking in Microsoft Excel

Posted by Andrew Gould on 24 February 2012

Goal seeking in Excel allows you to approach calculations from the "result end" and get Excel to tell you what inputs you need in order to hit a specific target. Read on to find out how it works!

Tags:
Excel > What-if analysis

This page has 0 threads

Add a new post

BLOGS BY TOPIC

BLOGS BY AUTHOR

Wise Owl Blogs - Home (page 24 of 25)

How to get Excel to speak to you in a female voice, or slower/faster!

How to get Excel to speak to you - reading out the contents of cells

Drop Lines in Excel Charts: Ah, that's what I needed!

Want to wind up your neighbour? Try this annoying Excel VBA code!

Problems with Shared Datasets and Subreports in SSRS

SSIS: Executing SQL statement for each file

Problem with using VBA to create chart labels

Rounding numbers in Excel

Prevent Reporting Services from caching data

Use SQL, parameters and bookmarks to create a grid of clickable links

Make an SSRS matrix dynamic, like a pivot table

Using a Parameter to set the Data Source for a Report

Reporting Services - report and group variables

Using Excel VBA to Label Multiple Series in a Chart

Controlling the number of rows per page in Reporting Services

Protecting Worksheets and Workbooks in Excel

Using Data Validation in Microsoft Excel

Scheduling Data Imports in SQL Server

Using Scenarios in Microsoft Excel

Goal Seeking in Microsoft Excel

Head office

London

Manchester