Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

MS Office blogs

Showing blogs 1-20 (out of 102)

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!

Problem with using VBA to create chart labels

Posted by Andy Brown on 04 April 2013 | no comments
If your chart has more than a thousand data labels, this blog explains why you may experience problems.
Tags:   Excel / Charts   |   VBA macros / Excel Visual Basic

How to use the RANKX function in PowerPivot

Posted by Andy Brown on 20 March 2013 | no comments

This blog shows how to use each of the 5 arguments of the RANKX function to rank rows in PowerPivot.

Tags:   PowerPivot/DAX / DAX

An overview of PowerPivot for Excel 2010

Posted by Andy Brown on 31 January 2013 | no comments
PowerPivot is a superb addition to Excel: it allows you to create pivot tables based on multiple tables taken from a variety of data sources, and its DAX language lets you report any statistic you want. This overview summarises how to get started with PowerPivot, and what it does.
Tags:   Excel / PowerPivot   |   PowerPivot/DAX / General

What's new in Excel 2013

Posted by Andy Brown on 30 January 2013 | no comments
Excel 2013 contains radical changes to charts, pivot tables and the user interface. This review explains all the new features of Excel 2013
Tags:   Excel / General

Creating a PowerPivot calendar in Access or Excel

Posted by Andy Brown on 16 January 2013 | no comments
This blog shows you how to create a calendar of dates for use in PowerPivot. Instructions are included for Excel and Access.
Tags:   Excel / PowerPivot   |   PowerPivot/DAX / Calendar

A keyboard short-cut for Word previous position

Posted by Andy Brown on 09 January 2013 | no comments
A short blog explaining how to use the keyboard to cycle through previous cursor positions.
Tags:   Word / General

Create a calendar table for PowerPivot in SQL Server

Posted by Andy Brown on 04 January 2013 | no comments
This blog includes the SQL script to generate a table of calendar dates for linking to from within PowerPivot.
Tags:   Excel / PowerPivot   |   PowerPivot/DAX / Calendar
You can use VBA to talk to Internet Explorer, providing that you understand the structure of the web page you're talking to. This blog shows how to do this!
Tags:   Excel / Excel Visual Basic   |   VBA macros / References

Rounding numbers in Excel

Posted by Michael Allsop on 23 October 2012 | no comments
Up, down, ceiling, floor or multiples… and you thought rounding numbers was simple!
Tags:   Excel / Excel functions

Highlighting negative columns in Excel charts

Posted by Michael Allsop on 01 October 2012 | no comments
Ever wondered if you can make negative columns automatically turn red in an Excel chart? Well now you can in Excel 2010!
Tags:   Excel / Charts

Some ideas for new features for Microsoft Excel 20xx

Posted by Andy Brown on 24 September 2012 | 3 comments
Excel is a great product, but there is always room for improvement. Here Andy Brown considers 12 possible new features for Excel 2020.
Tags:   Musings / The future   |   Excel / General

Link SQL Views to MS Access using VBA

Posted by David Wakefield on 26 June 2012 | no comments
How to link SQL Views and Tables to MS Access using VBA without getting the annoying Unique Record Identifier pop up.
Tags:   SQL / Views   |   Access / Importing and linking

Controlling Shapes in Visio Using Drop Down Lists

Posted by Andrew Gould on 21 June 2012 | no comments
Microsoft Visio lets you create far more than simple static diagrams. In this blog series we show you how to use Shape Data and the ShapeSheet to create a dynamic shape that will change its dimensions when you choose a value from a drop down list.
Tags:   Visio / The shapesheet
This follow-up article to a previous blog describes how to label the data points in multiple series in Excel using VBA.

What is PowerPivot for Excel 2010 - an Overview

Posted by Andy Brown on 04 May 2012 | no comments
PowerPivot for Excel allows you to crunch very large amounts of data quickly, using pivot tables and slicers and other familiar Excel concepts. It also includes the DAX language, allowing you to create complex calculations.
Tags:   Excel / PowerPivot

Designing databases for SQL Server and Access

Posted by Andy Brown on 23 April 2012 | no comments
Designing relational databases is easy once you learn the few basic rules, and the procedure is identical whether you're using SQL Server or Access. This blog illuminates the subject!

Why the Easter Bunny prefers SQL Server to Access

Posted by Andy Brown on 30 March 2012 | 1 comment
The Easter Bunny stores his distribution data in SQL Server, not Access; read why!

Capture Excel application events - event sinks

Posted by Andy Brown on 06 March 2012 | no comments

It's not for the faint-hearted, but there is a way to capture application events (such as someone trying to create a new workbook) in Excel, using something called an event sink.  This blog explains how you might go about creating an event sink.

Tags:   Excel / Excel Visual Basic   |   VBA macros / Classes

Macro Security and Digital Certificates in VBA

Posted by Andrew Gould on 06 March 2012 | 1 comment
Understanding macro security is essential if you want the code you've written to run when it's supposed to, and at the same time protect yourself from potentially malicious code. This blog explains how to change your security settings to an appropriate level and discusses the ins and outs of digital certification.
1-20   21-40   41-60   61-80   81-100          Next

All content copyright Wise Owl Business Solutions Ltd 2013. All rights reserved.