Health Benefits of Acai Berries

Microsoft Kitchen - 18 hours 34 min ago
Acai berries are slightly smaller than grapes, although look fairly similar. The trees that they grow on are found in the Amazon Basin, particularly in Brazil. Acai berries have been consumed by various indigenous peoples of South America for thousands of years, but recently have become popular and fashionable throughout the world as a health supplement. However, […]

Health Benefits of Almonds

Microsoft Kitchen - Tue, 11/13/2018 - 01:00
One of the world’s most popular nuts (though it’s botanically a seed), the almond is a well-loved snack in every corner of the globe. The seed itself comes from the deciduous almond tree, which is native to the Middle East and a few sections of Southern Asia. For thousands of years, humans have recognized the […]

Keyboard Metrics III

Daily Dose of Excel - Mon, 11/12/2018 - 14:00

In the grand tradition of Keyboard Shortcut Metrics and More Keyboard Metrics, here’s this:

Procedure 2016 2017 2018 Grand Total MakeComma 20.54% 18.67% 19.01% 19.19% WrapSheetsDown 13.80% 17.15% 9.93% 14.93% WrapSheetsUp 8.60% 15.36% 7.33% 12.16% FillVirtualScreen 10.50% 11.04% 8.42% 10.40% CopyPasteValues 14.00% 4.84% 2.20% 6.54% ShowFormatting 5.85% 5.13% 7.04% 5.68% IncrementDate 4.25% 4.08% 9.77% 5.23% MarkYellow 4.55% 5.44% 5.29% 5.20% SelectAdjacentCol 4.87% 4.71% 6.19% 5.04% DecrementDate 3.56% 1.87% 11.93% 4.24% GetMappedAddress 2.39% 2.21% 2.73% 2.35% FrozenHome 2.26% 2.39% 2.32% 2.34% MakeTable 0.00% 1.80% 4.07% 1.81% ChangeSign 2.03% 1.35% 0.77% 1.40% FillSeries 0.49% 1.38% 1.99% 1.28% CopySum 2.22% 1.18% 0.33% 1.27% ConvertColumnToText 0.00% 0.63% 0.00% 0.36% SelectPrecedents 0.00% 0.46% 0.12% 0.29% SwitchAggregate 0.00% 0.24% 0.49% 0.23% MatchColumnWidths 0.10% 0.06% 0.08% 0.07% Grand Total 100.00% 100.00% 100.00% 100.00%

Look at DecrementDate making a charge.

Categories: Data, Microsoft

Incrementing Months and Years

Daily Dose of Excel - Fri, 11/09/2018 - 21:55

As you know, I love keyboard shortcuts. But I hate entering dates. So I created this little helper. In my new accounting system, they also have shortcut keys for incrementing weeks, months, and years. I don’t have much use for incrementing weeks, but I could kick myself for not thinking of the others. Plus Alt+semi-colon is just sitting there doing nothing.

Public Sub IncrementMonth() On Error Resume Next gclsAppEvents.AddLog "%;", "IncrementMonth" If IsDate(ActiveCell.Value) Then ActiveCell.Value = DateSerial(Year(ActiveCell.Value), Month(ActiveCell.Value) + 1, Day(ActiveCell.Value)) ElseIf IsTextTime(ActiveCell.Text) Then ActiveCell.Value = ActiveCell.Value + 1 / 24 End If End Sub Public Sub DecrementMonth() On Error Resume Next gclsAppEvents.AddLog "+%;", "DecrementMonth" If IsDate(ActiveCell.Value) Then ActiveCell.Value = DateSerial(Year(ActiveCell.Value), Month(ActiveCell.Value) - 1, Day(ActiveCell.Value)) ElseIf IsTextTime(ActiveCell.Text) Then ActiveCell.Value = ActiveCell.Value - 1 / 24 End If End Sub Public Sub IncrementYear() On Error Resume Next gclsAppEvents.AddLog "^%;", "IncrementYear" If IsDate(ActiveCell.Value) Then ActiveCell.Value = DateSerial(Year(ActiveCell.Value) + 1, Month(ActiveCell.Value), Day(ActiveCell.Value)) ElseIf IsTextTime(ActiveCell.Text) Then ActiveCell.Value = ActiveCell.Value + 1 End If End Sub Public Sub DecrementYear() On Error Resume Next gclsAppEvents.AddLog "^+%;", "DecrementYear" If IsDate(ActiveCell.Value) Then ActiveCell.Value = DateSerial(Year(ActiveCell.Value) - 1, Month(ActiveCell.Value), Day(ActiveCell.Value)) ElseIf IsTextTime(ActiveCell.Text) Then ActiveCell.Value = ActiveCell.Value - 1 End If End Sub

Categories: Data, Microsoft

Free Table tools add-in

Daily Dose of Excel - Fri, 11/09/2018 - 17:10

Do you want to be able to rename your Excel tables and columns without breaking existing PowerQuery queries? Do you always change the default name of a new table? Want to have quick navigation to your tables in your workbook?
Use my free TableTools add-in


Jan Karel Pieterse

Categories: Data, Microsoft

Health Benefits of Aloe Vera Juice

Microsoft Kitchen - Fri, 11/09/2018 - 01:00
Aloe Vera is very popular for using on the skin, and also because its fresh-smelling scent is great for air fresheners and a range of other uses. However, the consumption of liquid derived from the plant has, so far, been fairly limited – although aloe Vera juice has a wide range of health benefits. Aloe […]

International Keyboard Shortcut Day 2018

Daily Dose of Excel - Wed, 11/07/2018 - 14:00

The first Wednesday of every November is International Keyboard Shortcut Day. Today people from all over the world will become far less efficient for short time in an effort to be far more efficient the rest of the year.

The end of inefficiencies. Am I right?

To celebrate this year, I took my wall calendar off my wall and I’ll use Win+Alt+D to view the Windows calendar. My usual method to see an electronic calendar is to Alt+Tab to Outlook and Ctrl+2 to switch to the calendar (Ctrl+1 switches you back to the inbox (or wherever you were in Mail)). I also might Win+1 to get there because Outlook is the first icon on my taskbar. That’s less desirable, though, because Outlook doesn’t always play nice. Sometimes it’s not on month view and it’s a pain to get it to look like I want. So I’ll try out my new found Win+Alt+D to use the built-in Windows calendar.

If you just want to get your feet wet, head over to True Insights and download the The Ultimate Excel 2016 Keyboard Shortcut List. It’s an Excel workbook listing all the shortcuts you’ll ever need. And because it’s in Excel, it’s sortable and filterable. Find one you like and try to put it to use today. Thanks Jacques for putting the list together.

Want to kick it up a notch? Set aside some time today where you only navigate windows folders with the keyboard. Here are some tips to get you started:

  • Turn on autocomplete in File Explorer. Press the Win key and start typing Internet Options. When the app shows up, arrow down to it and press enter. Use Ctrl+tab to get to the Advanced tab. Page Down and arrow down about 1/3 of the way and select Use inline AutoComplete in File Explorer and Run Dialog. Finally tab to the OK button and press Enter.
  • Win+E will open a new Windows Explorer window. Once there, Alt+D will put you in the address bar.
  • As you start typing, Windows will autocomplete folder names. If you type C:\u, Windows will likely autocomplete to C:\Users. Then you can press Tab to complete the entry or arrow down to a different entry if there is more than one. It would be nice if Windows would insert a \ for you, put you have to type that yourself.

Really want to show off? Create your own shortcut key in Excel using Appliction.OnKey. Put it in your PMW or in your general purpose utility addin. Mine is called UIHelpers.xlam. I use 27 different Appliction.OnKey lines in my Auto_Open procedure. Here are a few of my favorites:

Application.OnKey "^;", "IncrementDate" Application.OnKey "^+;", "DecrementDate" Application.OnKey "^+m", "GetMappedAddress" Application.OnKey "^l", "FollowLink"

See Incrementing Dates and Times for what those do. I don’t think I ever posted GetMappedAddress, so here it is.

Sub GetMappedAddress() Dim doClip As MSForms.DataObject gclsAppEvents.AddLog "^+m", "GetMappedAddress" Set doClip = New MSForms.DataObject If Not Application.ActiveProtectedViewWindow Is Nothing Then doClip.SetText Application.ActiveProtectedViewWindow.Workbook.FullName doClip.PutInClipboard Else doClip.SetText ActiveWorkbook.FullName doClip.PutInClipboard End If Set doClip = Nothing End Sub

It just puts the full path of the active workbook in the clipboard. I use it all the time to create a hyperlink in Outlook or to add it as an attachement. I just paste the full path in the File Name box and I don’t have to navigate to where the file is.

That’s a big long path pasted into File Name. Even though my current folder is My Documents, I just paste in that big path and hit enter and it’s done.

Finally, see Hyperlink Keyboard Shortcut Update and be sure to read the comments if you want to implement this one.

Have a great IKSD and leave a comment with how you’ll be celebrating.

Categories: Data, Microsoft

Health Benefits of Blueberries

Microsoft Kitchen - Wed, 11/07/2018 - 01:00
Blueberries are a tasty addition to any breakfast cereal, and a handful at the end of any meal will go down a treat. They’re also a popular addition to muffins and other baking products, and go well in smoothies. They’re easy to store, too – freezing blueberries has no effect on many of the benefits you […]

Health Benefits of Cayenne Pepper

Microsoft Kitchen - Mon, 11/05/2018 - 01:00
Cayenne pepper is a type of chili pepper. It is named after a city in French Guiana, and is also sometimes called the red pepper or cow-horn pepper. It is found in Tex Mex, Mexica, Szechuan and Cajun food. Fresh chillies can be sliced and added to dishes, although cayenne is most-often found in powdered […]

Health Benefits of Celery

Microsoft Kitchen - Fri, 11/02/2018 - 01:00
The humble celery is often used to provide a base flavor in sauces, soups and stews – it’s a workaday vegetable that most people would probably not associate with trendy superfoods. But celery has a surprising number of health benefits. Celery, like black coffee and a handful of other foods, has a negative number of […]

Health Benefits of Coconut Oil

Microsoft Kitchen - Mon, 10/29/2018 - 01:00
The tropical coconut tree, native to tropical climates the world over, has been a diet staple in equatorial areas for hundreds of years. In fact, many of these cultures – especially those in South Asia – get most of their dietary saturated fat from coconut oil. This includes nations such as the Philippines, Indonesia, and […]

Health Benefits of Coriander Seeds

Microsoft Kitchen - Fri, 10/26/2018 - 01:00
Coriander seeds, which are called cilantro seeds in some parts of the world, are very different from the plant’s pungent leaves. Many people who find the leaves unpalatable can happily consume sauces containing the seeds, which are one of the most-used spices in Indian curry powder. They are also used in many other cuisines to […]

Health Benefits of Fish Oil

Microsoft Kitchen - Mon, 10/22/2018 - 01:00
Fish oil does not sound too pleasant, and has echoes of ‘cod liver oil’. But actually, if you like fish, then it’s easy to cook delicious dishes with oily fish. Varieties that are particularly rich in oil are mackerel, sardines, tuna, salmon and anchovies. If you are not too keen on fish, then fish oil […]

Health Benefits of Apple Cider Vinegar

Microsoft Kitchen - Sat, 10/20/2018 - 01:00
Apple cider vinegar has been used as a folk remedy for various ailments for many years, and also as a beauty treatment. Little scientific research has been carried out on the uses of apple cider vinegar – however, most of the problems it is used to treat are minor, and you are unlikely to suffer […]

Health Benefits of Ginger Root

Microsoft Kitchen - Wed, 10/17/2018 - 01:00
Ginger root is found in curries, particularly Indian and Thai curries, and goes well with beef and seafood. Pickled ginger root is also routinely used in Chinese stir frys, and as an accompaniment to sushi. There are several ways of preparing ginger root, but ginger tea is one of the most popular. Ginger tea can […]

Welcome to my blog, the benefits of blogging

Daily Dose of Excel - Tue, 10/16/2018 - 23:38

Hello, welcome to my blog, what are the benefits of blogging?
1. The first one definitely deepens your understanding and memory of knowledge.
2. When writing a blog, because you want to explain this problem to others, you must stand in the position of the reader to think about the problem, then you have a process of empathy, such as how to make a clear explanation for a person who does not understand anything. Problem, this improves the ability to explain something to others
3. When you find that your blog is read and someone likes you, you will be very happy and promote your writing. It is not far from your next one.
4. There are still some people who are careful to find the mistakes in your blog and point them out, which gives you a new harvest.
5. When you write the blog, you will find that you have slowly entered this circle, maybe you have met some people, maybe you haven’t seen each other, but you know them on the website and know that they are big cattle in this respect.
6. If you can keep blogging, it is also a kind of perseverance exercise.
7. When your blog is full of many excellent articles, it not only records the course of your learning, but it is also a good resume.
8. I think blogs are written for you. Many times when we forget a certain knowledge, we don’t know where to look. When you write enough, many times you can review on your blog, and thus greatly Save time
9. When you are old, look at your blog again, and you will be glad that you started writing your first blog.

Categories: Data, Microsoft

Health Benefits of Flax Seeds

Microsoft Kitchen - Mon, 10/15/2018 - 01:00
Flax seeds are usually found in home baking – they can be delicious scattered on scones, cakes or muffins, and can be added to breakfast cereals and granolas. As well as being a useful garnish, they’re also healthy too. Flax seeds are a very good source of omega 3 oils. These are usually found in […]

Health Benefits of Green Tea

Microsoft Kitchen - Fri, 10/12/2018 - 01:00
With the recent rise in interest for healthy foods in the West, perhaps no other item has been discussed and analyzed more than green tea. Its many health benefits – some scientifically supported and others with little backing evidence – have accounted for a huge worldwide increase in green tea consumption over the last few […]

Health Benefits of Olive Leaf

Microsoft Kitchen - Wed, 10/10/2018 - 01:00
Most people are at least partially familiar with the health benefits of olive oil, which is famous for its promotion of wellbeing. But the lesser-known leaves of the olive plant can also be very good for you too. Olive leaves can be manufactured into essential oils and liquid extracts. However, one of the most popular […]

Health Benefits of Oregano Oil

Microsoft Kitchen - Mon, 10/08/2018 - 01:00
When one thinks of Italian food, perhaps the most immediate spice that comes to mind is oregano. The plant, which itself is native to the temperate climates that surround the Mediterranean Sea, is a staple in the diets of many other nearby cultures as well. It is often used as a meat seasoning, for instance, […]
Syndicate content

eXTReMe Tracker