Blogs
Jan-2010 ExcelExperts.com Update
Submitted by Nick on 4 January, 2010 - 12:20Happy new year !
This year should be an exciting one with ExcelExperts.com making a big push for business.
The first large scale system is in production at a canadian company. They are very pleased so far, and have requested 2 more systems to compliment their sales operation.
We have taken on board feedback that the site was confusing and cluttered, and have changed the layout to be more intuitive.
- Nick's blog
- Login or register to post comments
- Read more
- 5794 reads
31. VBA Tips - Convert Text To Number VBA
Submitted by Nick on 30 December, 2009 - 10:39
Convert Text To a Number using VBA
- use: EVALUATE()
Here's a step through demo sub routine:
- Nick's blog
- Login or register to post comments
- Read more
- 30340 reads
Use brackets with data tables
Submitted by Cyril Myshkin on 12 December, 2009 - 15:34I tried to show all possible cases I know but found that there are much more.
These are some of it.
- Cyril Myshkin's blog
- Login or register to post comments
- 6303 reads
Dec-2009 ExcelExperts.com Update
Submitted by Nick on 12 December, 2009 - 13:53Hi all
This month has been very busy with ExcelExperts.com officially opening the doors to customers.
We have been swamped by requests for quotes, and it seems people realise that Excel is an increasingly popular business tool.
If you are a business using Excel, we guarantee that we can save you time and money with a little investment from you. Tell us your business processes, and we can advise on and implement changes.
We are looking for Excel Experts to join the team.
- Nick's blog
- Login or register to post comments
- Read more
- 3130 reads
30. VBA Tips - Fast Search
Submitted by Nick on 12 December, 2009 - 11:39
Do you have a large amount of data held in an Excel Spreadsheet ?
- If so, you will be well aware how difficult it is to find things
This tip demonstrates a way using VBA that enables you to search through your data really quickly, and helps you to find what you are looking for.
What I have written is a demo I used for searching through flight details.
- Nick's blog
- 3 comments
- Read more
- 23012 reads
ExcelExperts.com is HIRING !
Submitted by Nick on 8 December, 2009 - 14:06Yep, that's right, ExcelExperts.com is looking for Excel Experts to get paid for Excel consultancy.
...but this is no ordinary interview.
To apply for this job, you need to prove the following:
- You must be an Excel Expert, or be smart enough to learn quickly.
- You need excellent communication skills. (Written more important than verbal)
- You have to prove that you have the tenacity to see problems through to completion.
How do you prove this ?
- Nick's blog
- 13 comments
- Read more
- 37137 reads
Regarding Excel Query
Submitted by mandar on 30 November, 2009 - 11:12Hi,
- mandar's blog
- 1 comment
- Read more
- 2831 reads
ExcelExperts.com - Excel VBA Consultancy is open for business !
Submitted by Nick on 12 November, 2009 - 11:54
ExcelExperts.com is excited to announce that our Excel VBA Consultancy service is open for business, and we have completed the first Excel VBA consultancy job.
The task involved analysing the valuation of a large development site by way of complex discounted cash flows prepared by property valuation experts.
The work included:
- Nick's blog
- Login or register to post comments
- Read more
- 4098 reads
Nov-2009 - ExcelExperts.com Update
Submitted by Nick on 9 November, 2009 - 15:08You've probably been wondering what I have been up to for the last few months given that there have not been many updates on the site.
Wellll... I've been looking after my new daughter, redecorating the entire house, and making photography books...
Here's the first one:
- Nick's blog
- Login or register to post comments
- Read more
- 5979 reads
Text Box Troubles...
Submitted by TeeNado58 on 20 October, 2009 - 19:57Hello - I am using Excel 2007 and on some of my files I notice that the slow way down when I try to change any data in the cells. While trying to find the casue of this slowdown I use the Page Layout tab and then Selection Pane and the window that opens shows many Text Boxes that I have not placed in this spreadsheet. It takes a few minutes to delete all of these text boxes and then save the workbook and all is fine. But I would like to know how these text boxes pop up and why. Has anyone had this same problem?
- TeeNado58's blog
- 1 comment
- Read more
- 4294 reads
Replace easy question
Submitted by adriano on 17 September, 2009 - 13:17Im a column I have entries as follows:
6-16
5-10
2-14
I want to replace the "-" with "/"
When I go ahead and replace then using CTRL + H method; The replacement will also calculate a decimal number (42491) or put a date like entry (05/06/2009).
All I want is the cell to show 6/16 instead of 6-16.
I have changed the cell format to text and also have set the calculation to manual, but still keep having the same behaviour.
Any tips on how to do it? I'd really appreciate it.
- adriano's blog
- 2 comments
- Read more
- 3819 reads
How to remove a row from another worksheet
Submitted by rspeedster on 10 September, 2009 - 17:28I have a List of names in Column(A)’Sheet1.
Row1-Judy
- rspeedster's blog
- 5 comments
- Read more
- 8241 reads
Bird spreadsheet
Submitted by 4feathers on 25 August, 2009 - 22:20Hi people, i am a birdkeeper and am trying to set up a workbook with various spreadsheets that relate to 1. an id 2.a pen number and various other entries for each bird. On my Birds spreadsheet i have a colum named Pen and within the same workbook other spreadsheets named Pen1,Pen2,Pen3 and so on.
- 4feathers's blog
- 5 comments
- Read more
- 15071 reads
Help in copying formula
Submitted by ronn on 13 June, 2009 - 14:54please help when i copied the formula #value! came out but when i checked the fomula its ok
it seemed that it didnt capture the numbers in the cell it is supposed to compute
pls see my attachment
thanks in advance
- ronn's blog
- 3 comments
- 4556 reads
Teach Yourself Excel Lesson 27 - Create Hyperlinks
Submitted by Nick on 2 June, 2009 - 11:13
Create Hyperlinks
So, we have added data, pivot tables, and charts. We're now going to create an index page.
Steps:
- Nick's blog
- Login or register to post comments
- Read more
- 12643 reads
Teach Yourself Excel Lesson 26 - Create A Chart
Submitted by Nick on 2 June, 2009 - 10:39
Create A Chart
Now we are going to create charts of our pivot tables so that we can get a visual representation of all this data.
Steps:
- Nick's blog
- 1 comment
- Read more
- 11049 reads
Teach Yourself Excel Lesson 25 - Create A Pivot Table
Submitted by Nick on 2 June, 2009 - 09:55
Create A Pivot Table
And now the lesson you've all been waiting for - How to create a pivot table !
A pivot table is an ingenious invention that allows you to slice and dice your data in as many ways as you can think of.
- Nick's blog
- 2 comments
- Read more
- 35366 reads
Teach Yourself Excel Lesson 24 - Inserting And Renaming Worksheets
Submitted by Nick on 2 June, 2009 - 08:58
Inserting And Renaming Worksheets
We have finished with the data entry sheet now, so lets create an index page. We now need to insert a worksheet.
Insert A Worksheet
Steps:
- Nick's blog
- Login or register to post comments
- Read more
- 13660 reads
02-June-2009 - ExcelExperts.com Update
Submitted by Nick on 2 June, 2009 - 08:15June 2009 Stats update from ExcelExperts.com
- Nick's blog
- Login or register to post comments
- Read more
- 3592 reads
Teach Yourself Excel Lesson 23 - Find And Replace
Submitted by Nick on 1 June, 2009 - 17:08
Find And Replace
Suppose I've changed my mind and now prefer to use the term "Entertainment" instead of "Eating Out"
How do I do this ?
Easy..
- Nick's blog
- Login or register to post comments
- Read more
- 9489 reads
Teach Yourself Excel Lesson 22 - VLOOKUP Formula
Submitted by Nick on 1 June, 2009 - 16:09
VLOOKUP Formula
Now, it has occurred to me that I can save time when entering future expenses because I have realised that I can pretty much categorise the expenses.
- Nick's blog
- Login or register to post comments
- Read more
- 23720 reads
Teach Yourself Excel Lesson 21 - Filter Data
Submitted by Nick on 1 June, 2009 - 15:42
Filter Data
Now you want to know how many of those expenses occurred in the last 1000 days.
Autofilter is perfect for this!
Steps:
- Nick's blog
- Login or register to post comments
- Read more
- 10816 reads
Teach Yourself Excel Lesson 20 - Sort Data
Submitted by Nick on 1 June, 2009 - 15:32
Sort Data
So you've entered a load of expenses, and now realise that you have entered them in the wrong order. It would be nice to sort them.
Steps:
- Nick's blog
- Login or register to post comments
- Read more
- 13265 reads
Teach Yourself Excel Lesson 19 - Freeze Panes
Submitted by Nick on 1 June, 2009 - 15:13
Freeze Panes
This lesson is on how to freeze the panes. Freezing panes is about keeping the headings in view whilst being able to scroll down to enter data at the end.
To demonstrate why you want to do this:
- Nick's blog
- Login or register to post comments
- Read more
- 9798 reads
Teach Yourself Excel Lesson 18 - Protection
Submitted by Nick on 1 June, 2009 - 14:36
Protection
When designing a spreadsheet, it is important to differentiate between areas to enter data, and areas that are calculating values based on that data.
Think: Inputs / Outputs
As a general rule, cells containing formulae should be protected, and coloured differently, so lets do that here.
- Nick's blog
- Login or register to post comments
- Read more
- 10011 reads
Teach Yourself Excel Lesson 17 - Copy And Paste Special Values
Submitted by Nick on 1 June, 2009 - 13:57
Copy And Paste Special Values
We've just learnt how to enter a formula, so this lesson is on how to convert the formulae to values.
Steps:
- Nick's blog
- Login or register to post comments
- Read more
- 11319 reads
Teach Yourself Excel Lesson 16 - Absolute References
Submitted by Nick on 1 June, 2009 - 13:15
Absolute References
Now we want to enter a formula to calculate how many days ago we spent the money.
Steps:
- Nick's blog
- Login or register to post comments
- Read more
- 12327 reads
Teach Yourself Excel Lesson 15 - Insert A Column
Submitted by Nick on 1 June, 2009 - 11:37
Insert A Column
I now want to calculate how many days ago I spend the money, but I forgot to add a heading for that. I'll need to insert a column.
Steps:
- Nick's blog
- 1 comment
- Read more
- 9765 reads
Teach Yourself Excel Lesson 14 - Copy A Formula
Submitted by Nick on 1 June, 2009 - 10:47
Copy A Formula
In the last lesson, we entered a formula. We now want to apply that formula to all the dates in column A.
There's a quick way to copy a formula that saves us from entering it again and again.
Steps:
- Nick's blog
- 1 comment
- Read more
- 10305 reads
Teach Yourself Excel Lesson 13 - Enter A Formula
Submitted by Nick on 1 June, 2009 - 10:20
Enter A Formula
We've entered some dates in our Expense tracker, and now we need to enter a formula that will tell us the month and the year of those dates so we can use this information in the summary of our expenses.
Steps:
- Nick's blog
- Login or register to post comments
- Read more
- 12596 reads
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago