Excelguru Help Site - Excel

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)

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: 2011

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
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: 2446

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
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: 550

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
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: 266

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

Recent Forum Posts

bar charts with two axes

Excel 2010, Table, PivotTable, PivotChart
Bar chart with 2 non-overlapping series.
http://58918aa17d4002474361-7ac2b7ee...05_21_13b.xlsx...
Herbds7 Today, 12:22 AM

Help with charting. How to use only last 15 rows after updating.

Excel 2010 Table, Chart
Use Defined Names
Tables are dynamic.
http://58918aa17d4002474361-7ac2b7ee.../05_21_13.xlsx...
Herbds7 Yesterday, 08:25 PM

IF AND Statement with ISBLANK and conditional

Great - Im glad you resolved it.

Herc...
Hercules1946 Yesterday, 05:42 PM

Unsure how to change vba code to work properly select case and me.controls

I have this code: It works as displayed in the first table.
Set wbk = Workbooks("News.xlsm")
For i = 2 To 11
Select Case Me.Controls("Combobox"
...
cane Yesterday, 05:40 PM

got it!

Hi--got it, I inserted an IF statement in the vlookup that pulls the container # from the other tab that way it returns a blank cell if there is no value...
emartz Yesterday, 04:52 PM

Knowledge Base Articles By Category

Excel - WebApp

Recent Forum Posts