Excel-erate your productivity with the only guide you'll need to the latest versions of Microsoft Excel Microsoft Excel offers unsurpassed functionality and accessibility for data exploration and analysis to millions of users around the world. And learning to unlock its full potential is easier than you can imagine with help from Excel All-in-One For Dummies. Follow along with Excel expert and veteran author Paul McFedries as he walks you through every feature and technique you need to know to get the most out of this powerful software. You'll learn how to design worksheets, use formulas and functions, collaborate with colleagues and review their work, create charts and graphics, manage and analyze data, and create macros. Plus, you'll discover all the capabilities Microsoft has included in the newest versions of Excel, including dark mode and accessibility features. This indispensable reference allows you to: Get a firm grasp of Excel basics with the book's step-by-step guides before moving on to more advanced topics, like data analysis Access up-to-date information on all the new versions of Excel, including the ones bundled with Microsoft 365, Office 2021, and the LTSC/Enterprise Edition Enjoy the convenience of a single, comprehensive resource detailing everything you need to know about Excel Perfect for people coming to Excel for the very first time, Excel All-in-One For Dummies, Office 2021 Edition is also a must-read resource for anyone looking for a refresher on foundational or advanced Excel techniques.

The fast and easy way to get things done with Office Perplexed by PowerPoint? Looking to excel at Excel? From Access to Word and every application in between this all-encompassing guide provides plain-English guidance on mastering the entire Microsoft Office suite. Through easy-to-follow instruction, you'll quickly get up and running with Excel, Word, PowerPoint, Outlook, Access, Publisher, Charts and Graphics, OneNote, and more and make your work and home life easier, more productive, and more streamlined. Microsoft Office is the leading productivity tool in the world. From word processing to business communication to data crunching, it requires a lot of knowledge to operate it let alone master it. Luckily, Office 2016 All-in-One For Dummies is here to deliver the breadth of information you need to complete basic tasks and drill down into Office's advanced features. * Create customized documents and add graphic elements, proofing, and citations in Word * Build a worksheet, create formulas, and perform basic data analysis in Excel * Create a notebook and organize your thoughts in Notes * Manage messages, tasks, contacts, and calendars in Outlook Clocking in at over 800 pages, Office 2016 All-in-One For Dummies will be the singular Microsoft Office resource you'll turn to again and again.

Cut the cable television cord and cut your monthly bills Are you one of those people who have 500 television channels to choose from and you can never find anything to watch? Maybe it's time to cut the cable cord and take full control of what's on your television. All you need to get started with this popular money saving strategy is an Internet connection, a device to stream to, and the advice in this book. With Cord Cutting For Dummies, you go from evaluating if cord cutting is the right choice for your budget to acquiring the technology to get the programming you actually want. You'll discover the technology you need for streaming, select the service or services that fit your needs, and make the components of your setup work together--all within your budget. Cord Cutting For Dummies offers the steps to going from wired to wireless, including: Deciding if you need to upgrade your Wi-Fi equipment and service. Evaluating your current devices. Adding a smart TV to the mix. Choosing the best streaming services for you--including some free options When you're ready to untether yourself from the cable or satellite, Cord Cutting For Dummies shows you, step by step, how to break free. Pick up a copy and you'll be watching your favorite movie or TV show in no time!

Unlock the potential of Microsoft's powerful web-based collaborative platform that comes standard with Microsoft 365 Microsoft SharePoint unlocks millions of collaborative and remote working capabilities and possibilities. And using it doesn't require a degree in computer science! With SharePoint For Dummies, you'll be creating sites, working with lists, and integrating with Microsoft Teams in no time at all. This book offers fully illustrated, step-by-step instructions to adapt and customize SharePoint for your own organization. Perfect for complete SharePoint novices as well as veterans of previous versions, you'll learn to manage and work with enterprise content and use the SharePoint mobile app. This handy guide also walks you through: Creating integrated, online portals from scratch for everyone in your organization to use How to navigate the SharePoint interface like a pro, without any prior knowledge Using SharePoint alongside Microsoft Office 365's other powerful tools, like Teams Ideal for anyone who wants to--or has to--use SharePoint at work or school, SharePoint For Dummies is your irreplaceable companion to getting up-to-speed with SharePoint in a hurry!

Turn jumbles of numbers into graphics, insights, and answers with Excel With Microsoft Excel, you can, well, excel at data analysis. And Excel Data Analysis For Dummies can help, with clear and easy explanations of the mountain of features for creating, visualizing, and analyzing data. PivotTables, charts, what-if analysis, statistical functions--it's all in here, with examples and ideas for Excel users of all skill levels. This latest edition covers the most recent updates to Excel and Microsoft 365. You'll beef up your data skills and learn powerful techniques for turning numbers into knowledge. For students, researchers, and business professionals, Excel is the spreadsheet and data application of choice--and Dummies is the best choice for learning how to make those numbers sing. Learn how to use Excel's built-in data analysis features and write your own functions to explore patterns in your data Create striking charts and visualizations, and discover multiple ways to tell the stories hidden in the numbers Clean up large datasets and identify statistical operations that will answer your questions Perform financial calculations, database operations, and more--without leaving Excel Excel Data Analysis For Dummies is the go-to resource for Excel users who are looking for better ways to crunch the numbers.

Save time and become an Excel wizard with the world's leading Excel macro guide Do you love Excel and all the things you can do with it, but wish you could just work...faster? Excel macros--automated workflows that save you time and energy--might be just what you need. In Excel Macros For Dummies, you'll learn over 70 of the most productive, time-saving macros in less time than it takes to back up the files on your computer! Every chapter in the book gives you practical info and exercises you can put to work immediately, alongside step-by-step instructions and guidance on how to customize Excel to fit your every need. Inside, you'll find: Automations that take your Excel productivity to the next level, and beyond Fully updated macros compatible with the newest version of Excel included in Microsoft 365 Careful explanations of the basics as well as tips for the advanced user With something for everyone, Excel Macros For Dummies is the productivity supercharger you've been waiting for. Grab a copy today!

Learn to crunch huge amounts of data with PowerPivot and Power Query Do you have a ton of data you need to make sense of? Microsoft's Excel program can handle amazingly large data sets, but you'll need to get familiar with PowerPivot and Power Query to get started. And that's where Dummies comes in. With step-by-step instructions--accompanied by ample screenshots--Excel PowerPivot & Power Query For Dummies will teach you how to save time, simplify your processes, and enhance your data analysis and reporting. Use Power Query to discover, connect to, and import your organization's data. Then use PowerPivot to model it in Excel. You'll also learn to: Make use of databases to store large amounts of data Use custom functions to extend and enhance Power Query Add the functionality of formulas to PowerPivot and publish data to SharePoint If you're expected to wrangle, interpret, and report on large amounts of data, Excel PowerPivot & Power Query For Dummies gives you the tools you need to get up to speed quickly.

Make Excel work for you Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions--including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze, model, and visualize vast quantities of data from a variety of local and online sources. Get familiar with Worksheet design Find out how to work with charts and graphics Use Excel for data management, analysis, modeling, and visualization Make sense of macros and VBA If you're a new or inexperienced user looking to spend more time on your projects than trying to figure out how to make Excel work for you, this all-encompassing book makes it easy!

Get fast answers to your G Suite questions with this friendly resource G Suite For Dummies is the fun guide to the productivity suite that's quickly winning over professional and personal users. This book shares the steps on how to collaborate in the cloud, create documents and spreadsheets, build presentations, and connect with chat or video. Written in the easy-to-follow For Dummies style, G Suite For Dummies covers the essential components of Google's popular software, including: Google Docs for word processing Gmail for email Google Calendar for scheduling and day planning Google Sheets for spreadsheet functionality Google Drive for data storage Google Hangouts and Google Meet for videoconferencing and calling capability The book helps navigate the G Suite payment plans and subscription options as well as settings that ensure your own privacy and security while operating in the cloud. Perfect for anyone hoping to get things done with this tool, G Suite For Dummies belongs on the bookshelf of every G Suite user who needs help from time to time.

Get up and running fast with the PowerPoint 2019 PowerPoint continues to be the go-to tool for business presentations. The software helps anyone who needs to communicate clearly by creating powerful and effective slideshow presentations featuring data in the form of charts, clip art, sound, and video. You can even use it to create presentations for the Web. In PowerPoint 2019 For Dummies, expert Doug Lowe shows you how to use this popular tool to make show-stopping presentations that will get your message across -- and your audience excited. Create a slide presentation with special effects Work with master slides and templates Collaborate with other users in the cloud Add charts, clip art, sound, and video Want to learn to use PowerPoint quickly and efficiently? Look no further!

Make your 3D world a reality Some of the dramatic visual effects you've seen in top-grossing movies and heralded television series got their start in Blender. This book helps you get your own start in creating three-dimensional characters, scenes, and animations in the popular free and open-source tool. Author Jason van Gumster shares his insight as an independent animator and digital artist to help Blender newcomers turn their ideas into three-dimensional drawings. From exporting and sharing scenes to becoming a part of the Blender community, this accessible book covers it all! Create 3D characters--no experience required Build scenes with texture and real lighting features Animate your creations and share them with the world Avoid common rookie mistakes This book is the ideal starting place for newcomers to the world of 3D modeling and animation.

Turn your financial data into insightful decisions with this straightforward guide to financial modeling with Excel Interested in learning how to build practical financial models and forecasts but concerned that you don't have the math skills or technical know-how? We've got you covered! Financial decision-making has never been easier than with Financial Modeling in Excel For Dummies. Whether you work at a mom-and-pop retail store or a multinational corporation, you can learn how to build budgets, project your profits into the future, model capital depreciation, value your assets, and more. You'll learn by doing as this book walks you through practical, hands-on exercises to help you build powerful models using just a regular version of Excel, which you've probably already got on your PC. You'll also: Master the tools and strategies that help you draw insights from numbers and data you've already got Build a successful financial model from scratch, or work with and modify an existing one to your liking Create new and unexpected business strategies with the ideas and conclusions you generate with scenario analysis Don't go buying specialized software or hiring that expensive consultant when you don't need either one. If you've got this book and a working version of Microsoft Excel, you've got all the tools you need to build sophisticated and useful financial models in no time!

Amp up your collaboration skills and rock the modern workplace by harnessing the power of Microsoft 365 with this one-stop guide to the world's leading productivity platform The Microsoft 365 productivity solution for the workplace is a cloud-based service with many features for effective and secure collaboration virtually or in person. Whether you start your day with meetings in Teams, respond to Outlook emails, create documents with Office apps, or even automate your work with artificial intelligence, Microsoft 365 has you covered. But first, you must unlock the potential of this powerful solution to showcase your ability to keep up with the modern workplace and make an impact in your organization. To do that, you need Microsoft 365 For Dummies! This book walks you through the steps to get your work done anytime, anywhere, on any device, with Microsoft Teams as the central hub. Discover how to chat online in real time; conduct online meetings; co-author documents in the cloud; develop no-code applications; and even prioritize your well-being. The insights and step-by-step guidance in Microsoft 365 For Dummies will help you stay connected and engaged with your colleagues. Level up your teamwork game with the latest meeting and collaboration best practices from Microsoft Teams Stretch your use of Office apps (Word, Excel, PowerPoint, Outlook, and OneNote) by infusing artificial intelligence into your everyday tasks Save time (and look really smart) by automating your work with the Power Platform apps Take a break from work and focus on your health and well-being at home or in the office Whether you're a Microsoft 365 newbie or a superuser looking for details on what's new, Microsoft 365 For Dummies is the friendly and authoritative how-to book you need. Discover the benefits of cloud technology today!

Send emails, stay on top of your finances, and manage your everyday life with this no-experience-necessary Office 2021 handbook Microsoft Office offers huge benefits to people of all ages. The popular software suite has always made creating to-do lists, sending emails, drafting documents, and processing spreadsheets a breeze, and the updates and upgrades found in Office 2021 make those tasks even easier. Office For Seniors For Dummies offers step-by-step instructions to learn every part of Office 2021, including Word, Excel, and PowerPoint. This trusted guide starts at the very beginning, showing you how to start each application and understand the interface. It walks you through the most commonly used functions of each program and explains how to apply it in your everyday life. Written in large, crystal-clear type and full of helpful images and screenshots, the book also demonstrates how to: Stay in touch with friends and family using Office 2021's built-in communications tools, including Outlook Keep your finances up to date with functional spreadsheets in Excel Take advantage of existing Office templates for things like budgets, letters, faxes, and more You don't have to be a computer scientist to get the most out of Office 2021. Let this handy guide clarify and demystify some of the most practical and user-friendly applications available today.

Save on expensive professionals with this trusted bestseller! Running your own business is pretty cool, but when it comes to the financial side--accounts and payroll, for instance--it's not so cool! That's why millions of small business owners around the world count on QuickBooks to quickly and easily manage accounting and financial tasks and save big time on hiring expensive professionals. In a friendly, easy-to-follow style, small business guru and bestselling author Stephen L. Nelson checks off all your financial line-item asks, including how to track your profits, plan a perfect budget, simplify tax returns, manage inventory, create invoices, track costs, generate reports, and pretty much any other accounts and financial-planning task that turns up on your desk! Keep up with the latest QuickBooks changes Use QuickBooks to track profits and finances Balance your budget Back up your data safely The fully updated new edition of QuickBooks For Dummies takes the sweat (and the expense) out of cooking the books--and gives you more time to savor the results of your labors!

A bundle of Apple services, all in one place All your favorite Apple services are available in one convenient bundle, and Apple One For Dummies helps you get the full value out of your subscription. What's in this Apple barrel? Everything you need to stream music and TV, keep up with the news, play games, store files online, and even stay in shape. This book gives you a bundle of insight on how to choose the subscription level that's right for you, access and link all the services across your Apple and non-Apple devices, and use all the fun features of each service. This book takes you inside Apple Music, Apple TV+, Apple News+, Apple Arcade, iCloud, and Apple Fitness+, showing you how to make the most of each one. Apple One For Dummies also shows you how to make changes at any time, so you get all the juice out of your subscription! Get access to 50 million songs on Apple Plus Discover how the all-new Apple Fitness+ can transform your workout routine Use iCloud to store your photos and videos Understand Apple One's subscription options and get the biggest bang for your buck For Dummies welcomes you to the Apple One-stop-shop that will make your digital life that much simpler.

Become a stats superstar by using Excel to reveal the powerful secrets of statistics.

Microsoft Excel offers numerous possibilities for statistical analysis―and you don’t have to be a math wizard to unlock them. In Statistical Analysis with Excel For Dummies, fully updated for the 2021 version of Excel, you’ll hit the ground running with straightforward techniques and practical guidance to unlock the power of statistics in Excel.

Bypass unnecessary jargon and skip right to mastering formulas, functions, charts, probabilities, distributions, and correlations. Written for professionals and students without a background in statistics or math, you’ll learn to create, interpret, and translate statistics―and have fun doing it!

In this book you’ll find out how to:

• Understand, describe, and summarize any kind of data, from sports stats to sales figures
• Confidently draw conclusions from your analyses, make accurate predictions, and calculate correlations
• Model the probabilities of future outcomes based on past data
• Perform statistical analysis on any platform: Windows, Mac, or iPad
• Access additional resources and practice templates through Dummies.com

For anyone who’s ever wanted to unleash the full potential of statistical analysis in Excel―and impress your colleagues or classmates along the way―Statistical Analysis with Excel For Dummies walks you through the foundational concepts of analyzing statistics and the step-by-step methods you use to apply them.

The first step in making your ideas a reality SketchUp offers a vast array of tools that help you get your building, woodworking, and design plans out of your head and into a real model. Even if you've never dabbled in the software, SketchUp All-in-One For Dummies makes it easy to get started as quickly as the ideas pop into your head! Providing real-world insight from top SketchUp insiders, these six-books-in-one teach you how to tackle the basics of the program and apply those skills to real-world projects. You'll discover the basics of modeling as they apply to either free or paid versions of SketchUp before diving into creating models to use for making objects, constructing buildings, or redesigning interiors. Navigate the SketchUp product mix Get familiar with the basics of modeling View and share your models Make your architecture, interior design, and woodworking dreams a reality You have tons of great ideas--and now you can harness this powerful software to bring them to life.

Say hello to Office productivity with this one-stop reference With Office 2021 All-in-One For Dummies, you can get up and running with Microsoft's legendary software suite. This update covers all the tweaks you can find in the latest version of Word, Excel, PowerPoint, Outlook, and Teams. You'll also learn how to make these apps work harder for you, because we dig deep into the tips and features that casual Office users might not know about. This edition also offers expanded coverage of Teams and other collaborative tools, so you can nail working from home, or just get a few of those meetings out of the way without having to leave your desk. How can you quickly give documents the same format in Word? What was that one useful Excel function, again? And how does setting up a meeting on Teams work? Office 2021 All-in-One For Dummies serves up quick and simple answers to these questions, along with hundreds of other answers you're expected to know when you work in Office. Learn how Microsoft Office works and get the most out of Word, Excel, PowerPoint, Outlook, and Teams Make amazing charts and graphs that you can plug into your documents, spreadsheets, and presentations Get better at working collaboratively with file sharing options and other neat features Do more, faster with expert tips and guidance on the full suite of Office software for 2021 Whether you're new to Office or just need a refresher for the newest updates, the nine mini-books inside are your keys to getting stuff done.

Get ahead of the curve--learn about big data on the blockchain Blockchain came to prominence as the disruptive technology that made cryptocurrencies work. Now, data pros are using blockchain technology for faster real-time analysis, better data security, and more accurate predictions. Blockchain Data Analytics For Dummies is your quick-start guide to harnessing the potential of blockchain. Inside this book, technologists, executives, and data managers will find information and inspiration to adopt blockchain as a big data tool. Blockchain expert Michael G. Solomon shares his insight on what the blockchain is and how this new tech is poised to disrupt data. Set your organization on the cutting edge of analytics, before your competitors get there! Learn how blockchain technologies work and how they can integrate with big data Discover the power and potential of blockchain analytics Establish data models and quickly mine for insights and results Create data visualizations from blockchain analysis Discover how blockchains are disrupting the data world with this exciting title in the trusted For Dummies line!

Now updated and revised to cover the latest features of Microsoft Office 2019 The world's leading suite of business productivity software, Microsoft Office helps users complete common business tasks, including word processing, email, presentations, data management and analysis, and much more. Whether you need accessible instruction on Word, Excel, PowerPoint, Outlook, or Access--or all of the above--this handy reference makes it easier. In Office X For Dummies, you'll get help with typing and formatting text in Word, creating and navigating an Excel spreadsheet, creating a powerful PowerPoint presentation, adding color, pictures, and sound to a presentation, configuring email with Outlook, designing an Access database, and more. Information is presented in the straightforward but fun language that has defined the Dummies series for more than twenty years. Get insight into common tasks and advanced tools Find full coverage of each application in the suite Benefit from updated information based on the newest software release Make your work life easier and more efficiently If you need to make sense of Office X and don't have time to waste, this is the trusted reference you'll want to keep close at hand!

The fun and friendly guide to mastering IBM's Statistical Package for the Social Sciences Written by an author team with a combined 55 years of experience using SPSS, this updated guide takes the guesswork out of the subject and helps you get the most out of using the leader in predictive analysis. Covering the latest release and updates to SPSS 27.0, and including more than 150 pages of basic statistical theory, it helps you understand the mechanics behind the calculations, perform predictive analysis, produce informative graphs, and more. You'll even dabble in programming as you expand SPSS functionality to suit your specific needs. Master the fundamental mechanics of SPSS Learn how to get data into and out of the program Graph and analyze your data more accurately and efficiently Program SPSS with Command Syntax Get ready to start handling data like a pro--with step-by-step instruction and expert advice!

Create awesome iOS and Android apps with a single tool! Flutter is an app developer's dream come true. With Google's open source toolkit, you can easily build beautiful apps that work across platforms using a single codebase. This flexibility allows you to get your work out to the widest possible audience. With Flutter already being used by thousands of developers worldwide in a market where billions of apps are downloaded every year, now is the right time to get ahead of the curve with this incredible tool. Flutter for Dummies is your friendly, ground-up route to creating multi-platform apps. From how to construct your initial frameworks to writing code in Dart, you'll find the essentials you need to ride the Flutter revolutionary wave to success. This book includes how to create an intuitive and stunning UI, add rich interactivity, and easily pull in data. You'll also see how Flutter features like Hot Reload--providing sub-second refreshes as you refine your work--help you make sure your app is a delight to use. Start simple: follow steps to build a basic app It's alive! Keep connected to online data It moves! Make things fun with animated features Get the word out: use tips to expand your audience Whether you're a fledgling developer or an expert wanting to add a slick feather to your programming cap, join the Flutter revolution now and soar above the rest!

Zoom into the new world of remote collaboration While a worldwide pandemic may have started the Zoom revolution, the convenience of remote meetings is here to stay. Zoom For Dummies takes you from creating meetings on the platform to running global webinars. Along the way you'll learn how to expand your remote collaboration options, record meetings for future review, and even make scheduling a meeting through your other apps a one-click process. Take in all the advice or zoom to the info you need - it's all there! Discover how to set up meetings Share screens and files Keep your meetings secure Add Zoom hardware to your office Get tips for using Zoom as a social tool Award-winning author Phil Simon takes you beyond setting up and sharing links for meetings to show how Zoom can transform your organization and the way you work.

The fun and easy way to learn to use this leading business intelligence tool

Written by an author team who is directly involved with SAS, this easy-to-follow guide is fully updated for the latest release of SAS and covers just what you need to put this popular software to work in your business. SAS allows any business or enterprise to improve data delivery, analysis, reporting, movement across a company, data mining, forecasting, statistical analysis, and more. "SAS For Dummies, 2nd Edition " gives you the necessary background on what SAS can do for you and explains how to use the Enterprise Guide.SAS provides statistical and data analysis tools to help you deal with all kinds of data: operational, financial, performance, and morePlaces special emphasis on Enterprise Guide and other analytical tools, covering all commonly used featuresCovers all commonly used features and shows you the practical applications you can put to work in your businessExplores how to get various types of data into the software and how to work with databasesCovers producing reports and Web reporting tools, analytics, macros, and working with your data

In the easy-to-follow, no-nonsense "For" "Dummies" format, "SAS For Dummies" gives you the knowledge and the confidence to get SAS working for your organization.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.