Supercharge your productivity at the office and at home

Looking to familiarize yourself with the world's most popular and effective productivity apps? Then look no further than the latest edition of Office 365 All-in-One For Dummies, packed with 9 mini-books covering each of the super-apps included in the famous productivity suite from Microsoft. In the books, you'll get a handle on Word, Excel, PowerPoint, Outlook, Teams, Access, and more.

This convenient and authoritative collection will walk you through how to create and edit text documents in Word, make new spreadsheets in Excel, and set up virtual meetings in Teams. You'll also learn how to:

• Use pro-level keyboard shortcuts and speed techniques to accelerate your productivity
• Use Microsoft's new AI-powered Copilot to get help and even write and edit your documents
• Leverage SharePoint and OneDrive to share documents and collaborate remotely with colleagues

Office 365 All-in-One For Dummies is the first and last resource you'll need to reach for when you've got a question about Microsoft's ubiquitous productivity tools. It's perfect for newbies looking to get started and power users looking for fresh tips on the latest features. Grab your copy today!

An illustrated, A-to-Z, and newly updated guide to mastering Microsoft Office 365

Teach Yourself VISUALLY Microsoft 365, 2nd Edition is a newly revised edition of the easy-to-use and up-to-date visual walkthrough of Microsoft's ubiquitous office products. It#s the fastest and most efficient way to get up to speed on world-famous apps like Word, Excel, and PowerPoint, offering crystal-clear, high-resolution screenshots that show you exactly how to get things done.

Tired of confusing, text-based instructions that leave you scratching your head and wondering, Why didn't that work? Then grab a copy of TYV Microsoft 365, 2nd Edition for a complete, A-to-Z tour of Microsoft 365 that takes you through how to generate sophisticated documents in Word, crunch numbers in Excel, keep your life organized in Outlook, and build attractive and persuasive presentations in PowerPoint.

This book shows you how to master basic, foundational features that have been around for years, as well as cutting-edge new additions to the software--like Microsoft's Copilot AI--that make your job easier and make you more productive. From working with files in the cloud to setting up your own local databases in Access, TYV Microsoft 365, 2nd Edition puts the info, screenshots, and instructions you need at your fingertips.

Readers will find:

• Hundreds of hi-res, full-page screenshots that demonstrate Microsoft 365's most useful features
• Specific instructions on how to get more from your favorite Office 365 apps, like how to add attachments to your Outlook emails or include narration in a PowerPoint presentation
• Techniques to incorporate artificial intelligence in your everyday work to supercharge your productivity by summarizing Word documents or automatically generating Excel formulas

Perfect for anyone looking for an intuitive and visual guide to Microsoft 365 that comes with full-screen images that show you exactly what to do and where to click, Teach Yourself VISUALLY Microsoft 365, 2nd Edition is the simplest and most effective resource for mastering the world's most popular suite of office apps.

A fully illustrated, up-to-date, and start-to-finish guide to using Windows 11 devices

Tired of tech books that tell you what to do but never actually show you how to use your latest devices?

Then Teach Yourself VISUALLY Windows 11, 2nd Edition is for you. This book walks you through exactly how to get things done in Microsoft's newest Windows updates with crystal-clear, high-resolution screenshots and pictures that won't leave you scratching your head and wondering, Why didn't that work?

Teach Yourself Visually Windows 11 is a complete, start-to-finish visual tour of Windows 11. It will take you from What do I do first? to Windows guru, one picture and instruction at a time.

Looking for help on how to set up your Windows 11 tablet, laptop, or desktop computer for the first time? Teach Yourself Visually Windows 11 has got you covered with the visual interface explanations, Wi-Fi connection assistance, and Microsoft account setup directions you need to make that PC come alive.

And that's just chapter one.

Teach Yourself VISUALLY Windows 11 will also guide you through how to customize your PC, get connected to--and stay safe on--the web, message and email your friends and family, find specific files on your hard drive, check the weather forecast, secure your device against hackers and looky-loos, and pretty much everything else you can think of. You'll find:

• Hundreds of hi-res, full-page images and screenshots that demonstrate basic and advanced Windows 11 tasks you'll use every day
• Techniques for making your PC easier to use, including changing the font size, using your voice to active your computer, and more
• Ways to share your photos, videos, voice notes, and messages with your loved ones
• See Microsoft's new Copilot AI in action and use generated text and images in your documents, emails, and chats

Teach Yourself VISUALLY Windows 11 is the easiest, most intuitive, most fun, and most effective guide for everyone who prefers show over tell and who's ready to master their Windows 11 tablet, laptop, or desktop PC.

Learn Windows 11 quickly and painlessly with this beginner's guide

Windows 11 Simplified, 2nd Edition is your absolute beginner's guide to the ins and outs of Windows. Fully updated to cover Windows 11 and the latest updates from Microsoft, this highly visual guide covers all the new features in addition to the basics, giving you a one-stop resource for complete Windows 11 mastery. Every page features step-by-step screen shots and plain-English instructions that walk you through everything you need to know, no matter how new you are to Windows. You'll master the basics as you learn how to navigate the user interface, work with files, create user accounts, and practice using the tools that make Windows 11 the most efficient Windows upgrade yet.

This guide gets you up to speed quickly, with step-by-step screen shots that help you follow along with the clear, patient instruction.

• Shed your beginner status with easy-to-follow instructions
• Master the basics of the interface, files, and accounts
• Browse the web, use media features, and send and receive email
• Customize Windows to look and work the way you want

Learning new computer skills can be intimidating, but it doesn't have to be. Even if you have no Windows experience at all, this visually rich guide demonstrates everything you need to know, starting from the very beginning. If you're ready to become fluent in Windows, Windows 11 Simplified, 2nd Edition is the easiest, fastest way to learn.

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 Workspace
• Create and edit contacts, and set up video meetings
• Work on slides, spreadsheets, and documents
• Discover tips and tricks to increase productivity and keep your work secure

Google Workspace For Dummies is a must for business users and workers who use Google applications on the job. Casual users and students, you'll love it, too.

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.

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 safe

Anyone with a new iPad or iPad Pro and the new iPadOS will love this step-by-step guide to iPad operation, personalization, and maintenance.

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.

Build a Website with ChatGPT teaches you zero-coding web development utilizing powerful generative AI tools like ChatGPT. If you can open a web browser, you're ready to start building--absolutely no coding experience required.

Inside Build a Website with ChatGPT you'll learn the important skills of AI-assisted web programming, such as:

- Crafting effective prompts to generate HTML, CSS, and JavaScript
- Converting text into images with DALL-E integration
- Building navigation bars, image galleries, and contact forms
- Deploying fully functional sites to the web for free
- Customizing the generated code for unique sites

Inside Build a Website with ChatGPT you'll learn the high-level coding concepts that let you check and perfect AI output, prompting skills that deliver the exact code you need, and how to properly deploy your site to the web--for free! Annotated code samples and advice on code customization give you the perfect balance of understanding and convenience. Plus, you'll get access to a tried-and-tested repository of prompts and working code.

Purchase of the print book includes a free eBook in PDF and ePub formats from Manning Publications.

About the technology

You can build amazing websites even if you don't know HTML, CSS, and JavaScript. Just describe what you want in plain English, and let ChatGPT take care of the gnarly details! This book guides you step-by-step as you create user-friendly forms, interesting graphics, and interactive web pages using nothing but AI and your imagination.

About the book

Build a Website with ChatGPT shows you how to make websites in an AI-first world--no experience required! You'll start with the basics of generating pages with ChatGPT, and by the end of the second chapter your first site will be up and running. Author Paul McFedries then shows you how to add interesting text and graphics, forms for user input, and even custom CSS to give your pages some pizzazz. As you go, you'll expand your new AI skills to create photo galleries, portfolios, catalog pages and more.

What's inside

- Writing effective prompts to create code, text, and graphics
- Adding navigation bars, image galleries, and contact forms
- Deploying your sites to the web for free
- Adding your unique touches to AI-generated pages

About the reader

No experience with web development or programming required. If you can create a Word document, you can build a website!

About the author

Paul McFedries has written over 100 books on web development and other technology topics including Web Design Playground (Manning Publications).

The technical editor on this book was Anirudh V. Prabhu.

Table of Contents

1 Introducing website creation with ChatGPT
2 Creating and deploying your first web page
3 Working with fonts, colors, and headings
4 Adding structure to a page
5 Publishing page posts
6 Adding links and navigation
7 Creating site content
8 Generating site forms
9 Adding lists to your pages
10 Setting up a photo gallery
11 Creating a portfolio page
12 Building an article page
13 Coding an interactive course catalog
A Getting ready to build web pages with ChatGPT
B Deploying your site
C Learning a few ChatGPT best practices

The concise and digestible get-started guide to JavaScript programming

JavaScript Essentials For Dummies is your quick reference to all the core concepts about JavaScript--the dynamic scripting language that is often the final step in creating powerful websites. This no-nonsense book gets right to the point, eliminating review material, wordy explanations, and fluff. Find out all you need to know about the foundations of JavaScript, swiftly and crystal clear. Perfect for a brush-up on the basics or as an everyday desk reference on the job, this is the reliable little book you can always turn to for answers.

• Get a quick and thorough intro to the basic concepts of coding with JavaScript
• Review what you've already learned or pick up essential new skills
• Add interactive features to websites with JavaScript programming
• Keep this concise reference book handy for jogging your memory as you work

This book is to the point, focusing on the key topics you need to know about this popular programming language. Great for supplementing classroom learning, reviewing for a certification, or staying knowledgeable on the job.

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!

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.

The easy way to brush up on your HTML & CSS programming skills

HTML & CSS Essentials For Dummies is your quick and handy reference to all the core concepts of HTML & CSS--the must-know markup and style languages that make the internet go. This no-nonsense book gets right to the point, eliminating review material, wordy explanations, and fluff. Understand all the fundamentals of HTML and CSS, quickly. Perfect for a brush-up on the basics or as an everyday desk reference on the job, this is the reliable little book you can always turn to for answers.

• Get simple explanations of the basic concepts of coding with HTML & CSS
• Review what you've already learned or pick up essential new skills
• Create attractive and functional front ends for websites of all kinds
• Keep this concise reference book handy for jogging your memory as you work

This book is clear and direct, focusing on the key topics you need to know about defining a website's user interface. Great for supplementing classroom learning, reviewing for a certification, or staying knowledgeable on the job.

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.

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.

This exciting second edition of Web Design Playground is fully updated with new technologies and thoughtful approaches for building modern websites. You'll have a blast experimenting with a landing page, photo gallery, portfolio site, and more while you learn important web design skills.

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

Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.

About the technology

If you can use a web browser, you can create a web site! Web Design Playground, Second Edition shows you how, progressing step by step through fun and engaging projects. You learn the basics of HTML, CSS, and other important web skills. With its unique online playground, the book helps you build a landing page, a photo gallery, a portfolio site, and more, all from scratch. No prior experience or knowledge of special tools is required.

About the book

Web Design Playground, Second Edition takes a creative, visual approach and clear explanations of the components, concepts, and of each step you'll need to build your own web pages. You'll become a confident web designer as you practice each new skill in the Playground. The many small projects introduce everything from page layout basics to new tags and features like Flexbox and CSS Grid--all presented in author Paul McFedries's inimitably friendly style.

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.

What's inside

• Structure a web page with HTML
• Style a web page with CSS
• Modern page layout techniques
• How to use colors and typography

No web design experience required.

About the author

Paul McFedries has written more than 100 books, which have sold over four million copies worldwide.

Table of Contents

PART 1 GETTING STARTED WITH HTML AND CSS
1 Getting to Know HTML and CSS
2 Building Your First Web Page
3 Adding Structure to Your Page
4 Formatting Your Web Page
5 Project: Creating a Personal Home Page
PART 2 WORKING WITH IMAGES AND STYLES
6 Adding Images and Other Media
7 Learning More About Styles
8 Floating and Positioning Elements
9 Styling Sizes, Borders, and Margins
10 Project: Creating a Landing Page
PART 3 LAYING OUT A WEB PAGE
11 Learning Page Layout Basics
12 Creating Page Layouts with Flexbox
13 Creating Page Layouts with Grid
14 Designing Responsive Web Pages
15 Project: Creating a Photo Gallery
PART 4 MAKING YOUR WEB PAGES SHINE
16 More HTML Elements for Web Designers
17 Adding a Splash of Color to Your Web Designs
18 Enhancing Page Text with Typography
19 Learning Advanced CSS Selectors
20 Project: Creating a Portfolio Page
Appendix A From Playground to Web: Getting Your Pages Online

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!

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!

• Improve business analyses by adding intelligence and knowledge to your models
• Replace cumbersome formulas with convenient predefined functions
• Use modern lookups to make your formulas more powerful and flexible
• Simplify complex calculations with dynamic arrays in Excel 365 and Excel 2021
• Use conditional formatting to reveal anomalies, problems, or opportunities
• Calculate loan payments, interest costs, terms, and amortization schedules
• Project the future value of investments, and plan to achieve investment goals
• Master essential discounting and cash-flow analysis tools, including NPV and IRR
• Sort, filter, and analyze any tabular data, from customers to inventory
• Easily analyze huge datasets with PivotTable calculations
• Perform sophisticated what-if analyses, scenario planning, and forecasting
• Optimize profit, cost, or operational efficiency with Solver

• For everyone who wants to get more done with Microsoft Excel in less time
• For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data

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.