Tag Archives: exelkungen

Efficient everyday macros in Excel

Posted on by
Reply

More good advice from Exelkungen.

Complicated Excel Macros in all its glory…

… but many of the great efficiencies in simple macros that eliminate repetitive tasks!

Becoming better at Excel has a lot to get better at using Excel more effectively, and perhaps above all to understand WHAT should be streamlined and what precisely your time wasters are.

In many cases, repetitva operations are simplified by using simple macros that you connect to the simple keyboard shortcuts (which furthermore can be performed with only one hand, som t ex CTRL + in).

Below are examples of a few simple “effectiveness macros. For you to be more efficient at your job everyday, you must “examine” yourself and learn which operations are the most time-consuming in your case.

Alternating left / right position

Sub VansterHoger()
If Selection.HorizontalAlignment = xlRight Then
Selection.HorizontalAlignment = xlLeft
Else
Selection.HorizontalAlignment = xlRight
End If
End Sub
Paste formats

You copy (CTRL + c) a cell / range of cells with the format you wish to apply to a different cell range. Then select the new field and run the macro.
Sub Paste Formats()
Selection.PasteSpecial Paste:=xlFormats
Application.CutCopyMode = False
End Sub
If you have not started with macros yet?

Then you look at the course sections in Macro School, a number of video tutorials showing how to get started with Macros and VBA in Excel.

Excel King the tricks of the presentations

Posted on by
Reply

Several tips Excel King. This time in the form of a newsletter with a bit of beauty advice.

NEWSLETTER
You have suttit x number of hours with your Excel report… and soon it shall be distributed to all your colleagues. Furthermore, you have triple checked all the numbers and formulas so that all values ​​are correct. But you also have triple checked HOW figures presented?

Does your Excel file get maximum impact?
In my daily work I have encountered many Excel files that I only barely been able to make me as the presentation itself has been heavily opedagogisk. Immunologic arrays, heavily over-worked format and colors… I simply have not been able to make me content in a quickly and intuitive means.
Early on I realized that the presentation of an Excel file in principle is as important as the content itself. And that the goal of an Excel file that is distributed reasonablymust be it to get as large an impact as possible.
Having said this, I want to of course add that good content is a prerequisiteto it at all should be relevant to send an Excel file.
Men, if the presentation is poor so is the risk that the recipient does not come to terms with the content, no matter how relevant and interesting your numbers are. The result is thus that our Excel file did not get the maximum effect we desired.
It may be difficult to optimize the presentation of Excel. First, it's about trying to give the document a logical structure. Firstly, you have to realize that all recipients are unique. Below I describe two basic rules I myself always working behind in the distribution of Excel Files.
1. The most important content first
Put the most important information / table at the top left, and preferably on the first (vänstersta) tab. Studies show that we first looking on the upper left corner of the screen. Add hence the information to the right so that The key is in the reader's eye-catcher. Internet marketing is working a lot with the structure and how the visitor will accept the contents of the screen.
2. Simple and consistent format
Everyone has different preferences when it comes to color and shape. So you have to find a “lowest common denominator”. Furthermore, it is important to be consistent in the use of format. Otherwise impedes us for the recipient to understand the content.

Consider receiver before you send your Excel file!

It can be difficult to design workbooks that will be distributed, and also there is obviously no right or wrong. But if you continually have the receiver in focus, then I believe you will pretty much.

Excel King is really Excel King…