Search


Kimberlee Martin
- Aug 3, 2020
- 3 min
I Don't Know It All
I am the first to admit that when it comes to Excel, I don’t know it all. Hard to believe, I know (LOL!!) I’ve had students who don’t seem to believe that. Like any good instructor, I can appear to walk on water from time to time. It’s all illusion, though, trust me. There’s a quote I’ve always liked: Any sufficiently advanced technology is indistinguishable from magic. - Sir Arthur C. Clarke That’s why I sometimes seem magical to my students. I’m using the sufficiently advan
4 views0 comments

Kimberlee Martin
- Jul 27, 2020
- 4 min
The Arguments of VLOOKUP
In previous blogs, I’ve talked about Excel’s VLOOKUP function. In one, I covered the purpose of VLOOKUP, and in the other, I explained the difference between VLOOKUP and HLOOKUP. Today, let’s take a look at the arguments of the VLOOKUP function. I’ve never been happy with the way Microsoft explains them in the Insert Function dialog box – I find their terminology confusing. In this blog, I’m going to try to clarify these arguments for you. Let me start by showing you what the
2 views0 comments

Kimberlee Martin
- Jul 17, 2020
- 3 min
Three Excel Functions You Should Be Using
Excel is a great tool for data analysis, with a powerful suite of built-in functions to help. You’re probably already familiar with some of the most common features, like SUM, AVERAGE and VLOOKUP. Here are three that you may not have heard of, but that are likely to help with your Excel projects. 1. DAYS The first function is DAYS. This function calculates the number of days between two dates. Here’s an example of when this might come in handy: In this example, I am calculati
10 views0 comments

Kimberlee Martin
- Jul 9, 2020
- 2 min
VLOOKUP vs. HLOOKUP
In my last post, I talked about why you might use the VLOOKUP feature. If you missed it, you can find it here. Today, I’m going to discuss the difference between VLOOKUP and HLOOKUP. The two features are nearly identical. The difference between the two is in the orientation of your lookup data. Let me explain. VLOOKUP stands for Vertical look-up. It works great when your look-up data is oriented vertically. Take a look at this example: Notice that the names go down column A,
6 views0 comments

Kimberlee Martin
- Apr 30, 2020
- 2 min
What is VLOOKUP, and Why Do I Need It?
VLOOKUP is one of the coolest features of Microsoft Excel, and also one of the least understood. Lots of people are interested in it and have great cases for using it. But I get many people who tell me that they don't use it because they don't really understand how it works. Is it magic? YES! Well, sort of. OK, no. But still, it's one of the coolest features of Excel, and well worth understanding. In a nutshell, VLOOKUP is a database feature. Now, mind you, I don't recommend
18 views0 comments

{"items":["6005a71630075c0017fb44b4","5f3ae48abd5d500017d890c4","5f31638c3ff29a00176225b1","5f2853efb7aa7f001787d746","5f1efef503758e001761f210","5f10f2f7bc479b00176a8189","5f07625ff3dee0001712c644","5eeb618a52b4f0002ec22953","5eeb618a30a965002dbf7ed7"],"styles":{"galleryType":"Columns","groupSize":1,"showArrows":true,"cubeImages":true,"cubeType":"fill","cubeRatio":1.3333333333333333,"isVertical":true,"gallerySize":30,"collageAmount":0,"collageDensity":0,"groupTypes":"1","oneRow":false,"imageMargin":32,"galleryMargin":0,"scatter":0,"rotatingScatter":"","chooseBestGroup":true,"smartCrop":false,"hasThumbnails":false,"enableScroll":true,"isGrid":true,"isSlider":false,"isColumns":false,"isSlideshow":false,"cropOnlyFill":false,"fixedColumns":1,"enableInfiniteScroll":true,"isRTL":false,"minItemSize":50,"rotatingGroupTypes":"","rotatingCropRatios":"","columnWidths":"","gallerySliderImageRatio":1.7777777777777777,"numberOfImagesPerRow":1,"numberOfImagesPerCol":1,"groupsPerStrip":0,"borderRadius":0,"boxShadow":0,"gridStyle":1,"mobilePanorama":false,"placeGroupsLtr":true,"viewMode":"preview","thumbnailSpacings":4,"galleryThumbnailsAlignment":"bottom","isMasonry":false,"isAutoSlideshow":false,"slideshowLoop":false,"autoSlideshowInterval":4,"bottomInfoHeight":0,"titlePlacement":"SHOW_ON_THE_RIGHT","galleryTextAlign":"center","scrollSnap":false,"itemClick":"nothing","fullscreen":true,"videoPlay":"hover","scrollAnimation":"NO_EFFECT","slideAnimation":"SCROLL","scrollDirection":0,"scrollDuration":400,"overlayAnimation":"FADE_IN","arrowsPosition":0,"arrowsSize":23,"watermarkOpacity":40,"watermarkSize":40,"useWatermark":true,"watermarkDock":{"top":"auto","left":"auto","right":0,"bottom":0,"transform":"translate3d(0,0,0)"},"loadMoreAmount":"all","defaultShowInfoExpand":1,"allowLinkExpand":true,"expandInfoPosition":0,"allowFullscreenExpand":true,"fullscreenLoop":false,"galleryAlignExpand":"left","addToCartBorderWidth":1,"addToCartButtonText":"","slideshowInfoSize":200,"playButtonForAutoSlideShow":false,"allowSlideshowCounter":false,"hoveringBehaviour":"NEVER_SHOW","thumbnailSize":120,"magicLayoutSeed":1,"imageHoverAnimation":"NO_EFFECT","imagePlacementAnimation":"NO_EFFECT","calculateTextBoxWidthMode":"PERCENT","textBoxHeight":0,"textBoxWidth":200,"textBoxWidthPercent":50,"textImageSpace":10,"textBoxBorderRadius":0,"textBoxBorderWidth":0,"loadMoreButtonText":"","loadMoreButtonBorderWidth":1,"loadMoreButtonBorderRadius":0,"imageInfoType":"ATTACHED_BACKGROUND","itemBorderWidth":1,"itemBorderRadius":0,"itemEnableShadow":false,"itemShadowBlur":20,"itemShadowDirection":135,"itemShadowSize":10,"imageLoadingMode":"BLUR","expandAnimation":"NO_EFFECT","imageQuality":90,"usmToggle":false,"usm_a":0,"usm_r":0,"usm_t":0,"videoSound":false,"videoSpeed":"1","videoLoop":true,"jsonStyleParams":"","gallerySizeType":"px","gallerySizePx":940,"allowTitle":true,"allowContextMenu":true,"textsHorizontalPadding":-30,"itemBorderColor":{"value":"#494549"},"showVideoPlayButton":true,"galleryLayout":2,"targetItemSize":940,"selectedLayout":"2|bottom|1|fill|true|0|true","layoutsVersion":2,"selectedLayoutV2":2,"isSlideshowFont":false,"externalInfoHeight":0,"externalInfoWidth":0.5},"container":{"width":940,"galleryWidth":972,"galleryHeight":0,"scrollBase":0,"height":null}}