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!
If your chart has more than a thousand data labels, this blog explains why you may experience problems.
This blog shows how to use each of the 5 arguments of the RANKX function to rank rows in PowerPivot.
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.
Excel 2013 contains radical changes to charts, pivot tables and the user interface. This review explains all the new features of Excel 2013
This blog shows you how to create a calendar of dates for use in PowerPivot. Instructions are included for Excel and Access.
A short blog explaining how to use the keyboard to cycle through previous cursor positions.
This blog includes the SQL script to generate a table of calendar dates for linking to from within PowerPivot.
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!
Up, down, ceiling, floor or multiples… and you thought rounding numbers was simple!
Ever wondered if you can make negative columns automatically turn red in an Excel chart? Well now you can in Excel 2010!
Excel is a great product, but there is always room for improvement. Here Andy Brown considers 12 possible new features for Excel 2020.
How to link SQL Views and Tables to MS Access using VBA without getting the annoying Unique Record Identifier pop up.
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.
This follow-up article to a previous blog describes how to label the data points in multiple series in Excel using VBA.
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.
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!
The Easter Bunny stores his distribution data in SQL Server, not Access; read why!
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.
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.