Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Blogs

  • Opening, Closing, and Saving Workbooks

    Happy International Keyboard Shortcut Day. Today, three quick ones for dealing with workbooks. Ctrl+O: Shows the Open dailog box to open a file from disk. The menu is File – Open (Alt + F + O) Ctrl+S: Saves the active workbook. If the active workbook is previously unsaved, shows the Save As dialog to choose […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Nov 5 2014
    Filed under:
  • Navigating and Selecting Cells via the Keyboard

    In honor of International Keyboard Shortcut Day, here are some tips for navigating around and selecting ranges via the keyboard. Arrows The arrow keys are how you navigate cell-to-cell with your keyboard. Earth shattering revelation, isn’t it? Ctrl = End Holding down the Ctrl key while using the arrow keys is the same as the […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Nov 4 2014
    Filed under:
  • Office and Dropbox to work together on phones, tablets and web

    Today we announced a partnership with Dropbox to help you work and collaborate more effectively. You can do more with your Office documents when they are stored online. You can easily share your documents with others, and you can access those files from anywhere, on all your devices. If you use OneDrive and Office together, you already know how easy it is to work online with Office. The post Office and Dropbox to work together on phones, tablets and web appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Nov 4 2014
  • Three Easy Formatting Hotkeys

    In honor of International Keyboard Shortcut Day, here’s three easy to remember shortcuts for formatting text. Ctrl+B: Makes the selected text bold. Get it? ‘B’ is the first letter of ‘bold’. Ctrl+I: Makes the selected text italics. Get it? ‘I’ is the first letter of ‘italics’. Ctrl+U: Makes the selected text underlined. Get it? Of […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Nov 3 2014
    Filed under:
  • International Keyboard Shortcut Day

    Did you know that International Keyboard Shortcut Day is the first Wednesday in November? Considering I just made that up, I’ll bet you didn’t. But I hereby proclaim it so. Mission IKSD was created to spread awareness that you can become more efficient by knowing and practicing keyboard shortcuts. How to Celebrate From 2:30PM to […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Oct 31 2014
    Filed under:
  • Office 365 Search is now smarter about spreadsheets

    Businesses use spreadsheets for many critical functions, such as financial reporting and investment modeling, and they need to minimize the risks that using these spreadsheets introduces. The need for strong spreadsheet management is emphasized in these stories compiled by the European Spreadsheet Risk Interest Group (EuSpRIG). Office responded to this need by introducing new features in Office 2013 to help manage the use of spreadsheets for important business functions, and… The post Office...
    Posted to The Excel Team Blog by Office Blogs on Wed, Oct 29 2014
  • Microsoft sponsors the Financial Modeling World Championships for Excel power users

    ModelOff, the Financial Modeling World Championships for Excel, is a fun and educational international competition for students and professionals. This year, Microsoft continues the tradition of sponsoring this exciting event. The post Microsoft sponsors the Financial Modeling World Championships for Excel power users appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Oct 23 2014
  • Putting together an Excel VBA course

    Hi everyone! I’m putting together an advanced VBA course and I am looking for feedback, as I plan to make this a top-notch training. If you have a couple of minutes to spare (or perhaps are interested in attending an advanced VBA training in The Netherlands), please fill out my survey Thank you in advance! […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Oct 23 2014
    Filed under: , ,
  • Autohotkey for WordPress Blogs

    I’ve added some autohotkey dealies for when I’m writing blog posts. If you’re blog isn’t about Excel and/or doesn’t use the CodeColorer plugin, they won’t be of much use to you. ; ; AutoHotkey Version: 1.x ; Language: English ; Platform: Win9x/NT ; Author: A.N.Other ; ; Script Function: ; Template script (you can customize […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Oct 21 2014
    Filed under:
  • An Even More Better AutoFilter

    You knew I wasn’t going to let this go, didn’t you? I started with snb’s rewrite. I really don’t want to use the SelectionChange event. It runs whenever you move around the spreadsheet and that’s just wasteful. I like how snb did the heavy lifting on SheetActivate, then only burns processors when you change a […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Oct 20 2014
    Filed under:
  • A Better AutoFilter

    Jeff recently wrote about how you can type your filter criterion in a Pivot Table’s page field and it will filter it automagically. That’s awesome. I want the same thing when I filter Tables, so I started doing some experiments. To filter a table, you select the header, press Alt+{DOWN}, e to get to the […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Oct 16 2014
    Filed under:
  • Introducing Microsoft Ignite

    This morning on The Official Microsoft Blog, we revealed more details about our unified enterprise technology conference in May—Microsoft Ignite. The post Introducing Microsoft Ignite appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Oct 16 2014
  • A Daily Overdose of Arrays

    snb, who wrote the detailed piece on dictionaries, has applied the same rigor to arrays. I knew there would be something in there that I didn’t know (there was plenty). Under the section about identifying the existence of an item in an array, you can use a defined name: 6.2.2.3 The Excel-object ‘Names’ Assign the […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Oct 15 2014
    Filed under:
  • Back in the Saddle

    And we’re back. Leave your comments admonishing my server maintenance skills here. I promise I will never try to do the right thing again. KNOW YOUR LIMITS! That’s my new mantra. Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Oct 14 2014
    Filed under:
  • PinkyPivotPimping

    Well here’s something that I probably learned once, but have subsequently forgotten and then rediscovered: You can filter a PivotTable Page Field just by typing the PivotItem that you want to filter it on. So if I start with a PivotTable like this:       And say I don’t like the look of the […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Oct 10 2014
    Filed under:
< Previous 1 2 3 4 5 Next > ... Last »
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.