Excel + blogs from Wise Owl (page 4 of 7)

Showing blogs 61-80 (out of 121)

Rounding numbers in Excel

Posted by Michael Allsop on 23 October 2012

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

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

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

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:   Writing VBA | Other    |    VBA macros | Working with charts

What is PowerPivot for Excel 2010 - an Overview

Posted by Andy Brown on 04 May 2012

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

Capture Excel application events - event sinks

Posted by Andy Brown on 06 March 2012

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:   VBA macros | Classes    |    Writing VBA | VBA tutorial

How to Delete Digital Certificates from your Computer

Posted by Andrew Gould on 06 March 2012

Creating a digital certificate for your VBA projects is easy, but deleting them is somewhat less obvious. This blog shows you how to use the certificate manager to remove certificates that you no longer need.

Tags:   VBA macros | General    |    Writing VBA | Other

Collections of class object using Excel VBA

Posted by Andy Brown on 05 March 2012

If you've learnt how to create your own objects using classes in Excel VBA, the next step is to learn how to group them together into collections. This on-line tutorial will show you how.

Tags:   VBA macros | Classes    |    Writing VBA | VBA tutorial

Creating classes in VBA - class modules

Posted by Andy Brown on 05 March 2012

Those who want to add spice to their VBA programming can learn how to create classes, or class modules, and become object-orientated programmers.  It's difficult, but fun - and this multi-part blog will guide you along the way.

Tags:   VBA macros | Classes    |    Writing VBA | VBA tutorial

Using Excel Add-Ins to Share VBA Code

Posted by Andy Brown on 05 March 2012

If you've written a killer function, you'll want to be able to share it between workbooks. The best way to do this is using an add-in.

Tags:   VBA macros | References    |    Writing VBA | VBA tutorial

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!

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.

Advanced controls in userforms with VBA macros

Posted by Andy Brown on 28 February 2012

The two previous parts of this mini-blog have shown how to draw forms and how to write code to handle form events. This final part shows how to add some of the more exotic controls to user forms, like combo boxes, list boxes, multipage controls, spinners and option buttons.

Tags:   VBA macros | User forms    |    Writing VBA | VBA tutorial

Writing VBA macros to work with user forms

Posted by Andy Brown on 28 February 2012

The previous part of this three-part series showed how to draw user forms; this part shows how to write macros to get them to work (the final part shows how to use some of the more advanced controls, such as combo boxes and MultiPages).

Tags:   VBA macros | User forms    |    Writing VBA | VBA tutorial

Drawing UserForms in the VBA code editor

Posted by Andy Brown on 28 February 2012

Learn how to create your own custom dialog boxes in VBA, using UserForms. This is the first part of a three-part series (the other parts are on Writing Code for UserForms and Creating Advanced Controls).

Tags:   VBA macros | User forms    |    Writing VBA | VBA tutorial

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

Writing functions for Excel using VBA

Posted by Andy Brown on 24 February 2012

On-line training in writing functions using VBA, for use either within other VBA programs or within Excel itself.

Arrays in Visual Basic for Applications macros

Posted by Andy Brown on 24 February 2012

You can use arrays (multiple variables) in VBA to speed up code - and they are also invaluable for processing CSV files and the like.

Using enumerations in VBA

Posted by Andy Brown on 24 February 2012

Excel and other MS Office applications make extensive use of enumerations - and you should too!

Tags:   Writing VBA | VBA tutorial    |    VBA macros | Enumerations
This page has 0 threads Add post