And, little innovation there is never wrong.
Training changed to leave and I am fully convinced that it is a Win Win situation for arb.givare and arb.tagare.
Train and get off
Reply
Category Archives: Jobs
God Jul Rudboda skola
By summer you stand ready….
Skåvsjöholm again when
And, then you here again, 33 km from home. Luckily you do not need to sleep over here again, home to family, home to home all the days in the week before smth that has the job of making. Some feel safe to sleep away the middle of the week…I do with if you get to choose with whom (ie company) and I want my family with me, all days a week all year round.
Skåvsjöholm I actually no good vibes……Job wise. Feels like the times I've been here, it has not really stopped as I thought before I came here. Has gone away with more negative thoughts than positive versus when I came here and actually been somewhat pissed.
Now it's kind of ngn conference I hope to become anything, so when, ie I do not really know what to expect and it feels like these days would be better expended on “office”where they could be productive.
Be Careful Out There
Sunkans links
What is a Pivot Table in Excel?
Again good tips from Exelkungen
Surely you have heard of the term PivotTables in Excel.
But will you really going to use them?
Using a pivot table, you can quickly and easily make a compilation of a large amount of data. The picture below shows a simple, but effective, application of PivotTables:
Pivottabellen, ie compilation to right in the image above, thus provides a very practical and effective summation of a larger body of data.
Some different purposes Pivot can for example be:
- Vaska the totals etc.. a slightly
- Making a data set more understandable (Grouping)
- Create presentations or a basis for analysis
Is it difficult to work with PivotTables?
No., not. Once it has started, it is not at all difficult, and the pivot table is quickly becoming an essential tool that you carry with you in your everyday work.
How can I learn to make your own pivot tables?
Go to www.excelkungen.com you'll find awesome help to create their own tables like above.
Be Careful Out There
El Sunko
Import data from Access to Excel
Much of the information available today on the web, and Excel King have received some questions about how toimport data directly from the web into Excel.
And of course, it is usually excellent to retrieve web data to Excel. I this article shows Excel King how to quickly and easily through menus in Excel connecting to a website and downloading a table of data.
Webbimport i Excel – Webquery
The concrete example is about how we can automate the retrieval of foreign exchange, and then use these to convert product prices in GBP (via trotjänar formula VLOOKUP / VLOOKUP).
The advantage of this method, i.e., a so-called Web Query, is that the import function is saved in the worksheet and therefore can be easily updated by right clicking on the table in Excel and select Refresh/Update.
Item is in video format and you can easily see all the steps in the process.
Get more done – roll up your sleeves? Or get better at Excel?
There are many ways to get more done at work. This does not mean that all ways are equally effective and have the same efficiency…
If you sit a lot with Excel, the “roll up your sleeves” and sit even more viewing hours. Or you can focus on simply become better at Excel.
Excel King has experience in administrative and financial work in a number olilka organizations in Sweden as well as abroad. The situation is similar. Excel king sees that colleagues working more with Excel than they actually do. While they do not possess the knowledge that is related to all these “Excel hours”.
King's reflection is that both the organization and employees benefit from becoming better at Excel.
Excel is not just about numbers, but perhaps as much about text. Often accompanied our numbers of columns of text, such as personal, product name etc..
To quickly and effectively to conjure the large amounts of text in Excel is an invaluable knowledge which immediately leads to an interesting situation for those who work a lot in Excel.
The following article highlights two types of text processing:
1. Extracting text from a text string
Simple formulas that allow picking out certain parts of a text string. An example of this might be that you want särsklija country code (in a separate column) from product code SE-654248.
The ease of use formulas for these operations is called
SE: LEFT / RIGHT / EXTEXT
IN: LEFT / RIGHT / MID
When it comes to clean up such as name lists in Excel then the following formulas very useful.
One example is that we want to do if
“Efraim erik nilsson” >>> “Efraim Erik Nilsson “.
SE: GEMENER / CAPITALS / INITIAL
SE: LOWER / UPPER / PROPER
Be Careful Out There
Sunkans links
Sums you really right in Excel?
New tipps from Excel King
Certainly use the summation formulas when working with Excel. Right here with to summing columns is perhaps by far valigaste work step in everyday Excel Work; an operation which normally is perceived as simple and safe.
But the article below shows some considerable risks that can occur when you add up Filtered columns.
|
Work more efficiently in Excel using the keyboard
More Comfortable tips exelkungen
Keyboard Shortcuts (shortcuts, shortcuts) allows you to work enormously faster in Excel. You have everything to gain by “wear in” a number of shortcuts.
By using the keyboard instead of the mouse:
perform commands significantly faster, conserve body through improved ergonomics, feels the burden.
Sure, it can feel a bit exhausting to seriously get started with keyboard commands, but the king can guarantee you that it is worth the effort.
What keyboard shortcuts in Excel are the most effective?
What keyboard shortcuts are the best?
It depends on what exactly you are working in Excel. But generally I usually shortcuts cell formatting as well as for the selection of the worksheet to be by far the most profitable.
For you to get the most out of Excel shortcuts, you should “examine” yourself and think about what operations in Excel that just adding the most time and effort.
Keyboard Shortcuts (shortcuts, shortcuts) allows you to work enormously faster in Excel. You have everything to gain by “wear in” a number of shortcuts.
By using the keyboard instead of the mouse
- perform commands significantly faster
- Save the body through better ergonomics
- feels like work less burdensome
Sure, it can feel a bit exhausting to seriously get started with keyboard commands, but the king can guarantee you that it is worth the effort.
|
|
Excel – more than just numbers!
From Exelkungens awesome website
If you ask a random person what Excel is for something, you get probably the answer “It is a spreadsheet program”! Thus understood a program that is all about numbers and calculations.
But the fact is that many of us Excel users as frequently working with text in our spreadsheet. It could for example, include lists of names, product names, and so on.
It provides this with text handling in Excel is essential if you want to work really effectively. By you master the most important text formulas in Excel, you can quickly and easily “magic” with the amounts of text anywhere in Excel.
Text management is essentially about two things:
1: to break out text (extract),
2: to format text.
Extraction of text in Excel:
This means that, through a formula, pick a certain part of the text content in a cell.
We assume that cell A1 contains the text “sirapslimpa”.
Formula Result
LEFT(A1;5) “syrup”, i.e., the five characters vänstersta
RIGHT(A1;6) “clean”, i.e., the first five characters High
MID(A1;7;3) “lim”, ie three characters fr o m the seventh character
The Swedish version is called the Excel instead LEFT, RIGHT and MID.
Text formatting in Excel
Furthermore, you can conjure with uppercase and lowercase letters.
We assume that cell A1 contains the text “Donald Duck”.
Formula Result
UPPER(A1) “DONALD DUCK”
LOWER(A1) “donald duck”
PROPER(A1) “DONALD DUCK”
The Swedish version is called the Excel instead CAPITALS, LOWER and INITIAL.
Be Careful Out There
Anders
Excel, solution to the dynamic radnumreringar…I often use in my work
Here's a supertipps of dynamic line numbering.
How often have you not a column with row numbers and then to remove a line or add a line and then the line numbering destroyed and one must “donation of” entire table.
Here's a damn good tips to fix this:
So when you want to display a long list that you delete or add rows on , using the formula:
=ROW()-n (where n is the number of lines before the first row of the list,)
So, t.ex, if you have a list of names in column B, starting in cell B5 and you want line numbers in column A, it should be following =ROW()-4 In cell A5, and then copy the formula down the entire column A to the bottom of your list. So every fomel in column A will be =ROW()-4. ROW()-Part of the formula retunerar row number of the cell in which the formula . Since the number of lines before the first line is subtracted.
For example,: formula in cell A5 is = ROW()-4. ROW() returns 5 (IU. wheel 5) and subtraherar 4 gives 1 for your sequence numbers.
Once you delete a row in your data row numbers automatically adjusted throughout the table. When you add a row, all the row numbers automatically adjust when you have copied the formula from the cell above the new row.
There is a “plump” in this solution, however,.
If rows are deleted or that it adds to a series of (wheel 1 to 3 of this example) you will get the wrong values in the row numbers. Here is the solution.
1) Choose a celll directly above the first row of your data (A4 in this example).
2) Give a name to the cell by typing a name in the Name box (IU. top) (the white bar immediately above cell A1)
3) No, use the same formula as above, replace 4 mot R0W(top).
Your new formula will now be: =ROW()-ROW(top)
