-
For those of us who crunch words instead of numbers, Excel can be intimidating. We don't know the difference between a workbook and a worksheet, and for sure don't know to ask about conditional formatting (a cool way to visually display data). Then one day your boss asks you to create a report...
-
It's still January. There's still time to share the most popular posts on the Excel blog in 2011. Thanks for reading them! Can't remember all those Excel keyboard shortcuts? Now you don't have to! There are a lot of keyword shortcuts in Excel. You can scroll through a long list of them...
-
Need a plain-vanilla calendar for your business which shows the year in a glance? Or the kind that your local hardware passes out for free (marketing) at the end of the year? Or if you're a student, how about one that lets you juggle assignments as the professors keep juggling dates? ...( read more...
-
If you’re a web developer (or even if you’re not), you’ve doubtless heard of mashups—apps or web pages that combine existing functionality from different sources to create something entirely new. It’s now possible to create cool spreadsheet-based mashups by combining features...
-
This post written by Daniel Ferry, an Excel MVP, chronicles how he and Beth Melton, a fellow MPV, designed a Gradebook template in Excel that makes teachers’ lives a whole lot easier. Several teachers, however, wanted to make the template even more useful. They asked us whether the template could...
-
If your workbook contains a ton of worksheets, it can be a hassle to navigate to just the right sheet. For one thing, you often can't see all the sheet names at the bottom of the workbook. Sure, you can move around by using the four navigation buttons to the left of the worksheet tabs, or by pressing...
-
We know you're pressed for time, and you want what you read to be worth the effort. Our question to you is this: What kind of blog post about Excel works best for you? Do great tips help you work smarter? Maybe code examples unlock your creative side? Or do guest posts from Excel MVPs hit home? Take...
-
Keyboard shortcuts....You use them every day to make your work flow smoothly, or - in some cases - to make your work flow, period. In all honesty, I use some of them so often that I have no idea where to find those functions on the ribbon! (Copy? Paste? Undo? I haven't done those with a mouse in...
-
That got us thinking - what would it have been like if Excel had been around back then? How might things have been different? Then we thought - what better moment in time to illustrate the point than the Apollo 11 mission to the moon. I mean, it literally is Rocket Science. So, we decided to create a...
-
If you're a developer, you may have been wondering..."When are they EVER going to revise the Excel Services JavaScript Object Model (JSOM) documentation for SharePoint Server 2010?" Well, I'm glad you asked! The SharePoint Server 2010 Software Development Kit (SDK) online documentation...
-
In early May, we told you about the new video series Excel Skills Builder in our post " Take the first step in growing your Excel skills ." In that post, we announced the launch of lesson 1. Well, we've finally finished the rest of the lessons, and wanted to share this great resource with...
Posted to
The Excel Team Blog
by
Excel Blog
on
Tue, Jun 28 2011
Filed under:
Filed under: Charting, Conditional Formatting, PivotTables, Data Validation, Formatting & Printing, Solver, Excel 2010, Sparklines, Slicers, Beginner, functions, Excel Web Apps, PowerPivot, macros, Excel, training, Basics, Web Apps, SmartArt, print
-
Last month, a couple of other writers and I visited the main University of Washington campus in Seattle, where we presented to a group of business students who were interested in learning more about Excel. We led them in a hands-on exercise that showed how you can work on a spreadsheet in your web browser...
-
Have you been wanting to record your own Excel macros, but you're not yet ready to dip your toes in the water? Maybe you want to modify macros other people have created, or you're not sure what a macro can do for you? If so, you may want to take this online training course on creating Excel macros...
-
We recently discovered this music video by youarentbenjamin on YouTube titled "PivotTables Make Everything Just Right." The video gives some serious love to PivotTables . Props for the creativity, and here's hoping they got an A+ for their group project! ...( read more ) Read More...
-
Have you ever wanted to subtract one date from another? Or find out how many workdays until vacation? Or maybe you need to figure out a project end date. You can do all of this and more by using date functions in Excel formulas. As long as you type a date in a format that Excel recognizes: 8/22/2011...