May 12 2017

Should You Integrate Microsoft Excel and Access

Read More

May 6 2017

Microsoft Excel Certifications

Here is an Excel hint for you, there are many Microsoft certifications available, and each can help to show the world that you are a Microsoft expert. This Excel Hint has a few links that will help you to explore this subject.

 

How many Microsoft certifications are you aware of?

 

How many Microsoft certifications do you have?

 

For example, Jacob Hilderbrand, one of the owners of this site is a long-time Microsoft Excel MVP. The Microsoft MVP certification is one of the top two Microsoft certifications available. In any given year there are only about 130 Microsoft Excel MVP’s in the world. Yes, that is correct, around 130 in the world. Being one can really set you apart. If you are not one already, don’t fuss, you can become one. Jacob’s Microsoft Excel MVP Certification page on the Microsoft website.

 

Below are a series of links that will help you to learn more about Microsoft certifications.

 

What does it take to be an MVP?

 

Nominate an Excel expert you know for the Microsoft Excel MVP award, or nominate yourself.

 

Visit the Microsoft MVP page Microsoft Most Valuable Professional (MVP)

 

https://www.microsoft.com/en-us/learning/office-certification.aspx


Here is the list of Microsoft Certification Exams.

 

microsoft-certifications

 

So there you have it, there are many Microsoft certifications that may benefit you by setting you apart from the millions of Excel users. Take your time to explore the links that take you to many useful pages on the Microsoft website.

 
 

Do you want to know why Microsoft Certification really matters for those of you that are looking to hire an Excel consultant?

 

Apr 12 2017

How Can Jacob Hilderbrand Help You?

How Can Jacob Hilderbrand Help You?

Who exactly is Jacob Hilderbrand, what does he do, and how can he help you with your Microsoft Excel needs?

Jacob

  • Jacob Hilderbrand is one of the owners of this site.
  • Jacob is a Microsoft Excel expert.
  • Jacob is an Excel VBA guru.
  • Jacob usually works behind the scenes on this site.
  • Jacob is also one of the owners of Vbaexpress.com as well as the lead Microsoft Excel consultant there.
  • Jacob manages the forums at Vbaexpress.com
  • Jacob is the Lead Microsoft Excel Consultant at ExcelConsultant.net. Here is Jacob’s profile.
  • Jacob has been a Microsoft Excel MVP since 2012.
  • Jacob can integrate and automate Microsoft Excel, Access, Word, SQL Server and VB.Net.

If you need help with your Microsoft applications and you want to hire an expert, Jacob can help you.  You can use the contact form on this site to reach him.

If you want to get answers to all of your question about how to do things in Microsoft Excel, Access, etc., use the free forums at Vbaexpress.com

How can you reach Jacob? E-Mail him at Jacob@VBAExpress.com

His LinkedIn profile is https://www.linkedin.com/in/jakehilderbrand/

That is Jacob Hilderbrand in a nutshell, that is who he is, what he does, and how he can help you.

Mar 26 2017

Our Microsoft Excel, Access and Office Training Services

If you or your organization would like to take your Microsoft Excel skills to the next level, give us a call. See why our unique approach to Microsoft Excel, Access and Office Training works so well for the client.

Our Micro-Group workshop format training (6 people or less), is the best format for small group Microsoft application training because the students are able to learn such a large amount in a small amount of time. Our “micro-group” training workshops are held in our Irvine Training Center in the heart of the Orange County California business center.

Our one-on-one Excel training is face-to-face training on steroids; there is no better way to learn Microsoft Excel or Access. This twist on our micro-workshop hyper-focus small-group training is this, it is literally one-on-one; just you and the trainer, sitting side by side, on one computer, as you work through each topic until you totally get it.

We provide training in all of the Microsoft applications listed below, both in the Microsoft Windows versions and the Apple Mac versions:
•Microsoft Excel
•Microsoft Access
•Word
•Outlook
•PowerPoint
•SQL Server
•Azure
•Power BI

If you would like to know more, please give us a call at 877-392.3539.

Mar 18 2017

How To Use Paste Special To Increase A Range Of Values All At Once

 

How To Use Paste Special – Multiply

 

What do you do if you want to quickly increase every value in a very BIG range of numbers, by a specific amount? For example, say that you want to increase all of the numbers in a large data range by 5%. If you have tens of thousands of rows and dozens of columns, that is definitely what Microsoft Excel experts would apply the term that is dear to their hearts, BIG Data. So just how much of an effort would this take? Do you need to be a Microsoft Excel data scientist to do this? The answer will come shortly.

 

Second example, an easier task. What if you wanted to do the same thing but for just a single column of numbers in Microsoft Excel, say 500,000 rows? Of course one possibility here is to temporarily create a “helper column”. In the helper column you enter a new formula that will multiply the cell by 105%, thus increasing the number by 5%. If you use this approach you would have some work to do however as you would need to take the time to copy the range of formulas and paste them as values over the range of data that you want to update. Once this is done you would need to delete the helper column. And in the end you have exactly what you were looking for.

 

You could apply this same approach to the first scenario, but you would need to insert dozens of helper columns, not just one. That is not that much more of an effort, but still it is more of an effort than needed. In fact even the single column scenario takes too much of an effort to accomplish the task at hand.

 

If you use what I am about to show you, you could accomplish the same thing in just a few seconds, without much thinking, or many steps. Basically a copy and paste special does the trick.

 

Follow these steps to markup a range of values all at once.
1. Select an empty cell.
2. Enter 5% into the cell.
3. Copy the value in the cell.
4. Select the range of cells that you wish to markup.
5. Select Paste Special.
6. Click on the option button for “Multiply”
7. Click the Ok button.

 
 

1. Select Cell Where You Will Enter Markup Value
 
Select the cell where you will enter the markup

 
 

2. Enter The Markup Value Into The Markup Cell
 

 
 

3. Copy The Value In The Markup Cell
 
Copy the value in the markup cell

 
 

4. Select The Range Of Cells That You Wish To Markup.
 
Select Paste Special

 
 

5. Select Paste Special.
 
Select the range of cells that you wish to markup

 
 

6. Click The Option Button To “Multiply”
 
Click the radio button to multiply

 
 

7. Click The OK Button.
 
Click the OK button

 
 

That is all that there is to it. Follow the steps above to markup a huge dataset by a specific amount, in seconds.

 
 

References

 

* A really good post on “Use Paste Special To Perform Calculations”

 

* This page covers what we are doing here, changing values in a range via Paste Special Multiply

 
 
 

* If you are looking for answers to your Microsoft application questions, and if you want those answers for free, then reach out to the amazing team of experts at Vbaexpress.com. VBAX is one of the leading Microsoft forums and it is.

* If you are an expert in any of the Microsoft applications, please join the team at Vbaexpress.com that answer the questions in Excel, Access, etc. It is a great way to be part of the Microsoft Excel community.

 

 

If you would like to hire someone to assist you with your Microsoft Excel needs, please give us a call or shoot us an email, we would be happy to assist you.

Call us now and get started today 877-392-3539

Free Consultation

 

click-here-to-contact-us

Page 1 of 24123451020...Last »

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives