Excel is the most sophisticated spreadsheet program available, making it easy for you to create a variety of analyses and calculations for personal and professional use. However, this program is much more than just an electronic version of an accountant's green sheet, and mastering even the most basic functions can be a challenge.
Excel-erate your productivity with the only guide you'll need to the latest versions of Microsoft ExcelMicrosoft 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 ExcelPerfect 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.
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 readers get the absolute most out of features and improvements ranging from AutoFill to ExcelGÇÖs newest functions. Along the way, students will 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! Students will find crystal-clear instructions; insider insights; even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more. GÇó Quickly create powerful spreadsheets with range names and array formulas GÇó Use conditional formatting to instantly reveal anomalies, problems, or opportunities GÇó Analyze your data with standard tables and PivotTables GÇó Use complex criteria to filter data in lists GÇó Understand correlations between data GÇó Perform sophisticated what-if analyses GÇó Use regression to track trends and make forecasts GÇó Build loan, investment, and discount formulas GÇó Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets
A thorough and helpful reference for aspiring website buildersLooking 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!
A fast-paced, useful, and easy introduction to Microsoft 365For 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 imagesIdeal 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.
Collaborate with colleagues in real timeThrough Google's single sign-in suite of products, students, employees, and businesses can work seamlessly in G Suite's cloud-based office productivity apps: Gmail, Calendar, Docs and Sheets, Drive, Hangouts, Meet, and more. G Suite offers many benefits including security, reliability, and compatibility with other products. Three simple pricing plans are available to meet the usage and storage needs of large and small groups of collaborators.
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 imagesIdeal 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.
Your essential pocket guide to JavaScript(R) programming What if there were a portable book you could flip through whenever you needed a quick brush-up on the basics of JavaScript programming? Oh--there is! JavaScript Essentials For Dummies is a fluff-free summary of the core concepts you'll need to program websites. No lengthy explanations or repetition here. Just quick, simple answers to your essential JavaScript questions. Perfect as a refresher or as a desk reference to jog your memory, this handy Coding Essentials title is the simple way to get coding. Inside... Looking at simple code examples and explanations Setting up JavaScript files Creating and using functions Coding interactive forms Dealing with dates and times Commenting in your code Debugging your code
Your essential pocket guide to HTML and CSS Where do you turn when you need a quick brush-up on the basics of HTML and CSS programming? You turn to HTML & CSS Essentials For Dummies, of course! This fluff-free book gives you a concise summary of the foundations of front-end web programming. No lengthy explanations, unnecessary review, or endless repetition. Just simple answers to your essential HTML and CSS questions. Perfect as a refresher or as a desk reference to jog your memory, this handy Coding Essentials title makes it easy to find what you need, when you need it. Inside... Looking at simple code examples and explanations Creating impactful contentOrganizing your filesUsing multiple style sheetsBuilding interactive features Coding for desktop and mobile Making layouts and styling text
Stay organized and collaborate anywhere Google(R) Workspace is a one-stop-shop for emailing, creating documents, working with spreadsheets, and a whole lot more. Google(R) Workspace For Dummies makes it easy to discover all that this online productivity suite has to offer. You get simple instructions on how to make the most of Gmail(R), Calendar, Docs, Drive, and Meet. Go beyond the basics with advanced tips on document formatting, collaboration, and privacy and security. Gone are the days of endlessly searching for files. With Google(R) Workspace, they're all in one place. Inside... Sorting and filtering email Chatting with your contacts Managing your calendar Creating great presentations Wrangling data in Google(R) Sheets Working with shared files Creating forms and notes Organizing virtual meetings
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 iPad--browse 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 tablet Take great pictures and videos--then edit and share them with the world Get tips and shortcuts that will help you do things easier and faster with iPad Learn security best practices to keep your data and your iPad safeAnyone with a new iPad or iPad Pro and the new iPadOS will love this step-by-step guide to iPad operation, personalization, and maintenance.
From the back cover This exciting second edition of Web Design Playground is fully updated with new technologies and thoughtful approaches for building modern websites. Discover timeless HTML and CSS techniques, and dive into their cool new tags and features, including Flexbox and CSS Grid. Four serious projects put your skills to the test and give you useful, real-world pages for your portfolio. Don't worry about setting up your own servers and domain names--the book comes with a free online "playground" to experiment with and get creative. You can concentrate on core skills like page layout and adding images and video, as well as learning typography, responsive design, and the other modern web design techniques. Before you know it, you'll be ready to create gorgeous pages that reflect your creativity and style. About the reader If you can use a browser, you're ready to create web pages!
Speak the languages that power the webWith more high-paying web development jobs opening every day, people with coding and web/app building skills are having no problems finding employment. If you're a would-be developer looking to gain the know-how to build the interfaces, databases, and other features that run modern websites, web apps, and mobile apps, look no further. Web Coding & Development All-in-One For Dummies is your go-to interpreter for speaking the languages that handle those tasks.Get started with a refresher on the rules of coding before diving into the languages that build interfaces, add interactivity to the web, or store and deliver data to sites. When you're ready, jump into guidance on how to put it all together to build a site or create an app.* Get the lowdown on coding basics* Review HTML and CSS* Make sense of JavaScript, jQuery, PHP, and MySQL* Create code for web and mobile appsThere's a whole world of opportunity out there for developers--and this fast-track boot camp is here to help you acquire the skills you need to take your career to new heights!
The huge reference guide you need to use the full power of your MacMacs All-in-One For Dummies truly covers it all. This compete 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 elseComputer 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.
Excel-erate your Excel 365 knowledge with the celebrated Teach Yourself VISUALLY seriesIn 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 moreA 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.
Learn Windows 11 quickly, easily, and with expert help from a tech education masterWindows 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 toWith 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.
Everything you need to know about Windows 11 in a single, visual bookTeach 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 securityThe 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.
Learn Zoom in a flash with step-by-step instructions and clear, full-size screenshotsFor 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 upgradesPerfect 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.
Cut the cable television cord and cut your monthly billsAre 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 optionsWhen 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!
Your step-by-step guide to iPhone masteryiPhone 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 emailWith 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.
Increase your iPad IQ with this genius-level guide to the Apple iPadIf 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 calendarsPerfect 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.
Your no-fluff, fast-paced guide to everything Windows 10This 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 onlineWith concise, easy-to-follow instructions, and its small, portable size, this is the ideal, on-the-go guide for Windows 10 users everywhere.
Designed to help students practice and prepare for Microsoft Office Specialist (MOS): Word 2019 Expert certification, this official Study Guide delivers: In-depth exam prep for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to apply skills learned Practice and review questions Ready-made practice files Solution files for the practice tasks Sharpen the skills measured by these MOS objectives: Manage document options and settings Design advanced documents Create advanced references Create custom word elements Use advanced editing and formatting featuresAbout MOSA 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.
Hone your advanced Excel 2019 skills. And earn the credential that proves it!Demonstrate your expertise with Microsoft Excel! Designed to help students practice and prepare for Microsoft Office Specialist (MOS): Excel Expert 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 Solution files for the practice tasks 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 Pivot Tables
Teach yourself VISUALLY(TM) Are you a visual learner? Do you prefer instructions that show you how to do something--and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 160 macOS High Sierra tasks. Each task-based spread covers a single technique, sure to help you get up and running on macOS High Sierra in no time. You'll learn to: Set default zoom for websites Install and use a content blocker Connect through FaceTime(R) Publish photo albums to Facebook Customize Siri(R), mouse, and trackpad Designed for visual learners Two-page lessons break big topics into bite-sized modules Succinct explanations walk you through step by step Full-color screen shots demonstrate each task Helpful sidebars offer practical tips and tricks
Prenumerera på vårt nyhetsbrev för att få fantastiska erbjudanden och inspiration för din nästa läsning.
Genom att registrera dig accepterar du vår personuppgiftspolicy.
