Microsoft Office Excel 2010
Links to Microsoft Excel tutorials and news in July 2011
- Easy budget management with Excel: blogs.office.com/b/microsoft-excel/
- Embed an Excel spreadsheet on a web page: office.microsoft.com/en-us/excel/
- Oprah's - I mean Crabby's - favorite things - Excel 2010: blogs.office.com/b/crabby_office_lady/
Links to Microsoft Excel tutorials and news in June 2011
- 10 New SmartArt graphics available for Excel, Outlook, PowerPoint, and Word: blogs.office.com/b/office_blog/
Links to Microsoft Excel tutorials and news in May 2011
- Make your data pop with conditional formatting: blogs.office.com/b/microsoft-excel/
- Merging and splitting cells or data: blogs.office.com/b/microsoft-excel/
- Take the first step in growing your Excel skills: blogs.office.com/b/microsoft-excel/
- Where to begin - PowerPivot for Excel: blogs.office.com/b/microsoft-excel/
Links to Microsoft Excel tutorials and news in April 2011
- Add the date, time, file name, and page numbers to your headers or footers: blogs.office.com/b/microsoft-excel/
- Bite-sized spreadsheets: blogs.office.com/b/office_blog/
- Simple formulas can make you an Excel hero: blogs.office.com/b/office_blog/
Links to Microsoft Excel tutorials and news in March 2011
- Count values that meet a condition with the COUNTIF function: blogs.office.com/b/microsoft-excel/
- Format column sparkline charts using the date axis and cell merging: blogs.office.com/b/microsoft-excel/
- Interactive Excel files on web pages - An Excel PM explains: blogs.office.com/b/crabby_office_lady/
- Let's dance - Move or position WordArt (video): blogs.office.com/b/office_casual/
- Staying on budget might be easier than you think: blogs.office.com/b/microsoft-excel/
- Tip o’ the Week #19 - Navigating multi-sheet Excel workbooks: blogs.technet.com/b/ewan/
- Tip o’ the Week #23 - Viewing Excel sheets side by side: blogs.technet.com/b/ewan/
- You asked about pivot table (video): blogs.office.com/b/microsoft-excel/
Links to Microsoft Excel tutorials and news in February 2011
- Apply an artistic effect to a picture in Excel 2010, PowerPoint 2010 or Word 2010: office.microsoft.com/en-us/powerpoint-help/
- Business expenses and invoice templates - From good to great in under 5 minutes: blogs.office.com/b/microsoft-excel/
- Cheque register template for Excel 2010: office.microsoft.com/en-us/templates/
- Excel jargon demystified - The basics: blogs.office.com/b/crabby_office_lady/
- Manually paste text into a workbook? No way: blogs.office.com/b/microsoft-excel/
- Working backwards - rows to text files: blogs.office.com/b/microsoft-excel/
Links in January 2011
- Give Excel tables a try: blogs.office.com/b/microsoft-excel/
- Repair numbers formatted as text: blogs.office.com/b/microsoft-excel/
Links in December 2010
- Free for all - Comma Delimited files, Excel Transpose, Programmer Calculator with a Hex thrown in: blogs.msdn.com/b/devschool/
- Oprah's — I mean Crabby's — favorite things - Excel 2010: blogs.office.com/b/crabby_office_lady/
Links in November 2010
- Excel, PowerPivot and Data Mining Twitter: www.visitmix.com/LabNotes/
- Microsoft PowerPivot: www.powerpivot.com
- Quick tips and tricks: www.microsoft.com/atwork/skills/tipsexcel.aspx
- Spelling tests with Microsoft Excel 2010: www.activedad.co.uk
Links in September 2010
- Apply conditional formatting in Excel (Video): office.microsoft.com/en-us/excel-help/
- Customize how your Excel Web App workbook is embedded: office.microsoft.com/client/helppreview14.aspx
- Display fractions in a Microsoft Office Excel 2007 spreadsheet: www.microsoft.com/Education/DisplayFractions.aspx
- Embedded Excel and PowerPoint Available Now on SkyDrive: blogs.msdn.com/b/officewebapps/
- Embedding Excel Web App in your own web page or blog: blogs.msdn.com/b/excel/
- Excel - Insert sparklines to show data trends: office.microsoft.com/en-us/excel-help/
- Free Excel templates save time for busy parents, students, and teachers: blogs.msdn.com/b/excel/
- Get to know Excel 2010 - Create your first spreadsheet: office.microsoft.com/en-us/excel-help/
- PivotViewer – Collections: mtaulty.com/CommunityServer/blogs/mike_taultys_blog/
Links in July 2010
- Crabby's delicious Excel tips for every palate: blogs.office.com/b/crabby_office_lady/
- Creating a Pivot Collection (Part 2 of 3): martimedia.blogspot.com
- Excel Tower Defense: www.youtube.com/officevideos
- Practical Spreadsheets for practical people: blogs.office.com/b/templates_and_images/
- Quick paste in Excel — Crabby's Monday favorite: blogs.office.com/b/crabby_office_lady/
Links in June 2010
- Daylight calculator for Excel - Template du Jour: blogs.office.com/b/templates_and_images/
- Excel stealth for World Cup fans: blogs.office.com/b/templates_and_images/
- PowerPivot in Excel 2010 - Millions of rows: blogs.office.com/b/office-show/
- Use slicers to filter PivotTable data: office2010.microsoft.com/en-us/excel-help/
New links in May 2010
- Excel template to track 2010 FIFA World Cup games: blogs.office.com/b/templates_and_images/
- Microsoft PowerPivot: www.powerpivot.com
- Profit and Loss Spreadsheet for Excel: blogs.office.com/b/templates_and_images/
- Programming and Excel: blogs.msdn.com/alfredth/
- Reviewing the Dow Jones Industrial with Excel 2010: blogs.msdn.com/mvpawardprogram/
Links for April 2010
- 2010 World Cup Tracker for Excel: blogs.office.com/b/templates_and_images/
- Crabby's favorites in Excel 2010blogs.office.com/b/crabby_office_lady/
- Excel Help Forum: www.excelforum.com
Older links with information about Excel 2010
- Crabby Office Lady demystifies Excel terms: office.microsoft.com/en-us/help/
- Excel 2010 - Sparkline Trick: blogs.msdn.com/excel/
- PowerPivot for Excel 2010: www.powerpivot.com
- Programmability Improvements in Excel 2010: blogs.msdn.com/excel/
- Two popular time savers: blogs.office.com/b/office_blog/
Office Excel Web App
See the Office Web App page for links to sites to help you get started with the Excel Web App.
Microsoft Office Excel
Spreadsheets have been around for ages but there's always something new to learn:
- 4 Quick Tips for Using Excel: www.microsoft.com/athome/moredone/4exceltips.mspx
- Announcing Solver Foundation 2.0: blogs.msdn.com/natbr/
- Chart Advisor - How to Use: blogs.msdn.com/excel/
- Chart Pattern Fills in Excel: blogs.msdn.com/excel/
- Chart Templates in Excel: blogs.msdn.com/excel/
- Conditional Formatting and Data Validation: blogs.msdn.com/excel/
- Create a Pivot Table: techonthenet.com/excel/pivottbls/create.php
- Create a Timeline in Microsoft Excel: www.microsoft.com/Education/CreateTimeline.mspx
- Create an in-cell bar graph with Excel: lifehacker.com/software/
- Create charts in Excel 2007 (Demo): office.microsoft.com/en-us/help/
- Data takes shape with conditional formatting: office.microsoft.com/en-us/excel/
- Decision Matrix (with Excel spreadsheet): blogs.msdn.com/mswanson/
- Examples of commonly used formulas: office.microsoft.com
- Excel 2003 to Excel 2007 command reference guide: office.microsoft.com
- Excel budget templates: www.microsoft.com/office/2007-rlt/en-US/Excel
- Excel Training for Teachers (and others): blogs.msdn.com/alfredth/
- Formula to Access a List of Values Interspersed with Zeros or Blanks: blogs.msdn.com/excel/
- Free financial calculators from Vertex42: blogs.office.com/b/templates_and_images/
- Hidden gems in Excel 2007: office.microsoft.com
- Hidden gems in Excel 2007, part 1 - The sheets that never end: blogs.msdn.com/inside_office_online/
- Hidden gems in Excel 2007, part 2 - Give your lists some bounce and shine: blogs.msdn.com/inside_office_online/
- How to Create a Perpetual Yearly Calendar in Excel: blogs.msdn.com/excel/
- How to Create a Professional Chart using Excel 2007: blogs.msdn.com/excel/
- Importing Charts from Spreadsheets to Wordprocessing Documents: blogs.msdn.com/brian_jones/
- Importing a Table from WordprocessingML to SpreadsheetML: blogs.msdn.com/brian_jones/
- Introducing PowerPivot: blogs.msdn.com/excel/
- Long tail of Excel users: blogs.msdn.com/alspeirs/
- Microsoft Office Labs releases Chart Advisor: blogs.msdn.com/stevecla01/
- Microsoft's MSDN Recommends Free Financial Calculator Templates for Excel 2007: bhandler.spaces.live.com
- One Click Calendar Wizard 1900-2078: office.microsoft.com/en-us/templates/
- Overview of charting in Excel: office.microsoft.com/en-us/excel/
- Popular time savers, starting with two from Excel: blogs.msdn.com/inside_office_online/
- Principles of Effective Spreadsheet Design: www.microsoft.com/australia/worksmart/
- Project Scheduling using Solver Foundation in Excel: blogs.msdn.com/natbr/
- Repeating a Set of Data: blogs.msdn.com/excel/
- Robust Way To Reference Multiple Columns In a Table: blogs.msdn.com/excel/
- School Data Excel Tutorials: www.schooldatatutorials.org
- Shadows on Charts and Cells in Excel 2007: blogs.msdn.com/excel/
- Simple Expense Tracking With New Excel 2007 Functions: blogs.msdn.com/excel/
- Sort data in Excel in "High, Medium, Low" order: blogs.technet.com/kclemson/
- Solver Foundation 2.0 Preview - Simulation and Stochastic Programming: blogs.msdn.com/natbr/
- Surviving the switch to Excel 2007 : blogs.msdn.com/inside_office_online/
- Top 10 reasons to use Access with Excel: office.microsoft.com/en-us/excel/
- Travel expense calculator for Excel 2007: blogs.msdn.com/inside_office_online/
- Twitter from Excel 2007: blogs.msdn.com/johnrdurant/
- Understanding Floating Point Precision in Excel: blogs.msdn.com/excel/
- Using Excel 2007 for Progress Tracking in the Classroom: blogs.msdn.com/excel/
- Using Excel (the real one) to read Twitter: news.office-watch.com
- Using parameters with web queries: blogs.msdn.com/excel/
- Week Numbers in Excel: blogs.msdn.com/excel/
- When a Number is Not a Number: blogs.msdn.com/excel/
- Why Can't I Open Two Files With the Same Name?: blogs.msdn.com/excel/
You didn't think Excel could do this
- 2007 Rugby World Cup tracker for Excel 2007: office.microsoft.com/en-au/templates/
- AC/DC Excel Spreadsheet Music Video: gizmodo.com
- Animating Objects in Excel 2007 Using the 3-D Animation Engine: msdn2.microsoft.com/en-us/library/bb629413.aspx
- Build an Understandable Sudoku Solver Using Excel Iterative Calculation - Part 1/2: blogs.msdn.com/excel/
- Build an Understandable Sudoku Solver Using Excel Iterative Calculation - Part 2/2: blogs.msdn.com/excel/
- Building the Excel Media Player - Part 1: blogs.msdn.com/excel/
- Building the Excel Media Player - Part 2: blogs.msdn.com/excel/
- Building the Excel Media Player - Part 3: blogs.msdn.com/excel/
- Conway's Game of Life in Excel: blogs.msdn.com/excel/
- Creating an Excel Game (or something similar for fun): blogs.msdn.com/jannemattila/
- Fun and Games in Excel: www.xl-logic.com/pages/games.html
- Iteration & Conway's Game of Life in Microsoft Excel: blogs.msdn.com/excel/
- Match in Excel: blogs.msdn.com/excel/
- Pacelman - Pacman for Excel: www.geocities.jp/nchikada/pac/
- Revolutionary 3D Game Engine?: www.gamasutra.com
- Unusual (but cool!) Uses of Excel: blogs.msdn.com/excel/