Excel 2013: Create Professional-Looking Spreadsheets, Faster

posted  Sa, 12/03/2013 - 12:45  
Ginny Mies
Written on: 
March 12, 2013

Whether you're a novice or an advanced user, you'll find many of Excel 2013's new features useful at your nonprofit, foundation, charity, or library. The changes between Excel 2010 and Excel 2013 are subtle, so your staff should have no problem transitioning into the new version. Most of Excel 2013's updates are designed to make crunching numbers and analyzing data faster and easier.

Eligible nonprofits, charities, foundations, and libraries can now request Office Standard and Professional editions through the Microsoft Software Donation Program at TechSoup. To learn more about the new Office, read TechSoup's Microsoft Office: What Your Organization Should Know.

Updated Look

Like the rest of the new Office suite, Excel 2013 has undergone a light, minimalist makeover. With less clutter, it is easier to find the menus and tools you need to get started on your projects. If you're working in a spreadsheet for a long period of time, your eyes can sometimes get fatigued from looking at endless columns of data. Excel relieves this with subtle animations that make it easier to track your cursor between cells.

When you start up Excel, you'll see a new landing page with your most recently opened projects as well as a variety of templates to choose from (you'll find similar landing pages in other programs in the new Office). If you aren't sure how to format a fundraiser budget or where to start to make a volunteer calendar, Excel's expansive library of templates can get you started on the right track.

Built to Help You Save Time

Flash Fill is a handy new feature that can help you reformat and rearrange your data. Excel will learn and remember your data entry patterns and auto-complete the remaining data with no formulas or macros required. One way Flash Fill can be of assistance is if you have to import a large chunk of data into another spreadsheet.

Flash Fill can predict your data entry — before you type it.

For example, say you need to copy and paste volunteer names into a spreadsheet from a list. You prefer to have the last name and first name in separate cells, however, so you can list the volunteers alphabetically. When you start typing the last names into a separate column, Excel will recognize this pattern and automatically fill in the rest of the data. To see Flash Fill in action, watch a replay of our webinar Take a Tour of the New Microsoft Office, which includes a demo of this feature.

Visualize Your Data

A number of new, useful tools will appeal to Excel novices and advanced users alike. The new Quick Analysis function helps you convert your data into a chart, table, or Sparklines (small graphs that you can show alongside your data. See our article on How to Use Sparklines in Excel 2010 to see examples.) To do this, you select the cells you wish to analyze and click the Quick Analysis button that appears to the bottom right. You can preview different visual formats for your data (like a pie chart, bar graph, and so on) so you can swiftly choose the best format.


Excel's Recommend Chart feature helps you pick the best format for your data.

If you already know that you want a chart to illustrate your data, you can jump to the Recommended Charts tool by selecting it from the Insert tab on the Ribbon (click Insert > Recommended Charts). You'll see different charting options that might work for your project, such as pie, line, and bar charts.

A small, but useful enhancement in Excel 2013 is chart animation. When you adjust data associated with a chart, Excel will animate the change to show how the new numbers affect the overall graphic.

The Recommended Chart feature can help you discover new ways of visually presenting your data.

Recommended PivotTable is another new feature you'll find under the Insert tab. The PivotTable feature lets you create an interactive table that automatically extracts, organizes, and summarizes your data (for more on Pivot Tables in Excel 2010, read TechSoup Canada's Data Analysis Is for Everyone! A Short Intro to Pivot Tables). When you select a group of cells, you can see a preview of how your data would look in a variety of tables using different pivots.

Sharing and Collaboration

As with the rest of the new Office suite, it is easier to share and collaborate in Excel with your colleagues. Your workbooks are saved to SkyDrive (Microsoft's cloud-based storage service) or SharePoint by default. SkyDrive will even save your place in a spreadsheet so when you come back it, you'll be in the cell you were previously working on — even if you're accessing it from a different device. You can also save workbooks to your computer if you prefer to save files locally. Want to share a particularly interesting chart or graph with your audience? Excel 2013 lets you share selected portions of your spreadsheets on your social networking pages directly from the application.

You can also show off your charts in a PowerPoint presentation. PowerPoint 2013 lets you insert Excel charts (as well as tables and graphs) into a slide without losing any of their formatting or functionality.


The new features in Excel 2013 can help anybody create professional-looking charts, spreadsheets, and tables — regardless of their skill level. If your staff is already comfortable working in earlier versions of Excel, they should have no trouble getting started. 

Microsoft Office: What Your Organization Should Know

posted  Per, 07/02/2013 - 14:23  
Written on: 
February 7, 2013

Microsoft Office 2013 is an overall improvement from previous versions, with new features and a refreshed user interface. The productivity suite has also been optimized for touchscreen devices, such as tablets and all-in-one PCs with touch monitors. Eligible nonprofits, charities and public libraries can now request donated Office software through TechSoup (for more information on how TechSoup’s Microsoft donations work, see our Overview of the Microsoft Donation Program .

There are many new features sprinkled across the software within the Office suite. While it would be nearly impossible to list all of the changes, we'll address those that are most useful to nonprofits, charities and libraries. Additional articles in this series will go into more depth about specific programs within Office.

Working with Windows 8 and SkyDrive

The latest version of Office 2013 clean and optimized-for-touchscreens design complements Windows 8. Like the Windows 8 Start screen, Office has a minimalist, flat look with bolder text and fewer buttons and icons. The redesign reduces the extra flourishes in favor of improving your ability to focus on the task—or tasks—at hand.

Office 2013 is also compatible with all versions of Windows 7, but it will not run on any versions of Windows Vista or XP. Organizations running these older versions of Windows might consider upgrading to a newer version of Windows to run the latest software. For more information on Windows 8, see TechSoup's Should You Upgrade to Windows 8?

Microsoft's cloud service, SkyDrive, is integrated throughout the Office  suite. When you install Office, you will be prompted to type in your Microsoft account information, which is linked with your SkyDrive account. You will then be able to upload files to your SkyDrive web account directly from Office. SkyDrive is now the default location for saving new files, but you can easily change that to save to whichever location you prefer: locally, to an external drive, or to a network drive. 

When you activate Office, you will be asked to link it to your Microsoft account

Working across multiple devices is much easier with Office and SkyDrive integration. After saving to SkyDrive, you can access your documents, spreadsheets, presentations, and other Office files from different PCs, or from your Windows Phone or tablet. Word, Excel, and PowerPoint will also save in the last location where you were working before you saved. For example, if you are working in a spreadsheet cell and need to close Excel to work on another project, the program will save your place in that cell. Your bookmarked place will even be synced across devices, whether you return to a file on your PC, Windows Phone, or tablet. The SkyDrive app is available for iOS and Android devices, so you can also open files across different platforms. 


In terms of appearance,  Microsoft Word 2013 is not radically different from word 2010. The text and icons are a bit larger and spaced farther apart, resulting in an easier-to-read, more modern interface. Word  also feels much faster and smoother when you're scrolling through a document and while typing. 

When you start Word, you're greeted with a new landing page that shows your most recent documents, various templates, and the option to open a blank, new document. The Ribbon, introduced in Office 2010, is still present, but you can minimize it to increase your workspace. There's also a new tab on the Ribbon, the Design tab, which incorporates formatting and page background tools as well as new themes and templates. 

Word  is much more flexible when it comes to embedding different types of media into documents. For example, you can now embed videos directly into Word documents and play them. Photos from your organization's Facebook and Flickr accounts can also be inserted into documents from Word without leaving the application. The new alignment guides (tools that pop up when you click on a piece of media) make it easy to quickly position your images or video with your text.
Alignment Guides in Word help you format images more easily
One of the most useful new additions is the ability to edit PDF files in Word. In past versions of Office, you could save a Word document as a PDF file, but you couldn't edit PDFs without converting them first. Now, you can simply open up a PDF in Word and start editing right away, without losing any of the PDF file’s formatting and structure.
Word also has a few features that can help you more easily coordinate workflow among your staff. If you need to work on a document collaboratively with a group of people, for example, you can save it on SkyDrive or SharePoint and then send everyone a link to the same file along with their viewing and editing permissions.


Like Word, Excel 2013 has undergone a light, minimalist makeover. There are a number of new useful tools that will appeal to Excel novices and advanced users alike. Recommended Charts can help you wade through the many charting options Excel provides. If you select your data and click Insert > Recommended Chart, Excel will call up different charting options that might work for your project, such as pie, line, and bar charts.

Excel's Recommend Chart feature helps you pick the best format for your data.
Fast Fill is a handy new feature that can help you reformat and rearrange your data. Excel will learn and remember your data entry patterns and auto-complete the remaining data with no formulas or macros required. For example, if you're entering volunteer phone numbers and formatting them in a certain way, Excel's Flash Fill will recognize the pattern and format them for you.
Another useful tool for novices and advanced Excel users alike is the Recommended Pivot Table feature. When you select a group of cells, you can see a preview of how your data would look in a variety of tables using different pivots.


PowerPoint also follows the "less is more" principle with fewer extraneous buttons and colors, creating more canvas space to design slides. It features new themes and templates that you can choose from, as well as color variations for certain themes. Similar to Word, PowerPoint's alignment guides can help you format shapes, text boxes, and other graphics with text to help your slides look more professional.
Alignment Guides work the same way in PowerPoint as they do in Word.  
PowerPoint's new Presenter View has a navigation grid that can help you keep your slides organized while you're showing them. It also has a new feature that lets you zoom into a slide by tapping or clicking on an area.


Of all the programs, Outlook's design update is the most drastic. But the changes are for the better: Its less cluttered interface makes it easier to find important information in your inbox or calendar. Outlook 2013 functions and looks similar to web mail programs—for example, by allowing you to reply to an e-mail within the main window. In previous versions, a separate window popped up for replies. You can opt to pop out a separate window if you wish, but this slight change makes Outlook all the more efficient. The Social Connector feature, introduced in Outlook, lets you integrate your LinkedIn and Facebook accounts into your inbox and see updates from your contacts. It can also sync your Facebook email, Twitter direct messages, and LinkedIn requests and present them in one single inbox. If you are responsible for handling social media at your organization, this feature could save you an enormous amount of time.

There's also a new feature called "Peeks," which gives you a quick glance at your calendar or appointments while you're writing an e-mail, without needing to switch windows.


Like the other programs in Office, OneNote  is designed to sync across multiple devices. Notes created in OneNote are accessible across multiple devices: Windows 7 or 8 tablets and PCs, Windows Phones, and iOS and Android devices with OneNote apps. You can also open notes in your browser via Office Web Apps. 

OneNote also adds some touch-friendly elements, such as the ability to draw and swipe within the application. You can also embed files into your notes, such as images, videos, documents. And, like the rest of Office, you can sync OneNote  with your SkyDrive account.

Office  adds many useful new features for nonprofits, charities and libraries, but the changes aren't so drastic that your staff will be required to re-learn the software. One or two brown-bag sessions to highlight the new features might be all it takes to get started with Office. 


Microsoft Discounted Programı - Başvuru Kılavuzu

Per, 12/04/2018 - 11:11 - Anonymous

Microsoft İndirim Programı - Operasyon Kılavuzu

Microsoft İndirim Programına hoş geldiniz! Bu program sivil toplum kuruluşlarının Microsoft orijinal yazılımlarına büyük bir indirimle ulaşmalarını sağlar (Open Charity pricing). Yalnızca yetkili bir Microsoft Satıcı Sertifikasına sahip kâr amacı gütmeyen kuruluşlar Microsoft ürünlerini Open Charity fiyatlandırmasından alabilir. Kataloğu buradan inceleyebilirsiniz.


I.               TechSoup Türkiye üyeliği


Kâr amacı gütmeyen bir kuruluş olduğunuzu doğrulamak için Türkiye’deki Microsoft İndirim Programını sağlayan TechSoup Türkiye’nin uygunluk kriterlerini karşılayan bir üyesi olmanız gerekir. İndirimli olarak ürünlere erişmek için faaliyetleriniz Microsoft tarafından uygun nitelikte olmalıdır. Uygunluk kriterlerini sağlayan kuruluşlar için daha fazla bilgiye buradan ulaşabilirsiniz.


TechSoup Türkiye üyesi değil misiniz? Şimdi kaydolun!


II. Microsoft Kâr Amacı Gütmeyen Portal üyeliği


Talep etmek istediğiniz Microsoft yazılım indirimlerine erişebilmeniz için Microsoft Nonprofit Portal’a kayıt olmanız gerekir. Ardından TechSoup Türkiye’ye kuruluşunuzun indirim programı için uygunluk kriterlerini sağladığına dair sertifikayı Microsoft Nonprofit Portal aracılığıyla iletebilirsiniz.


Lütfen TechSoup Türkiye sertifikanızı teslim almadan önce talebinizin işleme konulamayacağını unutmayın. Bu sertifika bir yıl süresince geçerlidir.


Zaten Microsoft Nonprofit Portal’a üye misiniz? İkinci adımı atlayabilirsiniz.


III.               Detaylı Açıklamalar

Adım Bir : Microsoft Nonprofit Portal’a kayıt olun.


  1. Microsoft Nonprofit Portal’a gidin ve Get Started’a tıklayın. (Eğer mobil görünümdeyseniz, Get Started mobil menüsündedir.)

  2. Kayıt olmak için ilgili adımları takip edin.


Tarafınıza 10 iş günü içinde uygunluk değerlendirmeleriniz hakkında bir e-posta gönderilecektir.


Adım  İki: Uygunluk Sertifikanızı TechSoup Türkiye’ye gönderin.


1. Uygunluğunuz doğrulandıktan sonra,Microsoft Nonprofit Portal’a dönün ve sayfanın üst tarafındaki

Login ‘i (Sign In değil) tıklayın. (Eğer mobil görünümdeyseniz, Login mobil menüsündedir.)

Bir onay anahtarı sağlamanız talep edilebilir.

2. Giriş yaptıktan sonra, Microsoft'tan gelen kar amacı gütmeyen tekliflerin bir listesini göreceksiniz.

Sayfanın altında, "Şirket içi yazılım lisansları hakkında daha fazla bilgi edinmek için burayı tıklayın" yazan bağlantıyı tıklayın.


3. Software Discount başlığının altındaki “Send to partner”a tıklatın.


4. Aşağıdaki bilgileri ve e-posta adresinizi girin ve tamamlandığında “Send to partner” (ortağa gönder)'i tıklayın.


o        Company name: TechSoup

o        Contact name: TechSoup

o        Contact email address: []


Bir onay sayfası görünür.


TechSoup Türkiye'nin sertifikanızı işleme koyması 5 ila 10 iş günü sürebilir.

Ondan sonra, talep edilen teklifleri alma talimatlarını içeren TechSoup Türkiye'den bir e-posta alacaksınız.


Hala sorularınız mı var?


SSS’yi inceleyin.

Bize ulaşın.


tags:  Microsoft
İçeriği dağıtıma sok