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 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
- Feb 27, 2017
- 4 min
Tips for Structuring your Excel Data
Excel has some amazing report tools including charts and pivot tables. These tools are quick and easy to use, and produce some spectacular reports. However, if your data is not structured cleanly, these tools will stumble. When clients ask us to create reports on their Excel data, the first (and often, longest) task is to clean up the data so that it’s in a consistent state for reporting. Since Excel is not a database tool, it allows you to enter your data in a way that may b
10 views0 comments
Kimberlee Martin
- Nov 30, 2016
- 4 min
Access or Excel?
Excel or Access? Microsoft has lots of great tools, and in most cases, it’s pretty clear which you need to use. If you need to write a letter, Word is your tool. If you need to create a slideshow, that’s PowerPoint. But often there’s confusion about Excel and Access. Since both can be used as database tools, which is best? The answer is: it depends. If you’re asking the question, you are probably already familiar with Excel, and you’ve probably already come across some of the
12 views0 comments
Kimberlee Martin
- Oct 31, 2016
- 4 min
What is Excel VBA?
If you've ever thought about creating macros in Excel, you've probably heard the term "VBA". In this post, I'm going to give you a little background on VBA so that you can decide if it's something you want to tackle. Excel is a great tool for analyzing and presenting your data. But if you're like most people, you spend more time than you'd like performing repetitive tasks. Maybe you need to import data from your database once a month, sort it, and format it, for example. Macr
25 views0 comments
{"items":["6005a71630075c0017fb44b4","5f3ae48abd5d500017d890c4","5f31638c3ff29a00176225b1","5f2853efb7aa7f001787d746","5f10f2f7bc479b00176a8189","5eeb618a9aa374002dde19ca","5eeb618a2186d20043070175","5eeb618aa2cf08002ef2f360"],"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}}