Search results for ""author paul mcfedries""

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.

Read more less

A thorough and helpful reference for aspiring website builders Looking to start an exciting new career in front-end web building and design? Or maybe you just want to develop a new skill and create websites for fun. Whatever your reasons, it’s never been easier to start learning how to build websites from scratch than with help from HTML, CSS, & JavaScript All-in-One For Dummies. This book has the essentials you need to wrap your head around the key ingredients of website design and creation. You’ll learn to build attractive, useful, and easy-to-navigate websites by combining HTML, CSS, and JavaScript into fun and practical creations. Using the 6 books compiled within this comprehensive collection, you’ll discover how to make static and dynamic websites, complete with intuitive layouts and cool animations. The book also includes: Incorporate the latest approaches to HTML, CSS, and JavaScript, including those involving new markup, page styles, interactivity, and more Step-by-step instructions for new site creators explaining the very basics of page layouts and animations Easy-to-follow advice for adjusting page color and background, adding widgets to a site, and getting rid of all the bugs that affect site performance Bonus 6th book available at https://www.wiley.com/en-us/HTML%2C+CSS%2C+%26amp%3B+JavaScript+All+in+One+For+Dummies-p-9781394164721. Web development is a fun, interesting, and challenging skill that can lead to a lucrative career (if you’re so inclined). And with the right help, almost anyone can learn to create engaging websites from scratch. So, grab a copy of HTML, CSS, & JavaScript All-in-One For Dummies and you’ll be designing and building before you know it!

Read more less

Everything you need to know about Windows 11 in a single, visual book Teach Yourself VISUALLY Windows 11 collects all the resources you need to master the day-to-day use of Microsoft’s new operating system and delivers them in a single resource. Fully illustrated, step-by-step instructions are combined with crystal-clear screenshots to walk you through the basic and advanced functions of Windows 11. Teach Yourself VISUALLY Windows 11 offers the best visual learning techniques with comprehensive source material about the interface and substance of Windows 11, as well as: Stepwise guidance on working with files, digital pictures, and media Instructions for customizing Windows 11 and sharing your computer with family members Tutorials on installing and repairing applications, system maintenance, and computer security The fastest, easiest way for visual learners to get a grip on Windows 11, Teach Yourself VISUALLY Windows 11 is the best way to go from newbie to expert in no time at all.

Read more less

Increase your iPad IQ with this genius-level guide to the Apple iPad If you want to squeeze every last bit of incredible from your Apple iPad we've got you covered with this newly revised iPad Portable Genius. Want to learn how to connect to a network? How to configure your tablet? How to surf the web more comfortably? All while keeping your identity and accounts private and secure? With the iPad Portable Genius as your guide, you'll unlock the full potential of your iPad in no time at all. You'll learn how to: Get the most out of sending and receiving your email Have fun with your images and take crystal-clear photos every time Shoot and edit video right on your iPad Manage your busy schedule with calendars Perfect for anyone looking to save time and reveal the true power and flexibility of their iPad, the iPad Portable Genius, Fourth Edition contains all the new, engaging, and extensively illustrated info you need to master your tablet.

Read more less

Master Windows 10 by reading only one book Teach Yourself Visually Windows 10, 3rd Edition brings together all of the necessary resources to make you an expert in the use of the latest version of Windows. Using highly visual techniques to maximize learner retention and memory, Teach Yourself Visually Windows 10 will have you breezing through the most popular operating system in the world in no time. The book includes hundreds of step-by-step and illustrated sets of instructions to teach you both the basics and the complexities of Windows 10 operation. Lessons include: Installing and repairing applications System maintenance Setting up password-protection Downloading photos Managing media files And more Teach Yourself Visually Windows 10 combines the best of visual learning techniques with comprehensive source material about the interface and substance of Windows 10 to leave you with encyclopedic knowledge of the operating system. Perfect for beginners and intermediate users alike, this book will turn your Windows-using experience from a slow slog into a lighting-fast masterclass of efficiency.

Read more less

Advance your expert-level proficiency with Word. And earn the credential that proves it! Demonstrate your expert-level competency with Microsoft Word! Designed to help you practice and prepare for Microsoft Office Specialist: Word Expert (Word and Word 2019) certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what you’ve learned Ready-made practice files Sharpen the skills measured by these objectives: Manage Document Options and Settings Use Advanced Editing and Formatting Features Create Custom Document Elements Use Advanced Word Features About MOS: Expert Certification A Microsoft Office Specialist (MOS): Expert certification validates your hands-on experience and competency with an Office product at an expert level. It demonstrates that you can apply the product’s principal features at an advanced level, can complete expert tasks independently, and are ready to enter the job market. See full details at: microsoft.com/learn Practice Files Available at: MicrosoftPressStore.com/MOSWordExpert101/downloads

Read more less

A fast-paced, useful, and easy introduction to Microsoft 365 For those who need the show as well as the tell, Teach Yourself VISUALLY Microsoft 365 is the visual walkthrough to Microsoft’s latest suite of office products that will get you up-to-speed faster than any other resource on the market. This book offers image- and screenshot-rich tutorials alongside step-by-step instructions so you can see what you need to do to make the most of Microsoft 365. From getting a grip on the most basic Microsoft 365 functions to the advanced, new features known only by power users, the book provides you with the tools you need to make your work more streamlined and efficient. You’ll also get: Up to date—and visually supported—guidance on the major Office apps that are part of Microsoft 365: Word, Excel, PowerPoint, Outlook, and Access Full-color, two-page tutorials that get you up and running fast Easy-to-read instructions and stepwise advice to accompany the informative and crystal-clear images Ideal for people using Microsoft 365 for the very first time, Teach Yourself VISUALLY Microsoft 365 is also a can’t-miss resource for long-time users of the software suite who need an introduction to the latest version and Office veterans seeking a refresher on what Microsoft 365 is capable of.

Read more less

Advance your expert-level proficiency with Excel. And earn the credential that proves it! Demonstrate your expert-level competency with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Microsoft Excel Expert (Excel and Excel 2019) certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what you’ve learned Ready-made practice files Sharpen the skills measured by these objectives: Manage Workbook Options and Settings Manage and Format Data Create Advanced Formulas and Macros Manage Advanced Charts and Tables About the MOS: Expert Certification A Microsoft Office Specialist (MOS): Expert certification validates your hands-on experience and competency with an Office product at an expert level. It demonstrates that you can apply the product’s principal features at an advanced level, can complete expert tasks independently, and are ready to enter the job market. See full details at: microsoft.com/learn Practice Files Available at: MicrosoftPressStore.com/ MOSExcelExpert201/downloads

Read more less

See your way to Excel spreadsheet stardom with this visual guide If you're always hearing about the cool things Excel can do, here's your chance to see how to do them!Teach Yourself Visually Excel offers you a straightforward visual approach to working with the newest version of the world's leading spreadsheet program. Packed with visually rich tutorials and step-by-step instructions that will help you take your Excel skills to new heights, this friendly and approachable guide will have you creating, editing, and manipulating Excel spreadsheets in no time! Excel can seem daunting, but with Teach Yourself Visually Excel, you'll quickly and painlessly learn how to perform dozens of tasks, including creating spreadsheets and charts, filtering and sorting data, working with PivotTables, and so much more. Covering the latest additions and changes to the newest version of Excel, a series of easy-to-follow, full-color tutorials helps you to excel at working with Excel! Tutorials and step-by-step screenshots make lessons easy to follow and understand Helps you grasp the basic functions of Excel—and beyond Walks you through Excel s new features Clearly demonstrates how to organize, present, analyze, and chart data with Excel Whether you've never used Excel or just need to brush up on its new features, Teach Yourself Visually Excel will be the dog-eared resource you'll turn to again and again.

Read more less

Help for newcomers to Apple's popular tablet computer Fully updated to cover the latest version of iPadOS and all the newest features, iPad & iPad Pro For Dummies is your fun, full-color guide to the most popular tablet on the market. There are a lot of things you can do with an iPadbrowse the internet, take photos and videos, manage your schedule, play games, stream media, create documents, send e-mail, and beyond. Learn how to tackle everything from the basics to more advanced iPad operations, and find tips on how to make the most of the new features and customize your device to your liking. You're on your way to becoming an iPad power user, with this Dummies title. Discover the basics of setting up and navigating your tabletTake great pictures and videosthen edit and share them with the worldGet tips and shortcuts that will help you do things easier and faster with iPadLearn security best practices to keep your data and your iPad safeAnyone with a new iPad or iPad Pro and the new iP

Read more less

Advance your everyday proficiency with Access 2019. And earn the credential that proves it! Demonstrate your expertise with Microsoft Access! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Access 2019 certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what you’ve learned Practice files and sample solutions Sharpen the skills measured by these objectives: Create and manage databases Build tables Create queries Create forms Create reports About MOS A Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards. Hands-on experience with the technology is required to successfully pass Microsoft Certification exams.

Read more less

The quick way to learn Microsoft Teams! This is learning made easy. Get more done quickly with Microsoft Teams in any environment, and help your whole team succeed with it. Jump in wherever you need answers—brisk lessons and detailed screenshots show you exactly what to do, step by step. Build your own teams to enhance collaboration Use team channels to bring structure and relevance to your work Work smarter with apps, tabs, extensions, connectors, and bots Create, upload, edit, and share Microsoft 365 documents inside Teams Stay connected via chat and video calls Get more done in every Teams meeting Customize Teams to maximize personal and organizational efficiency Look up just the tasks and lessons you need

Read more less

Your step-by-step guide to iPhone mastery iPhone Portable Genius delivers a practical and simple guide to quickly learning everything you need to know about the iPhone. Whether you're a novice user with Apple products or a seasoned pro, you'll find a wealth of info designed to show you how to configure your iPhone, set up accounts, manage your contacts and appointments, take stunning pictures, and surf the web. All while keeping your identity and accounts private and secure. Before you know it, you'll be: Mastering the touchscreen Setting up your iPhone to suit the way you work and play Connecting your iPhone to Wi-Fi and setting up your phone as an internet hub Solving the most common iPhone problems Getting the most out of email With straightforward and step-by-step instructions in a portable and convenient package and engaging illustrations, iPhone Portable Genius is the ideal resource for owners and users of one of the world's most popular phones.

Read more less

Learn the in-demand skills that let you turn lines of code into websites and apps Web Coding & Development All-in-One For Dummies is a one-stop resource for would-be developers who need guidance on the languages and steps used to build websites and applications. Learn the coding ropes and expand your existing skillset with this easy-to-understand guide. In these complete mini-books, you’ll walk through the basics of web development, structuring a page, building and processing web forms, and beyond. Learn how to build a website or create your very own app with the advice of web coding and development experts. This edition expands JavaScript and CSS coverage while providing new content on server-side coding and the development stack. Get essential knowledge of how web development works—even if you’ve never written a line of code in your life Learn HTML, CSS, JavaScript, and other languages essential for building websites and apps Discover how to make optimize your sites and apps for mobile devices Expand on what you already know and improve your employability This Dummies All-in-One is great for you if want to develop coding skills but don’t have a programming background. It’s also perfect for professionals looking to brush up on their web development skills and get up to date on the latest trends and standards.

Read more less

The huge reference guide you need to use the full power of your Mac Macs All-in-One For Dummies truly covers it all. This complete reference guide contains five books in one, so you can learn all your Mac is capable of. You’ll get a complete understanding of your computer, so you can use it for pleasure or business, become a multimedia master, surf the web like a pro, troubleshoot problems as they arise, and so much besides. This latest edition is updated for the newest version of macOS, the hottest apps, and the just-released Macs. Running an older Mac? Don’t worry, this book won’t leave you behind. Everything you need to do on your Mac can be learned with the help of Macs All-in-One For Dummies. Learn your way around your Mac and customize all the macOS features Discover the newest features (and the returning classics) so you can make the most of your machine Beef up your security, stay safe while surfing the web, and figure it out when things go wrong Use your computer to work, play, create videos, keep in touch, and everything else Computer users who are switching to a Mac for the first time, as well as previous Mac users who are upgrading to the newest model, need a guide for getting the most out of their powerful computer. This is that guide.

Read more less

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!

Read more less

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.

Read more less

Easy advice for getting the most out of Google Workspace for school, work, or personal use Google Workspace For Dummies is here to show you the tips and tricks for upping your productivity with Google's cloud-based software suite. This book includes jargon-free instructions on using Gmail, Calendar, Docs, Sheets, Drive, Chat, and Meet. You'll learn about the AI features, updated security, compatibility with other apps, picture-in-picture capability for video meetings, and beyond. Plus, you'll get info on Google's Forms and Notes feature that makes it simple to gather and share data and stay up-to-date with your team. It's easier than ever to collaborate securely in the cloud, thanks to this Dummies book. Learn how to collaborate with colleagues in real time using the programs that come with Google WorkspaceCreate and edit contacts, and set up video meetingsWork on slides, spreadsheets, and documentsDiscover tips and tricks to increase productivity and keep your work secure Google Works

Read more less

Hone your advanced Excel 2016 skills. And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Excel Expert 2016 certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what you’ve learned Ready-made practice files Sharpen the skills measured by these objectives: Create and Manage Workbooks Apply Custom Formatting and Layouts Create Advanced Formulas Perform Data Analysis Create Advanced Charts and PivotTables

Read more less

Enter the Web Design Playground and start experimenting with all aspects of creating a web page—from design, to development, to publishing—in an easy-to-use free online workspace. Suitable for anyone interested in creating web pages. In Web Design Playground, Second Edition you'll learn essential tools of the web design trade, such as: Structuring a web page with HTML Styling a web page with CSS Modern page layout techniques Using colors in web design Making text look awesome with typography About the technology HTML, CSS, and the principles of good web design are all you need to build something beautiful! You'll find them all inside this one-of-a-kind guide. Written by web designer and master teacher Paul McFedries, this unique book shapes and sharpens your skills in the always-relevant technologies of the web.

Read more less

Excel-erate your Excel 365 knowledge with the celebrated Teach Yourself VISUALLY series In Teach Yourself VISUALLY: Excel 365, veteran tech educator and writer Paul McFedries delivers a practical, step-by-step guide to using the latest version of the world’s most popular spreadsheet app. The book is filled with easy two-page lessons containing large-size screenshots and walkthroughs demonstrating common and useful tasks in Excel 365. You’ll learn how to present, analyze, visualize, and organize your data, as well as how to: Create and fill spreadsheets, charts, tables, and PivotTables Filter and sort your data, use and create formulas, and organize your information Visualize your data with a variety of effective charts, graphs, and more A can’t-miss handbook perfect for anyone looking for straightforward and easy-to-follow tutorials on basic and advanced Excel techniques, Teach Yourself VISUALLY: Excel 365 offers users of previous Excel versions—and complete Excel newbies—a clear roadmap to mastering Excel.

Read more less

Learn Windows 11 quickly, easily, and with expert help from a tech education master Windows 11 Simplified is your from-scratch beginner’s guide to the ins and outs of the latest version of Windows. It’s fully updated to include all the coolest new features of Windows 11 and offers a highly visual roadmap – complete with tons of screenshots and illustrations – to Windows 11 mastery. You’ll get up to speed on the basic, and not-so-basic, features of Windows 11 with plain-English instructions and step-by-step screenshots that walk you through every technique you need to know to make Windows 11 do what you want it to do. You’ll learn to navigate the user interface, work with and manage files, create user accounts, and practice using the tools that make Windows 11 the most user-friendly and powerful version of the famous operating system yet. You’ll also discover how to: Master the basics, as well as a bunch of power-user tools, with easy-to-follow instructions Learn your way around the interface, File Explorer, the Settings app, and more Navigate the web, send emails, access online media, and chat with friends and family Customize windows to look and feel exactly the way you want it to With the right help, learning a new operating system can be fun, straightforward, and exciting. This book is perfect for everyone from those with no Windows experience at all to users of previous versions who just need a heads-up on the latest features. If you’re ready to become a Windows 11 master, Windows 11 Simplified is the easiest and fastest way to do it.

Read more less

Make your every wish Alexa’s command with this in-depth guide to the wildly popular Amazon smart speaker You might be thinking, “All I have to do is plug in my Echo device and start using it!” And you’d be right. But if you really want to explore what that compact little device can do, then Alexa For Dummies is your go-to resource. This book shows you how to customize your device to respond to your requests and enhance your life. Alexa For Dummies takes you on a tour of all things Alexa: its capabilities, tools, settings, and skills. Go beyond the basics of playing music, calling friends, reading the news, and checking the weather. You’ll learn how to make Alexa private and secure, connect it to your smart home devices, and even make it sound like Samuel L. Jackson, if you feel like it. You can also extend its capabilities by adding new skills. Customize your device to respond to your voice Troubleshoot when a light is signaling something’s wrong Add skills to play music and audiobooks Create routines to turn on lights, adjust the thermostat, set your security alarm, and lock your doors Sync your smart devices throughout your home Use Alexa to connect to a Zoom meeting or phone call with your friends or family No matter which device you have—Echo, Echo Dot, Echo Show, Echo Studio, Echo Flex, Echo Loop, Echo Buds, or Echo Frames—Alexa For Dummies is the perfect companion. Ready to get started? Say “Hey, Alexa, order Alexa For Dummies!”

Read more less

Take a guided tour of macOS High Sierra and discover just how much your Mac can do Teach Yourself VISUALLY macOS High Sierra is the perfect introduction to Apple's operating system. With clear, step-by-step instructions and plenty of rich visuals, it walks you through the new macOS High Sierra and demonstrates the essential tasks you need to know. You'll learn how to manipulate Preferences to customize your experience, make the most of your digital media, and streamline your workflow while having a little fun. You'll tour Photos, Messages, and Notifications, and get acquainted with Mission Control, the App Store, and Siri. New Mac users will appreciate the straightforward instruction, while veteran users will enjoy getting up to speed on the latest features introduced or upgraded in macOS High Sierra. macOS High Sierra is the latest incarnation of Apple's macOS, boasting elegant new visuals, several new features, and more seamless integration of Mac and iOS devices. If you use a Mac, you're going to want a guided tour that shows you just what macOS can do for you. Teach Yourself VISUALLY macOS High Sierra is your go-to guide, from the fundamentals to the neat little tricks that make the Mac experience something far beyond computing. • Edit and enhance photos with the powerful new tools on the Photos app • Browse the web safely with Safari's new privacy features • Share files quickly and easily using iCloud Drive • Use Siri to accomplish more in less time Like any computer, your Mac is a tool. And like any tool, the more you know about it, the more you get out of it. Discover the beauty, simplicity, and sheer functionality that millions already enjoy—and get ready to master your Mac with Teach Yourself VISUALLY macOS High Sierra.

Read more less

See your way to super spreadsheets with Excel 2010 and this visual guide! If you're always hearing about the cool things that Excel can do, here's your chance to see how to do them! With pages of full-color, step-by-step instructions and crystal-clear screen shots, this guide shows you how to get the most out of Excel 2010. The book covers all the basics as well as Excel 2010's new features and functions, including a new interface and better collaboration tools. Crunch and chart your data over a network, over the Web, or at home-helpful tips on every page will get you there even faster! Provides a clear look at Excel 2010, the newest version of the world's leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite Demonstrates how to create spreadsheets and charts, filter and sort data, work with PivotTable, and present your data-on a network, on the Web, or on your laptop Explores all features and functions in full-color pages packed with screen shots and other visual graphics that clearly show you how to accomplish tasks Includes practical examples, tips, and advice on how to use all the tools more effectively Get the very most out of Excel 2010 with this easy-to-follow guide!

Read more less

Master core Excel tools for building powerful, reliable spreadsheets with Excel 2019 Formulas and Functions. Excel expert Paul McFedries shows how to use Excel core features to solve problems and get the answers you need. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from AutoFill to Excel’s newest functions. Along the way, you discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation. Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions; insider insights; even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more. • Quickly create powerful spreadsheets with range names and array formulas • Use conditional formatting to instantly reveal anomalies, problems, or opportunities • Analyze your data with standard tables and PivotTables • Use complex criteria to filter data in lists • Understand correlations between data • Perform sophisticated what-if analyses • Use regression to track trends and make forecasts • Build loan, investment, and discount formulas • Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets

Read more less

You're one of the legions of fans who enjoy the ease and simplicity of the Mac. But some functions still elude you. How do you synch your Mac with other devices? What are the best ways to organize your life and files with your Mac? Can you get more from your Mac hardware or upgrade it? The Portable Genius is here to help.

Read more less

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.

Read more less

Learn Zoom in a flash with step-by-step instructions and clear, full-size screenshots For anyone looking for a fast and easy way to learn the most popular videoconferencing software on the market today, Teach Yourself VISUALLY Zoom is your secret weapon. This hands-on guide skips the long-winded explanations and actually shows you how to do what you need to do in Zoom with full-size, color pictures and screenshots. Whether you’re a total newbie to Zoom or you just need to brush up on some of the finer points of this practical software, you’ll be up and running in no time at all. From joining and hosting Zoom meetings to protecting your privacy and security while you’re online, Teach Yourself VISUALLY Zoom hits all the key features that make online meetings a breeze. You’ll also learn to: Integrate Zoom with other apps and share screens and PowerPoints with other meeting attendees Schedule, record, and replay your meetings so you never miss out on the important stuff Update your Zoom installation to ensure you’re using the latest security patches and upgrades Perfect for anyone expected to use Zoom at school or at work, Teach Yourself VISUALLY Zoom is the most useful and simplest Zoom handbook currently available.

Read more less

Your no-fluff, fast-paced guide to everything Windows 10 This handy, jargon-free guide is designed to help you quickly learn whatever you need to know about Windows 10. Perfect for novices and experienced users alike, you'll get tips, tricks, and savvy advice on how to install programs, set up user accounts, play music and other media files, download photos from your digital camera, go online, set up and secure an email account, and much, much more. Shows how to perform more than 150 Windows tasks, including working with files, digital images, and media; customizing Windows; optimizing performance; and sharing a computer with multiple users Covers installing and repairing applications, system maintenance, setting up password-protected accounts, downloading photos to your computer, and staying safe online With concise, easy-to-follow instructions, and its small, portable size, this is the ideal, on-the-go guide for Windows 10 users everywhere.

Read more less

Get practical walkthroughs for the most useful Excel features Looking for easy-to-understand, practical guidance on how to go from Excel newbie to number crunching pro? Excel Workbook For Dummies is the hands-on tutorial you've been waiting for. This step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. At your own speed, you'll learn how to enter data, format your spreadsheet, and apply the mathematical and statistical capabilities of the program. Work through the book from start to finish or, if you'd prefer, jump right to the section that's giving you trouble, whether that's data visualization, macros, analysis, or anything else. You can also: Brush up on and practice time-saving keyboard shortcuts for popular commands and actions Get a handle on multi-functional and practical pivot tables with intuitive practice exercises Learn to secure your data with spreadsheet password protections Perfect for new users of Excel, Excel Workbook For Dummies is also the ideal resource for those who know their way around a spreadsheet but need a refresher on some of the more advanced features of this powerful program.

Read more less