Skip to main content

Home/ Web Design CSS Bookmarking List Summer 2008/ Group items tagged In

Rss Feed Group items tagged

Akmal Yousuf

3 things you need to know about Microsoft Office 2016 - Office Setup Help - 0 views

  •  
    www.office.com/setup Blogs: Microsoft Office www.office.com/setup Blogs: Windows 10 has grabbed the attention of social media and customers alike more so because it is a crucial operating system for Microsoft after the debacle of Windows 8 and a not so great reception for Windows 8.1. But, Microsoft has another major product on their cards now, Office, which enhances the Windows productivity of five major products into a system of applications. With Office 2016, Microsoft plans to build from scratch, a mobile and cloud first approach which is customer centric and doesn't only focus on web compared to Office 365 and 2013. Office 2016 has recently been launched on September 22, 2015. www.office.com/setup The Cost factor The first and the most important thing we look at during major software products and updates is the price tag that comes along with it as there are so multiple updates for major software and it is not feasible to go through each and every revision. The all new Office 2016 suite is free for customers on mobile and tablets (conditions apply) and pretty cheap at $145 for "Office Home & Student 2016" and the RRP version of the same is priced at $165, along with subscription version of the suite (Office 365 Personal) at about $70 per year. Built for collaboration Office suite has changed how businesses operate and more focus is laid on connectivity and collaboration of projects. So, the latest offering from Microsoft, Office 2016 is emphasized on collaborations among spread out team members who may never work in the same office environment, but easily enhance productivity by accomplishing a major task that took a week to get it done. Touch centric user interface If you have used the Office for Windows 10, it is quite evident that Microsoft has given a universal app style for the apps and a touch friendly UI which is more familiar to the iPad owners. For instance, in Word, Microsoft lays focus on providing touch friendly controls for ease of
Akmal Yousuf

17 Tricks to Master Microsoft PowerPoint - www.office.com/setup - 0 views

  •  
    WWW.OFFICE.COM/SETUP BLOGS: START THE SHOW INSTANTLY We've all seen too much of presenter's laptop screens, full of messy icon-strewn desktops or unread emails, as they try to start a PowerPoint presentation. Get right to it by naming the file with a .PPS (or .PPSX) file extension. That's a PowerPoint Show, and a quick double click on it goes right into the slideshow, not PowerPoint editing mode. Click Esc to exit the slideshow. www.office.com/setup Blogs: There comes a time in almost every young (or old) office worker's life where the cubicle must give way to the boardroom, or worse, to the dais. That means speaking in public, and more often than not, that speaking is usually accompanied by slides. Such presentations are ingrained in the public consciousness, from watching big-name CEOs spew speeds-and-feeds about new gadgets, to fascinating TED talks on every topic under the sun. Even teachers in the classroom give lessons in a way the old blackboard could never convey. It's fair to say that the vast majority of those presentations are created using PowerPoint, the presentation tool that's a staple of the Microsoft Office suite. The site SlideNirvana.com estimates that PowerPoint is on at least 1 billion (with a B!) computers worldwide. If even a third of them use the software, that's still the equivalent of the entire population of the United States making slide-based exhibitions. And most of them suck. Perhaps that's not quantifiable, but so many articles are written on that fact-and so many of us live through them-it's hard to argue the (power)point. Likewise, many, many articles and entire books are written on how to make effective presentations. This is not one of those stories. This collection of tips is all about the vagaries of the powerful PowerPoint software itself. It's meant for those with a grasp of the basics and beyond who are looking for that extra little goose to get the most out of the program. We hope with these tricks-some of which wi
Akmal Yousuf

Microsoft Office 365 Setup Guide - www.office.com/setup - 0 views

  •  
    www.office.com/setup Blogs: In today's post we take a look at the key admin setup steps of a Office 365 license. If you'd like the complete guide to Office 365 setup, you can download it here. This guide will walk you through the necessary steps to establish your Office 365 account, add your end users, and jumpstart collaboration. In today's post, we'll be discussing the setup process for you and your employee's Office 365 accounts from start to finish. What to Expect During The Setup Process Office 365 The process begins with the purchase of Office 365 licenses for all of your employees. There are different plans available, with options that include the full Microsoft Office downloadable suite of tools, and those that only provide the online, or web-based versions of the Office suite. There are plans available for an individual, small business, and for the enterprise. Each license type includes options for online and offline apps, email, and productivity solutions. Purchasing a New Office 365 Plan Once your plan is selected, you as the Administrator will walk through the purchasing process, allowing you to associate your new plan with any existing subscriptions, as well as associate your account to your personal Microsoft ID. If you've ever attended a Microsoft event or webinar, or purchased software from the Microsoft store, you probably already have a personal Microsoft ID. You can connect this to your new Office 365 account, or create a new Microsoft ID. The signup process has four simple steps: Provide your contact details Create a new ID (or associate your account with an existing ID) Review your order Place your order Once purchased, you will receive a welcome letter as the new Office 365 Administrator with details on signing onto the platform and getting started. If the license was purchased on your behalf, your profile will be added to the company account, and you will likewise receive a welcome email with your User ID and a temporary passw
Akmal Yousuf

Microsoft Office 365 Setup Guide - www.office.com/setup - 0 views

  •  
    www.office.com/setup Blogs: In today's post we take a look at the key admin setup steps of a Office 365 license. If you'd like the complete guide to Office 365 setup, you can download it here. This guide will walk you through the necessary steps to establish your Office 365 account, add your end users, and jumpstart collaboration. In today's post, we'll be discussing the setup process for you and your employee's Office 365 accounts from start to finish. What to Expect During The Setup Process Office 365 The process begins with the purchase of Office 365 licenses for all of your employees. There are different plans available, with options that include the full Microsoft Office downloadable suite of tools, and those that only provide the online, or web-based versions of the Office suite. There are plans available for an individual, small business, and for the enterprise. Each license type includes options for online and offline apps, email, and productivity solutions. Purchasing a New Office 365 Plan Once your plan is selected, you as the Administrator will walk through the purchasing process, allowing you to associate your new plan with any existing subscriptions, as well as associate your account to your personal Microsoft ID. If you've ever attended a Microsoft event or webinar, or purchased software from the Microsoft store, you probably already have a personal Microsoft ID. You can connect this to your new Office 365 account, or create a new Microsoft ID. The signup process has four simple steps: Provide your contact details Create a new ID (or associate your account with an existing ID) Review your order Place your order Once purchased, you will receive a welcome letter as the new Office 365 Administrator with details on signing onto the platform and getting started. If the license was purchased on your behalf, your profile will be added to the company account, and you will likewise receive a welcome email with your User ID and a temporary passw
Akmal Yousuf

PowerPoint 2016: Applying Themes - www.office.com/setup - 0 views

  •  
    WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: A theme is a predefined combination of colors, fonts, and effects. Different themes also use different slide layouts. You've already been using a theme, even if you didn't know it: the default Office theme. You can choose from a variety of new themes at any time, giving your entire presentation a consistent, professional look. Optional: Download our practice presentation. Watch the video below to learn more about applying themes in PowerPoint. WHAT IS A THEME? In PowerPoint, themes give you a quick and easy way to change the design of your presentation. They control your primary color palette, basic fonts, slide layout, and other important elements. All of the elements of a theme will work well together, which means you won't have to spend as much time formatting your presentation. Each theme uses its own set of slide layouts. These layouts control the way your content is arranged, so the effect can be dramatic. In the examples below, you can see that the placeholders, fonts, and colors are different. The Frame theme and the Integral theme - www.office.com/setup If you use a unique slide layout-such as Quote with Caption or Name Card-and then switch to a theme that does not include that layout, it may give unexpected results. Every PowerPoint theme-including the default Office theme-has its own theme elements. These elements are: Theme Colors: There are 10 theme colors, along with darker and lighter variations, available from every Color menu. Theme Colors - www.office.com/setup Theme Fonts: There are two theme fonts available at the top of the Font menu under Theme Fonts. Theme Fonts - www.office.com/setup Theme Effects: These affect the preset shape styles. You can find shape styles on the Format tab whenever you select a shape or SmartArt graphic. Theme Effects - www.office.com/setup When you switch to a different theme, all of these elements will update to reflect the new them
Akmal Yousuf

PowerPoint 2016: Applying Themes - www.office.com/setup - 0 views

  •  
    WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: A theme is a predefined combination of colors, fonts, and effects. Different themes also use different slide layouts. You've already been using a theme, even if you didn't know it: the default Office theme. You can choose from a variety of new themes at any time, giving your entire presentation a consistent, professional look. Optional: Download our practice presentation. Watch the video below to learn more about applying themes in PowerPoint. WHAT IS A THEME? In PowerPoint, themes give you a quick and easy way to change the design of your presentation. They control your primary color palette, basic fonts, slide layout, and other important elements. All of the elements of a theme will work well together, which means you won't have to spend as much time formatting your presentation. Each theme uses its own set of slide layouts. These layouts control the way your content is arranged, so the effect can be dramatic. In the examples below, you can see that the placeholders, fonts, and colors are different. The Frame theme and the Integral theme - www.office.com/setup If you use a unique slide layout-such as Quote with Caption or Name Card-and then switch to a theme that does not include that layout, it may give unexpected results. Every PowerPoint theme-including the default Office theme-has its own theme elements. These elements are: Theme Colors: There are 10 theme colors, along with darker and lighter variations, available from every Color menu. Theme Colors - www.office.com/setup Theme Fonts: There are two theme fonts available at the top of the Font menu under Theme Fonts. Theme Fonts - www.office.com/setup Theme Effects: These affect the preset shape styles. You can find shape styles on the Format tab whenever you select a shape or SmartArt graphic. Theme Effects - www.office.com/setup When you switch to a different theme, all of these elements will update to reflect the new them
Akmal Yousuf

FHI 360 standardizes on Microsoft Office 365 to better support globally dispersed emplo... - 0 views

  •  
    When FHI 360 wanted to move to cloud-based business productivity services, the organization decided to implement a Microsoft cloud-based solution. We recently spoke to Douglas Wilkins, Director of IT Infrastructure at FHI 360, to learn how the company is benefiting: FHI360 logoQ: Please tell us about FHI 360. Douglas Wilkins: FHI 360 is a nonprofit human development organization dedicated to improving lives in lasting ways by advancing integrated, locally driven solutions. Our staff includes experts in health, education, nutrition, environment, economic development, civil society, gender equality, youth, research, technology, communication, and social marketing-creating a unique mix of capabilities to address today's interrelated development challenges. FHI 360 serves more than 60 countries and all US states and territories. Q: Why did you want to move to cloud-based services for messaging and collaboration? Wilkins: We had a diverse IT infrastructure. Employees in the US had different IT toolsets and Internet access than staff in countries like Mozambique. Subscribing employees to a single, cloud-based solution was the most expedient way to ensure that everyone had the same IT tools, to work efficiently regardless of location. Migrating our communication and collaboration technologies to the cloud reduced much of the time required by our IT staff to manage divergent IT infrastructures and connectivity options found around the world. Q: What criteria did you use to select Microsoft as your vendor for cloud-based business productivity services? Wilkins: We wanted a vendor that demonstrated a real interest in our mission and goals, and that offered online business productivity tools tailored for the enterprise space. The capabilities of the Microsoft Services Consulting team, and the work of Intellinet, the partner Microsoft introduced us to, provided us with that. We migrated our 4,300 staff members around the world from diverse platforms to a Microsoft Offi
Akmal Yousuf

How to calculate percentage in Excel - formula examples - www.office.com/setup - 0 views

  •  
    In this tutorial, you will lean a quick way to calculate percentages in Excel, find the basic percentage formula and a few more formulas for calculating percentage increase, percent of total and more. Calculating percentage is useful in many areas of life, whether it is restaurant tipping, reseller commission, your income tax or interest rate. Say, you've been lucky enough to get a 25% off promotion code on a new plasma TV. Is this a good deal? And how much will you eventually have to pay? In this tutorial, we are going to explore a few techniques that will help you efficiently calculate percent in Excel and learn the basic percentage formulas that will take the guesswork out of your calculations.
Akmal Yousuf

Add Words to Dictionary in Word 2016 - www.office.com/setup - 0 views

  •  
    Does Microsoft Word 2016 regularly detect words that you commonly use as misspelled words? You can change this by adding custom words to the dictionary. OPTION 1 - ADD WHILE WRITING Type the word in your document and right-click on it and select "Add to Dictionary". Add to Word dictionary - www.office.com/setup OPTION 2 - ADD FROM SETTINGS Expand the Office Quick Access Toolbar and select "More Commands…". Word 2016 More Comments option - www.office.com/setup Select "Proofing" in the left pane, then click the "Custom Dictionaries…" button. Word 2016 Custome Dictionaries button - www.office.com/setup Here you can add or remove dictionaries. Usually you just need to use one dictionary. To add a word to the dictionary, select "Edit Word List…" . Word 2016 Edit Word List button - www.office.com/setup Type the word you wish to add to the dictionary and click "Add". Word 2016 Add word to dictionary - www.office.com/setup Select "OK" then "OK" again when you are done adding words.Now your word will not be detected by Word as a misspelling. Note: This option is also available in other Office applications such as Outlook, Excel, Publisher, etc. FAQ Why is my "Add to Dictionary" option grayed out? This seems like a bug in the software. Try going to File > Options > Proofing > Customer Dictionaries. Then select the "Dictionary language". Then remove the checkbox next to the dictionary item, then check it again. These steps seem to toggle something in the software that makes the "Add to Dictionary" option available again.
Akmal Yousuf

Use cross-site publishing to set up a product-centric website in SharePoint Server 2013... - 0 views

  •  
    Bella Engen is a Technical Writer on the SharePoint User Content Publishing team, focused on search-driven experiences. Cross-site publishing is a new publishing method in SharePoint Server 2013 that can help streamline the publishing process in your organization, and at the same time reduce costs associated with maintaining and updating your website. By combining cross-site publishing with SharePoint search features, you can reduce the number of pages needed to maintain your website, and gain flexibility in how content is presented to your customers. In a nutshell, cross-site publishing simplifies the authoring experience by separating the process of how content is authored from the process of how content is displayed. SharePoint search features enable you to add user-specific behavior to your website, such as displaying different content to different customer groups, or displaying recommendations based on user behavior. In a blog series on the SharePoint IT Pro blog, you can learn how you can use SharePoint Server 2013 to set up a website that is based on product catalog data. The blog posts describe the different functionalities that are involved when setting up such a site, and show you step-by-step how the features are configured. To demonstrate how it all comes together, data from a fictitious company is used. The blog posts use several screenshots and diagrams to explain everything from how the cross-site publishing feature works, to how you can use search features to influence how product data is displayed to visitors on a site. To give you an idea of what type of site this blog series describes, here are a few screenshots of the final website:
Akmal Yousuf

Create Hyperlink Field In Access - www.office.com/setup - 0 views

  •  
    Sometimes there is frantic need to create links in database table to web pages, files, folders, images, etc. Access 2010 provides a convenient way to link up data field values with anything to complement the database in much better way. In this post we will guide you on creating a table field having Hyperlink data type. To start off with, launch Access 2010 and navigate to Create tab and click Table. createtable1 Create Hyperlink Field In Access 2010 - www.office.com/setup It will create a new table namely Table1. Right-click newly created table and select Design View to add fields with specific Data types. table11 Create Hyperlink Field In Access 2010 - www.office.com/setup Enter an appropriate table name and start adding fields. We will be entering some generic table fields with their data types such as, ID, Name, Phone Number, Email and other Links.
Akmal Yousuf

The Best Free Add-ins for Microsoft Office - www.office.com/setup - 0 views

  •  
    Ever wish Word had an encyclopedia you could tap, or Excel could generate some dummy numbers? Office add-ins provide this kind of added functionality to Word, Excel, PowerPoint, and other Microsoft Office apps. Here are some of the handiest add-ins you can install for Office 2013 and above to get more out of your office suite. We previously highlighted Office add-ins and apps for Office 2013 and earlier, but since then Microsoft has renamed "Office Apps" to "Office Add-ins". Now there are more than a handful of these plugins you can install to enhance Microsoft Office, whether you're using Office 2013 or 2016, Office Online, or Office on the iPad.
Akmal Yousuf

50 Best Microsoft Word Add-ins: Take Documents from Awful to Awesome - www.office.com/s... - 0 views

  •  
    Believe it or not, proficiency in Microsoft Word ranks among the top 20 skills required for positions that have the highest growth and wage potential between now and 20201. This finding is part of an extensive IDC study, which also found that core skills such as communication and presentation will be in high demand among employers regardless of industry. That said, being just so-so at Microsoft Word won't boost your chances at landing a high-paying job or at getting promoted. To become more productive, more efficient, or more creative at using Microsoft Word, you can check out and unleash dozens of add-ins that are designed to augment Word's already powerful features. So here's a list which includes more than 50 of the best Microsoft Word add-ins to get you started.
Akmal Yousuf

Mid-Market Matters - Read www.office.com/setup Blogs - 0 views

  •  
    Right around the same time as we moved into our new digs on Market Street, we launched Yammer's civic engagement initiative called Mid-Market Matters, which focuses our community efforts on issues affecting our new neighborhood. Through this initiative we encourage Yammer employees to get out of the office (as beautiful as it is) and interact with our neighbors - whether that means grabbing a coffee at MaVelous, taking dance classes at LINES Dance Center, or volunteering at a local non-profit. Up until the 1950s the Mid-Market neighborhood was a thriving theater district. www.office.com/setup (UPFROMTHEDEEP.COM POSTCARD, CIRCA 1957) www.office.com/setup (SOURCE: SAN FRANCISCO HISTORY CENTER, SF PUBLICLIBRARY) However, after years of neglect and the unfortunate consequences of various policy decisions, we were left with many empty storefronts and a haven for illicit activity. www.office.com/setup (SOURCE: UPFROMTHEDEEP.COM) After numerous attempts at revitalization, it seems we finally have a fighting chance to make some lasting improvements to the area. Thanks to the public-private partnerships formed and the intense focus by all parties involved, we hope to make a difference in the lives of Mid-Market residents and businesses. . This time around everyone is at the table (transit, the arts, non-profits, the Mayor's office, and the business community). We all want to bring Market Street back to its former glory! Since January we've been busy! So far we've sent 70 employees to St Anthony's Foundation to serve meals and sort clothes: www.office.com/setup We've donated 50 monitors to the Tenderloin Tech Lab. www.office.com/setup 15 employees volunteered at the Tenderloin Community School to help teachers with classroom activities www.office.com/setup And we've sent a few folks out to keep the streets safe while kids get to their afterschool programs. www.office.com/setup This Friday April 12th, Yammer is giving back in a big way. Al
Akmal Yousuf

Does Microsoft have FREE training for the NEW Office 365? - www.office.com/setup - 0 views

  •  
    www.office.com/setup Blogs: YES. Microsoft has some FREE help with the NEW Office 365. One of the places that I send people to first is the Ignite Online training center. How to configure federated identity sign-in model for Office 365 OFFICE 365 GUIDES Exploring the Office 365 Administration Center - In this guide, you will become familiar with the Office 365 Administration Center and learn how to perform key administration tasks. Office 365 Overview for IT Administrators - See how the new Office 365 Administration Center provides improved ease-of-management for IT professionals. There is also a great three part series on how to setup Identity Management. 1. Installing and Configuring Active Directory Federation Services - Learn how to prepare for and install AD FS, which is a preliminary step for the Office 365 federation and hybrid scenarios. 2. Configuring Active Directory Federation Services and Verifying Federation - In this guide, you will learn how to add and verify federated domains in Office 365. 3. Installing and Configuring Active Directory Synchronization - Learn how to install and configure Active Directory Synchronization in Office 365, which is a preliminary step for the Office 365 federation and hybrid scenarios.
Akmal Yousuf

Signing up for the NEW Office 365 - www.office.com/setup - 0 views

  •  
    www.office.com/setup Blogs: Signing up for the Office 365 is a really straight forward process. You can buy licenses and start the tenant creation, or you can start a trial (30 days) and then add licenses with in that 30 days. Scroll down below where I will walk you through the Office 365 tenant creation. IMPORTANT INFORMATION Microsoft has two main service lines for Office 365 and three main pricing options (SKUs) within each service line; Office 365 Business and Office 365 Enterprise. For an interactive workbook to compare all the features of all the plans, use the following link; Office 365 Service Comparison. FAQ What are the major differences between Office 365 Business and Office 365 Enterprise? Short answer is that it's all about the features you get and size of your business. Office 365 Business has a cap of 300 licenses, so if you are over that the go right to Enterprise. With the Enterprise SKUs, you get more features, but you have to pay a bit more. Take note that with the Business plans, there are limitations not seen in the Enterprise plans. Those limitations include: Microsoft support, Exchange hybrid, Active Directory Connect, SharePoint Online features, Exchange Online features, Microsoft FAST Track support/migrations and Office features. Make sure to do the research and buy the right plan for your business. Can I switch between Office 365 Plans? YES, you can upgrade/downgrade and switch between Office 365 Business and Enterprise plans. Can I mix Office 365 Plans? YES, you can have one tenant with some Office 365 Business licenses and some Office 365 Enterprise licenses. Keep in mind the 300 license cap for the Business licenses. IMPORTANT DECISIONS The decisions here will be needed for the next section, where you will be opening your trial tenant. There are two important pieces of information that need to be taken seriously and cannot be changed once the tenant is created. It's impossible for you and/or Microsoft to change this information
Akmal Yousuf

What Is the Definition of Microsoft Office? - Office Setup Help - 0 views

  •  
    www.office.com Blogs: Microsoft Office is an integrated suite of business software applications for Windows and Macintosh computers. Office includes word processing, spreadsheet, presentation graphics and email communication programs that provide functionality which is commonly used to run a business office. Office 2010 for Microsoft Windows and Office 2008 for the Macintosh computer are the versions available as of July 2010. ... - www.office.com/setup Blogs Microsoft Office is a suite of software. WORD PROCESSING Microsoft Office includes Microsoft Word for word processing functionality. The program uses a menu interface to provide many advanced word processing features that can be used easily by business and home users. Word includes templates to design documents used routinely in office environments such as sales letters, mailing label formats and invoices. Word documents can contain graphics, sound and video to create multimedia reports. SPREADSHEETS Microsoft Office includes Microsoft Excel to create spreadsheet solutions for home and business use. A spreadsheet is an electronic grid of rows and columns that can be used to enter, organize and calculate data. Separate spreadsheets can be linked to consolidate data across categories such as time, function, or geographic region. Templates for income statements, balance sheets and expense reports are featured within the program. Excel spreadsheets allow you to analyze and report on large amounts of data quickly and easily. PRESENTATION GRAPHICS The Microsoft Powerpoint application is used to create and deliver presentations that can include text, graphics, sound and video. Powerpoint presentations can be delivered in a slide show format using a computer and projection screen, emailed to other users for review or delivered remotely over the Internet. EMAIL COMMUNICATIONS Microsoft Outlook Express is used to create, send and receive e-mail communications. The program automates the linking and embedding of sp
Akmal Yousuf

The OneNote REST API now supports application-level permissions - Office Setup Help - 0 views

  •  
    www.office.com/setup Blogs: The OneNote API team is pleased to announce that we have enabled application-level permissions support for the OneNote API. Until now, OneNote API calls could only be made with user-delegated permissions. This meant that your application would be restricted to scenarios that required a user to be signed in. With application-level permissions support, your application now supports scenarios that do not require a user to be signed in! Read the MSDN article for details of the OneNote API application-level permissions support. With the availability of OneNote API application-level permissions support, many new scenarios that weren't possible earlier are now enabled. Some example scenarios include: Analytics (based on OneNote metadata and content exposed by the OneNote API). Dashboards (based on OneNote metadata and content exposed by the OneNote API). Background provisioning of OneNote content. Background update of OneNote content. During the development process of building the new application-level permissions support for OneNote API, our Product Management and Engineering teams worked closely with third-party partners to ensure that relevant and key education scenarios were implemented. We also ensured that our API would work well with new and upcoming third-party solutions. One of these education companies we worked closely with during the API development was Hapara. "The Hapara Dashboard provides educators with a bird's-eye view into student work across the Office 365 platform. With Dashboard, educators view and access student work from OneDrive and OneNote Class Notebooks from a central hub, making it easier to engage with students and their work across the Office 365 platform. Hapara relies on the new OneNote API to help co-teachers, counselors, coaches and school administrators gain appropriate access to student work in any classroom, something that previously required manual sharing and significant administrative effort by th
Akmal Yousuf

Summing data across multiple criteria on multiple worksheets - www.office.com/setup - 0 views

  •  
    Liam Bastick has provided financial modelling services and training to clients for more than two decades. A senior accountant and professional mathematician, he has worked in numerous countries with many internationally recognized clients, providing and reviewing strategic and operational models for various key business assignments. You can check out Liam's previous articles at www.sumproduct.com/thought, where you can also subscribe to the monthly tips and tricks newsletter. Ever had to sum data based on multiple criteria situated in different Microsoft Excel worksheets? This article provides a quick tour of INDIRECT references and Table functionality while combining qualities of the SUMPRODUCT function with the SUMIFS function, providing a solution to the mother-of-all Multiple Criteria problems. The functionality is best explained by walking through an example: Ivana: Car Sales has four divisions, cunningly called North, South, East and West. Each quarter, the four divisions are required to submit sales reports detailing the month of sale, the sales person, the car color and the price the car was sold for. www.office.com/setup The question is: how can you determine how many red cars Charlie sold in February in total across all four divisions? The answer would be fairly straightforward if the data were all on one worksheet. For a single criterion, SUMIF would cope admirably well, while for several criteria, SUMPRODUCT could be used to generate the answer (for further information see my blog posts on the SUMPRODUCT function and approaches to addressing multiple criteria in one worksheet).
Akmal Yousuf

7 things Microsoft OneNote does that Evernote can't - www.office.com/setup - 0 views

  •  
    www.office.com/setup Blogs: We're moving deeper into the modern "walled garden" of digital life. Generally speaking, you choose the garden you like best - be it Apple, Google or Microsoft - and the more time and money you invest, the more painful it is to leave that ecosystem. Similarly, many people pick Evernote or Microsoft OneNote as their repository of choice for digital scraps, doodlings and scanned documents. Then they usually stick with that choice, because it's not easy to toggle between them or switch. About a year ago, I chose Evernote over OneNote, and I started amassing my own digital archive. At the time, Evernote's Mac software was far superior to OneNote's Mac app. However, Microsoft has continually upgraded OneNote for Mac and iOS, and today it's a legitimate Evernote rival; if I were facing the Mac Evernote versus Mac OneNote decision today, it would be a different situation. If you're a Windows user, the choice is even more challenging, because the OneNote 2013 Windows desktop app has valuable features that aren't available in Evernote or OneNote for Mac. To help you decide between these two notebook tools, I've come up with seven things OneNote does that Evernote can't. Of course, this is only one side of the story. For the flip side, read "6 things Evernote does that OneNote can't." 1) ONENOTE IS A DESIGN-FRIENDLY, FREEFORM CANVAS Each OneNote note is a blank canvas, every element its own movable container. If you have a stylus, you can draw anywhere within the note, and you can insert handwriting, blocks of text, images or any other element wherever you want. onenote freeform canvas - www.office.com/setup OneNote 2013 for Windows also lets you customize your notes. For example, you can change the "paper" color, add rule or grid lines, change the dimensions of notes, create new page templates or apply existing ones, and apply text styles. Other versions of OneNote, including the iPad and Mac apps, offer some but not all, of these capab
« First ‹ Previous 121 - 140 of 357 Next › Last »
Showing 20 items per page