Group items tagged

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: While there are four types of database objects in Access, tables are arguably the most important. Even when you're using forms, queries, and reports, you're still working with tables because that's where all of your data is stored. Tables are at the heart of any database, so it's important to understand how to use them. In this lesson, you will learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with. Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example. Watch the video below to learn more about working with tables in Access. TABLE BASICS TO OPEN AN EXISTING TABLE: Open your database, and locate the Navigation pane. In the Navigation pane, locate the table you want to open. Double-click the desired table. Opening a table - www.office.com/setup The table will open and appear as a tab in the Document Tabs bar. The open table - www.office.com/setup UNDERSTANDING TABLES All tables are composed of horizontal rows and vertical columns, with small rectangles called cells in the places where rows and columns intersect. In Access, rows and columns are referred to as records and fields. A field is a way of organizing information by type. Think of the field name as a question and every cell within that field as a response to that question. In our example, the Last Name field is selected, which contains all the last names in the table. Fields and field names - www.office.com/setup A record is one unit of information. Every cell on a given row is part of that row's record. In our example, Quinton Boyd's record is selected, which contains all of the information related to him in the table. Records and record ID numbers - www.office.com/setu

While we are lucky enough to work with extremely innovative clients that are eager to embrace the latest technology, we always advise them not to adopt the latest version of software until after the kinks are worked out. For a consumer it's not a big deal to be test driving new features and experimenting with the latest version. For a business user, if there's a bit of a learning curve, buggy features or errors that make an application crash, it can be a huge detriment to productivity. That's why we take a lot of time testing out new applications and operating systems before we encourage our clients to adopt them. You may have read that Microsoft recently unveiled Office 2016. We spent some time with it and have some mixed feedback for our business users. Here's the good, bad and the ugly surrounding the Office 2016 suite: The Good: Built to make business better. Word is probably our favorite when it comes to the new suite of products. While there has been minimal change to formatting and structure - the overall design has definitely gotten a facelift. We're all about function, though and when it comes to function we see definite improvements. Word has many more templates. This allows businesses to refine their documents and be more professional without having to go online and download templates to use inside Word. There are also some pretty awesome co-authoring features that we wrote about in this blog. Attachments in Outlook reference recent documents. This is a great feature since it's available on any device that you use Office on. You can easily attach documents in e-mails in Outlook or reference them in an e-mail on your phone. This is really valuable for mobile users or users that work from more than one machine. (Which, lets face is, 90% of the workforce these days does.) OneDrive is also attempting to make its way into the life of business users by making sharing documents, collaborating on documents and authoring documents across devices a l

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: A chart is a tool you can use to communicate data graphically. Including a chart in a presentation allows your audience to see the meaning behind the numbers, which makes it easy to visualize comparisons and trends. Optional: Download our practice presentation for this lesson. Watch the video below to learn more about using charts in PowerPoint. TYPES OF CHARTS PowerPoint has several types of charts, allowing you to choose the one that best fits your data. In order to use charts effectively, you'll need to understand how different charts are used. Click the arrows in the slideshow below to learn more about the types of charts in PowerPoint. Slide 1 - www.office.com/setupPowerPoint has a variety of chart types, each with its own advantages. Click the arrows to see some of the different types of charts available in PowerPoint. Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup IDENTIFYING THE PARTS OF A CHART In addition to chart types, you'll need to understand how to read a chart. Charts contain several different elements-or parts-that can help you interpret data. Click the buttons in the interactive below to learn about the different parts of a chart. Book sales chart - www.office.com/setup LEGEND The legend identifies which data series each color on the chart represents. In this example, the legend identifies the different months in the chart. INSERTING CHARTS PowerPoint uses a spreadsheet as a placeholder for entering chart data, much like Excel. The process of entering data is fairly simple, but if you are unfamiliar with Excel you might want to review our Excel 2016 Cell Basics lesson. TO INSERT A CHART: Select the Insert tab, then click the Chart command in the Illustrations group. - www.office.com/setup A dialog box will appear. Select a category from the left pane, an

www.office.com/setup Blogs: New to Visio? This tutorial will help get you started with Visio 2016. We'll take you through starter diagrams to give you an idea of what diagrams look like. Then we'll take you through the four basic steps to creating your own diagram. START VISIO Click the Start button, type Visio, and then click the Visio icon to open the program. (If Visio is open already, clickFile > New.) LOOK AT THE STARTER DIAGRAMS Before you dig in and start making things yourself, let's show you a couple starter diagrams that Visio has made for you. That way you can get an idea of what diagrams look and feel like in the program. Click Categories. Categories link - www.office.com/setup Click Flowchart. Flowchart category thumbnail - www.office.com/setup Now pay attention to this step: single-click the Basic Flowchart thumbnail. Basic Flowchart thumbnail - www.office.com/setup Let's explain what this dialog is all about. Visio Basic Flowchart thumbnails: 1 blank template, and 3 starter diagrams - www.office.com/setup You choose the blank template when you have some experience with Visio (like after you've made a few practice diagrams). But if you don't have any experience, choose one of the other three starter diagrams. Double-click one of the starter diagram thumbnails. This is a starter diagram. Visio 2016 comes with many starter diagrams to give you ideas and examples. You can customize this starter diagram by typing your own text, adding your own shapes, and so on. Also, take a look at the tips and tricks. These help you work with the diagram. Let's open another starter diagram. Click File > New > Categories > Network. Single-click the Basic Network thumbnail. Basic Network thumbnail - www.office.com/setup Double-click one of the two starter diagram thumbnails. This is just another example of what you can do with Visio. On your own, go to File > New > Categories and explore the various starter diagrams in Visio. Not all diagrams have them, but many of the

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

www.office.com/setup Blogs: Having come around to the idea that it needed different versions of Office for different kind of users, Microsoft introduced lightweight versions of Word, Excel, Power Point and OneNote that are neither as pricey or as feature laden as the main versions included in Office. iPad users were the first to get their hands on this new take on Office. With Windows 10, the free Microsoft Office Mobile apps have arrived for some Windows users. 10 Things to Love About Windows 10 (7) - www.office.com/setup Blogs Read: Windows 10 Review - A Love Affair Here's how to get that free Microsoft Office in Windows 10, and what you need to know about it why it's possible for some to take advantage and not possible for others. HOW TO GET FREE MICROSOFT OFFICE IN WINDOWS 10: WHAT IS IT? Microsoft Office is wildly successful. Everyday millions of users all open it to get work done. Millions of documents are written in Microsoft Word. Millions of budgets and sales breakdowns are created in Microsoft Excel. Everyone has created a Microsoft PowerPoint presentation at some point in their life. Screenshot (236) - www.office.com/setup Blogs Windows and Microsoft Office are synonymous. Because the two are often used together and both made by Microsoft, many assume that one comes included with the other. That's never been true. Windows device makers often included shortcuts to trials for Microsoft Office with new PCs. Some even bundled it with their PCs, passing the cost on to buyers. Microsoft Office costs $149 if purchased outright or $6.99 a month through Microsoft's Office 365 subscription service. Office Mobile is what Microsoft collectively calls the free Microsoft Office apps that are now available. Word Mobile lets Windows 10 users view documents. Excel Mobile focuses on spreadsheets. PowerPoint Mobile lets users look at presentations. Outlook is separated into to apps, Outlook Calendar and Outlook Mail. Outlook Mail and Outlook Calendar are a

www.office.com/setup Blogs: Office 2016 isn't just about new Microsoft Word and PowerPoint layouts. The new productivity suite has a ton of amazing new tricks and features that are designed to make your work (and play) a lot easier. If you still think of Office as something you tinkered with to write terms papers back on Windows 95, well you're in for a treat. Download the new Office 2016 and you'll get access to tools that automatically separate important and unimportant emails, connect to your social media accounts to help you plan your weekend, and help you plan group trips and activities. For the business user, there are a ton of new Office features that help you better communicate, collaborate and create. I'll walk you through some of these new features and how you can use them to improve your Office 2016 experience. 1. CLUTTER Our SPAM folders are amazing. They collect emails from retailers and businesses with whom we don't want to have any contact whatsoever. But what about that uncle you just can't stand? Or that annoying coworker who constantly asks you to go to lunch? With Clutter for Outlook, your email usage signals whether or not emails should actually enter your inbox. For example: if you never, ever open your uncle's emails, Clutter will automatically send those incoming messages to a folder where they will land alongside your annoying coworker's lunch requests. You can access this folder anytime and move messages back to the normal old inbox. If you're worried you'll miss something important, don't fret. Clutter sends you a weekly digest that tells you exactly what was hidden. You can then command Clutter to never pull in that type of content again. 2. SKYPE INTEGRATION Office 2016 - www.office.com/setup Office 2016 Microsoft has made cloud document collaboration possible (years and years after Google, but I digress). Now, you and a friend can edit a Microsoft Word document simultaneously without having to save and share the document via emai

www.office.com/setup Blogs: Previews of PowerPoint2013 show that it will be easier to create and share professional presentations with a range of new and improved features. 1. NEW RANGE OF DESIGN THEMES Powerpoint 2013 start screen - www.office.com/setup Easier inclusion of videos, or pictures to give a more professional edge to presentations. Easy access to a collection of new themes available via the start screen. The ability to quickly change themes using theme variants. Alignment Guides have been added that make it easier to align text boxes, graphics and shapes with text. Merge Shapes tools -2013 includes Union, Combine, Fragment, Intersect, and Subtract tools making it easier for the user to merge two or more shapes into the shape required. 2. IMPROVEMENTS TO THE PRESENTER'S VIEW AND ORGANISATION OF THE PRESENTATION. The One click Slide Zoom allows the user to zoom in and out on diagram, or chart. The addition of a presenter's Navigation Grid, making it easier for the presenter to switch slides within a sequence using a navigation grid that the audience cannot see. The ability to easily project a presentation on a second screen using Auto-extend. 3. IMPROVED COLLABORATION WITH EASIER SHARING AND CO-AUTHORING. The Reply Comment feature. PowerPoint 2013 makes it easier to add and track comments next to the relevant section of text. Everyone working on the presentation can follow the discussion easily and act on any suggestions. Collaboration and Sharing. With Microsoft's emphasis on improved collaboration, the new default setting means that presentations are saved online to SkyDrive or SharePoint . This allows the author to send a link to the same file to everyone involved, complete with personalised viewing and editing permissions, so that everyone is working on the same version. The PowerPoint Web App Co-authoringfeature via PowerPoint Web. 2013 makes it easier for several people to work on the same presentation at the same time from the desktop or in bro

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

www.office.com/setup Blogs: Office 365 is a subscription based package that buys you time limited access to a number of Microsoft services and software packages, including the latest desktop Office suite, an online version of Office, cloud storage, and premium mobile apps.Stop Bashing Microsoft: 5 Ways In Which They're Awesome Stop Bashing Microsoft: 5 Ways In Which They're AwesomeMicrosoft doesn't always get fair treatment. When it comes down to it, they're a pretty awesome company. There's been enough Microsoft bashing, now it's time for some love.READ MORE Office 365 follows a business model known as Software as a Service (SaaS), which has commonly been used for deploying enterprise software. With subscription-based services like Spotify, Napster, or Amazon Prime, it has found its way into the consumer software market some time ago. Does Office 365 provide enough value to be worth the money? CAN YOU STILL USE IT ON YOUR DESKTOP? Yes, absolutely! Microsoft isn't moving Office entirely into the cloud just yet. While you can access Office Online via the browser and store your documents on OneDrive, Office 365 offers many other ways to access and edit your documents. The current package of Office 365 includes the Office 2013 desktop suite (Office 2011 for Mac users). In the summer or fall of this year, you will be able to upgrade to Office 2016.Don't Pay For Word! 5 Reasons You Should Use Office Online Don't Pay For Word! 5 Reasons You Should Use Office OnlineOffice Online is the free and cloud-connected version of Microsoft Office. Limitations are compensated by features, useful even to users of desktop Office. Best of all is itsREAD MORE Microsoft Office - www.office.com/setup WHAT IS INCLUDED & WHAT IS THE PRICE TAG? The exact composition of the package depends on the Office flavor you choose. Office 365 Home, Office 365 Personal, and Office 365 University include the following software: Word Excel PowerPoint OneNote (now free for everyone) Outlook Publ

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).

The #Cloud is increasingly becoming an emerging trend for the way processes are carried out at all levels of IT. The emergence of Cloud has encouraged rapid growth and scalibility. Cloud has changed the way these products are marketed. The Cloud has allowed CIO's to utilize technology to add a greater value to the businesses they are working for. This #WhitePaper helps you startegize on how to align your organizational needs to adopt the proper cloud methadologies. Vist http://fastbluenetworks.com/ and download it for free.

We could say that gaming has become all the rage recently, but that would be a lie. Gaming has been a popular source of entertainment for people old and young for decades. It has been a massive industry for quite a while and shows no sign of slowing down in its growth.

Internet privacy has become a serious issue nowadays with the massive increase in personal information online. There are increasing cases of a breach of privacy by companies and organizations as users' information is being used for commercial purposes. Aside from this, internet fraud has also become a major problem individuals face when online. Therefore, it is important in this era, where the internet has become a part of human's daily lives, that you take cognizance of the dangers of releasing your personal information online.

Are you using the new Project and wishing you could enhance its powerful capabilities with apps? Project 2013 has great extensibility potential-even across devices. The new apps for Project enhance capabilities of Microsoft Project 2013 applications, including Project Pro for Office 365, Project Professional 2013, Project Online and Project Server 2013. www.office.com/setup HOW DO I ADD AN APP TO PROJECT PRO FOR OFFICE 365 OR PROJECT PROFESSIONAL 2013? Open Project. On the Ribbon, click PROJECT, then click Apps for Office. www.office.com/setup All apps for Project associated with your account will show up. If you need to acquire new Apps from the Microsoft Office Store, click the Find more apps in the Office Store link and follow the instructions on the screen. www.office.com/setup START USING YOUR APPS The example below shows a project plan that has been synchronized to a project site in SharePoint or SharePoint Online and the highlighted app on the right SharkPro Insite shows data from your project site next to your document. www.office.com/setup Here are apps you can acquire for Project Pro for Office 365 or Project Professional 2013: Sensei Task Analyzer SharkPro SharePoint Insite™ for Project Visit the Office Store for more apps HOW DO I ADD AN APP TO PROJECT ONLINE OR PROJECT SERVER 2013? Choose the site where you want to add the app. On the Gear menu, select Add an app. www.office.com/setup The apps you see will depend on your corporate environment and on whether you have already acquired apps from the Office Store. If you don't see the apps you want in the list, you can add them. On the left side of the screen, click the SharePoint Store link to browse all available apps. Follow the on-screen instructions to add the apps you want. www.office.com/setup Once the app is added to your site, launch the app by clicking on its name in the left hand navigation or see all apps that are ready to use on your site through the Site co

WWW.OFFICE.COM/SETUP BLOGS: GO TEAM! THAT'S WHAT OFFICE 2016 IS BUILT TO ENCOURAGE, WITH NEW COLLABORATIVE TOOLS AND OTHER WAYS TO TIE WORKERS AND CONTENT TOGETHER. pcw office primary 2 - www.office.com/setup www.office.com/setup Blogs: Office 2016 is a major upgrade, but not in the way you'd first suppose. Just as Windows 10 ties notebooks, desktops, phones and tablets together, and adds a layer of intelligence, Office 2016 wants to connect you and your coworkers together, using some baked-in smarts to help you along. I tested the client-facing portion of Office 2016. Microsoft released the trial version of Office 2016 in March as a developer preview with a focus on administrative features (data loss protection, multi-factor authentication and more) that we didn't test. I've been using it since the consumer preview release in May. Microsoft seeded reviewers with a Microsoft Surface 3 with the "final code" upon it. That's a slight misnomer, as the Office 2016 apps upon it used the same version that Microsoft had tested with the public, with a few exceptions: Outlook was pre-populated with links and contacts of a virtual company to give reviewers the look and feel of Delve, Outlook's new Groups feature, and more. Office 2013 users can rest easy about one thing: Office 2016's applications are almost indistinguishable from their previous versions in look and feature set. To the basic Office apps, Microsoft has added its Sway app for light content creation, and the enterprise information aggregator, Delve. Collaboration in the cloud is the real difference with Office 2016. Office now encourages you to share documents online, in a collaborative workspace. Printing out a document and marking it up with a pen? Medieval. Even emailing copies back and forth is now tacitly discouraged. office 2016 review powerpoint demo shot - www.office.com/setupMicrosoft Microsoft says its new collaborative workflow reflects how people do things now, from study groups

Since its launch on June 1, 2023, the Unitary Patent System has aimed to simplify processes, reduce costs, and unify legal protection across participating EU countries. In its first year, over 27,500 Unitary Patents were registered, covering 80% of the EU's GDP. Germany and France led adoption, though the absence of key economies like Spain and Poland shows harmonization is still a work in progress. The system's Unified Patent Court (UPC) has quickly become a central venue for patent litigation, handling over 500 cases in diverse tech sectors. Businesses appreciate the faster resolution times and streamline legal processes, though some SMEs remain cautious due to perceived cost risks. Meanwhile, traditional litigation has declined, raising questions about local court roles in the evolving ecosystem. Cost savings are significant maintaining a Unitary Patent for 10 years costs less than €5,000 compared to nearly €29,000 under the old system. However, challenges persist, including procedural complexities and jurisdictional uncertainties. As the system matures, expanding its reach and refining its frameworks will be key to strengthening Europe's innovation landscape. To know more about this, read the complete blog here.

Today, it's hard for us to imagine a world without money, but it hasn't always been so. In fact, our ancestors managed just fine without it, by bartering their goods instead. Bartering has been the go-to method of trading for thousands of years, all the way to the 6th century BC when the first minted coins were introduced in Anatolia. Unlike today's coins, which are made out of base metals such as nickel and copper, these were made purely out of precious metals. They were finally replaced by paper money around the 17th century and that has been the favored currency ever since. Yet, seeing how we now live in a digital age, it's only logical to assume we'll switch to some form of digital currency in the near future. After all, technology has always been the driving force behind the use of currencies in the past, so why should now be any different?

In times of inflation, strategic investing takes on heightened importance. To navigate this economic landscape, one must seek avenues that not only preserve but also grow wealth. This is where platforms like BeatMarket come into play. With its suite of tools, BeatMarket enables you to adeptly monitor your investment choices, drawing comparisons against benchmarks, managing transactions, and accessing insightful analytics. What's more, your security is prioritized, as no sensitive personal information is retained. Learn more about navigating the world of investments at https://beatmarket.com/blog/how-to-calculate-dividends/. Embrace the power of informed financial decisions to steer your future confidently.

"Always wanted a touchscreen smartphone, but been put off because of your morbid and irrational fear of germs? Then Sony has come up with the phone for you - the Xperia Sola."

"Always wanted a touchscreen smartphone, but been put off because of your morbid and irrational fear of germs? Then Sony has come up with the phone for you - the Xperia Sola."

Shooting a biopic of the founders of Apple, Steve Jobs, has started on Wednesday (06/13/2012). Hollywood actor Aston Kutcher believed to play a role as Steve Jobs.