Webinar: Simplifying your data in Excel

Here is the recording from this week's free Office 15-Minute Webinar about simplifying data in Excel. You can join our webinars live at 9:15 am PDT. Click http://aka.ms/offweb for complete information.

 What you will learn at Tuesday’s webinar

  1. Using Conditional Formatting
  2. Adding Sparklines
  3. Better charts for presentations
  4. A new tool to learn Excel

References for this webinar: 

1) Conditional Formatting

2) Sparklines

3) Excel Skills Builder  (Lesson 2 is about creating charts)

--Doug Thomas

Office Blogs Comments

Comments: (5) Collapse

  • Like the webinar's.  Keep them coming.

  • Thanks John: will do. Next week is OneNote, http://aka.ms/offweb.

    --Doug

  • I guess I could try the cheap excuse by saying that our country has changed to DST and as such I totally missed the webinair /again/ :-(   Of course that would be a very dumb idea on an Office blog considering how both Outlook 2010 as well as mobile Outlook on my Windows Phone easily (and automatically!) shifted the whole thing one hour ahead (its now on 18:15 in my local timezone). Still am kinda dissapointed though, but hopefully I'll manage next week; OneNote is definitely one of my favorite topics.

    Just to quickly comment on the presentation (glad that you guys record all this!).. Excel has IMO /way/ surpassed the stage where its (only?) strength lies in processing financially based data.

    Example; I do a lot of systems administration on my Linux servers. Sometimes this means going through logfiles to check up on questions, comments or complaints from customers. I used to simply use commandline tools. Nowadays I more than often either copy & "import paste" sections or import an entire logfile into Excel and then apply tables and filters to it as required. Makes things a /whole/ lot easier to disect and investigate.

    Heck; if something icky is going on I can now not only sort on (for example) IP addresses, I can also quickly check up if a particular IP address is known in other sections of my logs. Its /ideal/. Even for a systems administrator. And don't get me started on grabbing data directly from foreign sources (for example HTTP based imports)...  Now think about doing all that and automating it using VBA programs and things get really cool :-)

    Say; may I be so bold as to ask what the glitch was on your end? It seemed as if the presentation itself (Lync Server?) was still going strong on the client side. From the sound of it it almost seems as if you may have accidentely turned of the screen on your end...

    Alas, hope to be there next week. Looking forward to OneNote.

  • SheLuser: Thanks for the comments. No glitch are on end, just checking the delay to make sure your screens have caught up with menu with presenting.

    -Dougg

  • very useful features to make sense of data sets quickly. thanks