Links

Links at HiTech Coach

Microsoft Office Excel Tips, Support and Templates

  • Hits: 2035
    Excel Forum at UtterAccess
  • Hits: 1927
    Code For Excel And Outlook
    Automation and VBA code for Microsoft
  • Hits: 1720
    Free Tutorial on Excel Macros
  • Hits: 1657
    Erlandsen Excel and VBA Tips
    Advanced VBA programming and workbook functions
  • Hits: 2030
    Better Solutions
    Includes a step-by-step "how to" section covering Excel formulas, functions, methods and options.
  • Hits: 2044
    XL Dennis
    The Swedish Excel site by XL Dennis. Hej compis. "Helsvensk professionell sajt om tips & tricks i Ms Excel."
  • Hits: 1885
    ExcelUsers - Excel Addins and Blog
  • Hits: 2649
    The Imposing INDEX
    From my perspective, the INDEX function is the single most important worksheet function in Excel. Now that might be surprising considering the function's humdrum name. So what's so great about the INDEX function? It's nonvolatile, sprightly, agile, and versatile. INDEX can return one value or an array of values; it can return a reference to one cell or to a range of cells. INDEX works well on either side of the three Reference Operators - the colon, the space, and the comma.
  • Hits: 2613
    2010: Add the date, time, file name, and page numbers to Excel headers or footers (video)
    While researching the top search terms and phrases on the Office.com web site, I discovered that just like Word users, many people who use Excel 2010 want to add page numbers, the date and time, a file name, and other text to the header or footer of all worksheets in a workbook. So here's a video I created to help you accomplish this task.
  • Hits: 2190
    Excel VBA Basic Tutorial 1
    his page contains the 1st lesson on the Excel VBA Basic Tutorial series. It covers topics in creating and managing array and understanding the VBA decision and loop structures.
  • Hits: 2253
    Excel VBA Basic Tutorial 2
    This page contains the 2nd lesson on the Excel VBA Basic Tutorial series. It covers topics in the most used Excel objects and collections.
  • Hits: 1866
    Excel Viewer
    Open, view, and print Excel workbooks, even if you don't have Excel installed.
  • Hits: 1488
    Video: Get even more out of conditional formatting
  • Hits: 1512
    Excel Skill builders = free training videos
    Free online videos
  • Hits: 1631
    Excel - Fixing Startup problems
    By Excl MVP Unfortunately, many Excel users sometimes start experiencing problems with their Excel: File not found errors, compile errors, GPF's, Excel refusing to load, files which do not open, etcetera.
  • Hits: 2097
    Excel 2010 Shortcuts
    A wiki-style reference database for keyboard shortcuts for Excel 2010
  • Hits: 1799
    Highly Used Keyboard Shortcuts in Excel 2010
    Shortcuts are time savers. It is pretty irritating to be interrupted by constant need to move back and forth the mouse over the menu and ribbons to look for mundane tasks of inserting tables or frequently required actions. There are over 180 shortcuts keys in Excel 2010 for easy navigation. However, not all of them are useful ones. Some of them are for highly specialized use.
  • Hits: 1068
    Excel:Save a workbook or worksheet as a template

    To save time or to promote standardization, you can save a workbook as a template that you can use to create other workbooks. In Microsoft Office Excel 2007, a template file (.xltx) can include data and formatting, and a macro-enabled template file (.xltm) can also include macros.

    You can use one of your own templates to create a new workbook, or you can use one of the many predefined templates that you can download from Microsoft Office Online.

Subcategories

  • Excel Power Pivot

    Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.

    # of links:
    3

Latest News