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

Mar 7 2017

Microsoft Power BI

Microsoft Power BI

As you know, this site is a blog that covers Microsoft Excel via short blog posts (hints). Each hint should give you a good nugget of information on what is possible or how to do something, such as an Excel keyboard shortcut.

We then add one or more links to other sites that we consider to be a good source of additional information. This post has several very good resources that you would want to visit if this topic is of interest as this topic is so detailed and cannot be fully covered here.

We do assume that the majority of our readers work in Microsoft Excel to some capacity, be it as a hobby, for school, or for work. If you work in Excel at the professional level, and with BIG data, then you should understand this topic as Microsoft’s entry into this service line (Business Intelligence)  changes everything.

 

Business intelligence is nothing new as it has been around for decades. Once it was only available at the enterprise level, but that has changed in recent years.

Enterprise Level BI:

  • Yyperion (Bought by Oracle)
  • Cognos (Bought by IBM)
  • MicroStrategy

 

When Microsoft released their twist on BI, Microsoft Power BI, things really changed. If you work with BIG data, and if you work with the Microsoft data applications, working with Microsoft Power BI should be checked out.  This is an alternative to working with Microsoft Access.  This is actually more powerful than Access.  Many of today’s Data Scientists work with Microsoft Excel Power BI to harness the BIG data files they are asked to work with.

 

 Available to small-business

  • Domo
  • Qlik
  • Tableau
  • Microsoft Power BI

 

Here is what Wikipedia says about Power Pivot:

Power Pivot is available in Microsoft Excel. It is available as an add-in in Excel 2010 and 2013, and is included natively in Excel 2016

 

Here is what Wikipedia says about Microsoft Power BI:

Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves

 

microsoft-power-bi-mini

 

 

 

 

References

 

* The Microsoft Power BI Blog is the best source for Power BI content and information.

* Wikipedia always has good information on topics such as Microsoft PowerPivot which was the first aspect of Microsoft Power BI.

* 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 Power BI 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

TAGS:
Mar 6 2017

Insert-current-date-and-time-keyboard-shorcut

If you are like me and like many other people out there that make their living working in Microsoft Excel, you learn keyboard shortcuts over time that shave a second here, a few seconds there, and if you know enough of them they allow you to work pretty quickly.

But out of all of the Microsoft Excel keyboard shortcuts there are a few that really allow me to hum along, the ones that I use dozens of times per day.  One of those is actually my favorite time saver.  Can you guess what it is?  Want a hint? I already gave you one, it is a “Time Saver”, date &/or time that is.

How much effort does it take to type a date and time into a cell? Can you do it without looking at the keys on the keyboard?  My favorite keyboard shortcut for Microsoft Excel allows me to Insert a static date or time into an Excel cell.

 

 

To Enter The Date &/or Time

Select the cell you want to insert the current date &/or time

  • To insert the current date, press Ctrl+; (semi-colon).
  • To insert the current time, press Ctrl+Shift+; (semi-colon).
  • To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).

 

excel-dates

 

 

That is all there is to it.  If you are required to enter time values in Microsoft Excel, this can quickly become your favorite Time & Date saver too.

References

Do you want to learn even more Microsoft Excel keyboard shortcuts?  Learn from one of Canada’s Microsoft Excel MVPs.

* Debra Dalgleish‘s website -Microsoft Excel keyboard shortcuts.

 

* 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.

 

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