Excelguru.ca - Powered by vBulletin
  • Register
  • Help
  • The Facebook Platform

  • Knowledge Base
    • Today's Posts
    • FAQ
    • Calendar
    • Community
      • Member List
    • Forum Actions
      • Mark Forums Read
    • Quick Links
      • View Site Leaders
  • Blog
  • Forum
  • Forum Tools
    • What's New?
    • Today's Posts
  • Courses
    • Excelguru e-Learning Catalog
    • The Magic of PivotTables (2003)
    • The Magic of PivotTables (2007)
    • The Magic of PivotTables (2010)
    • Instructor Led Training
    • Sell Excelguru Courses On Your Site
  • Resources
    • Excelguru e-Learning Catalog
    • Books
    • Charting & Dashboarding Resources
    • Useful Add-ins and Tools
    • Other Forums
    • Excel Blogs
    • Useful Links
    • Excel Training Calendar
    • Consulting
    • Sales Affiliate Program
  • FAQ
    • FAQ Index
    • General Forum Usage
    • Reading and Posting Messages
    • Supported BB Code Tags
    • Multi Forum Posting Policy
  • About
    • About Me
    • Awards
    • Testimonials
    • Contact Me
  • Advanced Search
  • Home
  • Home
  • Knowledge Base Articles

  1. If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.
    Register here so that you can post in the forums or comment on the articles.

  • Knowledge Base Articles By Category

    Access - ADO (4)
    Access - SQL (4)
    Access - VBA Programming (10)
    Downloads - Games (1)
    Downloads - Learning Aids (11)
    Downloads - Utilities (6)
    Excel - ADO (4)
    Excel - Charts and Data Visualization (1)
    Excel - Formulas (8)
    Excel - General Tips (36)
    Excel - Interactive Pages (9)
    Excel - PivotTables (11)
    Excel - PowerPivot (6)
    Excel - SQL (4)
    Excel - UDF (7)
    Excel - User Interface Customization (2)
    Excel - VBA Programming (48)
    Excel - WebApp (4)
    Internet Explorer - VBA Programming (1)
    Novell Groupwise - VBA Programming (2)
    Other - General (0)
    Outlook - General Tips (5)
    Outlook - VBA Programming (7)
    PDF Creator - VBA Programming (11)
    PowerPoint - VBA Programming (7)
    Publisher - VBA Programming (7)
    Syndicated Articles (7)
    Training Products (3)
    Word - VBA Programming (8)
  • Learn how to create Excel dashboards.
  • Excel - WebApp

    Sharing in the Microsoft Excel WebApp 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2011-04-14 10:30 PM     Number of Views: 2095 

    In Introduction to the Excel WebApp, we learned how to create, upload and view files in Microsoft's Web Version of Excel, hosted on SkyDrive (a free offering from Windows Live.)

    It should be noted that thee main reason for creating a file in the Excel WebApp is to share it with others. ...
    Read More Read More

    Introduction to the Excel WebApp 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2011-04-11 10:21 PM     Number of Views: 2532 

    In June 2010, Microsoft released the Excel WebApp as part of their Windows Live offerings. This is an interesting product as it allows you to store, read, edit and share your Excel document in the cloud. This means that it is no longer necessary to email your file around to all of your friends; you can have it stored in one place so that everyone is always working with the latest version of the spreadsheet. ...
    Read More Read More

    Data Validation in Excel Services 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2011-03-08 08:09 PM     Number of Views: 669 

    I’m a huge consumer of Data Validation in Excel. At this point, however, Excel services (the Excel webApp) is still so new that there are very few of the techniques that we normally use in Excel which are web compliant. This article looks at ways that we can implement data validation into an Excel services solution.
    ...
    Read More Read More

    Another Excel Services (Skydrive) Example 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2011-03-03 08:35 PM     Number of Views: 335 

    This particular file will show an interactive breakeven analysis for an event entailing food and beverage.

    You can interact with the file and have the chart redraw. Probably the best route is to adjust by very large amounts to see the effects.

    Here you go, have a play!
    ...
    Read More Read More
  • MVP Logo
  • Recent Forum Posts

    JeffreyWeir

    Help required for League Table data entry

    1:30am is prime poker playing time.
    Here's the cause of the problem:
    The formula in cell AC4 is hard coded to refer to your initial table...

    JeffreyWeir Today, 02:01 AM Go to last post
    Brian Thomas

    Help required for League Table data entry

    Many thanks for your efforts today NBVC and Jeffrey. I have to sleep now, it's 1.30am here and I have to be up early. I'll get back to you tomorrow ...

    Brian Thomas Today, 01:39 AM Go to last post
    JeffreyWeir

    Help required for League Table data entry

    Okay, I'll take a look....

    JeffreyWeir Today, 01:17 AM Go to last post
    Brian Thomas

    Help required for League Table data entry

    Yep, all is fine bar that....

    Brian Thomas Today, 01:17 AM Go to last post
    JeffreyWeir

    Help required for League Table data entry

    Okay. So apart from that 680 being applied to blanks, are the correct amounts being applied to the correct people?...

    JeffreyWeir Today, 01:15 AM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 02:09 AM.
Powered by vBulletin® Version 4.2.0
Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.
Thread / Post Bookmarking by Thread / Post Bookmarking v1.1.0 - vBulletin Mods & Addons Copyright © 2013 DragonByte Technologies Ltd. Runs best on HiVelocity Hosting.
Copyright © 2004-current by Ken Puls
Gravatar by 1e2.it