Paul McFedries – författare

Use Excel 365 and Excel 2021 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including recent improvements ranging from dynamic arrays to XLOOKUP and LET. McFedries' step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate-to-advanced-level formula construction, and help you leverage Excel's most useful functions in your everyday work.

Becoming an Excel expert has never been easier!

 

By reading this book, you will:

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

 

About This Book

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

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

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.

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

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

Get ready to chew the fat.This engaging, humorous new book explains the not-so-common origins of such commonly used phrases as "apple-pie order," "chew the fat," and "hat trick." Presented in a fun, easy-to-read style, it provides entertaining insight on metaphorical phrases, weird words, and strange expressions and takes readers on a journey through the bizarre and eccentric origins that make up our everyday speech.* Word books have gained in popularity not just with students and linguaphiles, but with a general population interested in the fascinating development of our language* Contains back stories for 500 intriguing words and phrases* Fun to flip through and also fun to read cover to cover

A nontechnical manual for groundbreaking technology.The Complete Idiot's Guide® to Google Chrome OS presents readers with a clear overview of Google's free operating system-targeting users of netbook computers and allowing them to work primarily on the web - including how to send e-mail, work with pictures, save and manage files, use common office applications as well as more specialized programs, and deal with problems.?Available day-and-date with the software?Chrome OS will be free, making it very competitive with Windows 7 ?Google boasts that Chrome OS will start up and get the user onto the web in a few seconds, without having to contend with viruses, malware, and security updates

- Over 38 percent of all seniors in the U.S. now use the Internet.- Covers the most popular activities seniors enjoy - Facebook, GoogleSearch, and more!

Microsoft® Windows® 8 is designed to mesh users digital lives seamlessly-from desktop to phone to tablet-by utilizing a look and feel that give users a new Windows experience. However, with all of this change comes new features that may catch old-school Windows users off guard.In The Complete Idiot's Guide® to Microsoft® Windows® 8, veteran tech writer Paul McFedries uses his friendly style and wit to comfort experienced Windows users and newbies alike by explaining all the new features, as well as the old, and helping everyone overcome trepidation about using this completely updated look to the most popular desktop operating system in the world. Readers will learn how to use new features including tiles and the new home screen, how they can mesh their data with "the cloud," and much more. And, when all else fails, McFedries teaches users how they can easily and seamlessly toggle back to the "old" and familiar Windows look and feel, should the new experience prove to be a bit more change than desired.

Master two of the most powerful features of Excel Even if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this practical guide.Using a series of step-by-step tutorials and easy-to-follow screenshots, this book shows you in a visual way how to create and customize PivotTables and PivotCharts, use them to analyze business data, and ultimately achieve more with less work. Explains the benefits PivotTables and PivotCharts, two powerful features of Excel that allow users to create dynamic spreadsheetsCovers creating and customizing, analyzing business data, building custom calculations, linking to external data sources (including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes), creating macros to automate tasks, and moreUses step-by-step tutorials and easy-to-follow screenshots, a "learn by seeing" approach for visual learnersPractical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.

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!

Master two of the most powerful features of Excel

Even if you use Excel all the time, you may not be up to speed on two of Excel''s most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this practical guide.

Using a series of step-by-step tutorials and easy-to-follow screenshots, this book shows you in a visual way how to create and customize PivotTables and PivotCharts, use them to analyze business data, and ultimately achieve more with less work.

Explains the benefits PivotTables and PivotCharts, two powerful features of Excel that allow users to create dynamic spreadsheets Covers creating and customizing, analyzing business data, building custom calculations, linking to external data sources (including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes), creating macros to automate tasks, and more Uses step-by-step tutorials and easy-to-follow screenshots, a "learn by seeing" approach for visual learners

Practical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.

If you are serious about getting up to speed with Windows 7, then this clear, concise guide is the ideal companion for fast and efficient learning. The author illustrates the main functions of Windows 7, explaining everything you need to know in plain, jargon-free English with full-colour screen shots and numbered, step-by-step instructions.

The simple, yet elegant design features a multitude of images as well as tips & tricks to make this a perfect reference for all ages - just follow the instructions on your own PC.

Whether you are a beginner or an experienced user in need of a quick grip on the updates in Windows 7, read on for:

Windows 7 basics new ways to customize Windows to work for you the new interface and the new and improved Internet Explorer creating movies sharing their computer working with and managing files browsing the Web

Packed with advice and illustrations, this visual tutorial is excellent value for money. Learn something new today – read it, try it and become your own expert with Simply Windows 7!

If you are serious about getting up to speed with Windows 7, then this clear, concise guide is the ideal companion for fast and efficient learning. The author illustrates the main functions of Windows 7, explaining everything you need to know in plain, jargon-free English with full-colour screen shots and numbered, step-by-step instructions.

The simple, yet elegant design features a multitude of images as well as tips & tricks to make this a perfect reference for all ages - just follow the instructions on your own PC.

Whether you are a beginner or an experienced user in need of a quick grip on the updates in Windows 7, read on for:

Windows 7 basics new ways to customize Windows to work for you the new interface and the new and improved Internet Explorer creating movies sharing their computer working with and managing files browsing the Web

Packed with advice and illustrations, this visual tutorial is excellent value for money. Learn something new today – read it, try it and become your own expert with Simply Windows 7!

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

 

Language wears many hats, but its most important job is to help us name or describe what''s in the world. Words define us, our actions, even our existence. And just when you think that you have all the words you need, you discover new ones, hear new uses for old ones or see them mutate right before your eyes—a neologism is born.Those neologisms are actually one of the best ways of keeping tabs on the way our world and culture are changing. One of the people who''s been keeping tabs is Paul McFedries, the president of Logophilia Limited (logophilia is Greek for "the love of words"). His scorecard is Word Spy, a daily newsletter that has been reporting from the neological frontier since 1998 and that has more than 100,000 visitors a month and more than 12 million page views. In Word Spy, McFedries demonstrates how new words both reflect and illuminate not only the subcultures that coin them but also the larger culture in which these groups exist. Neologisms give us insight into the way things are even as they act as linguistic harbingers of what''s to come. Each chapter of Word Spy is a cultural snapshot, a slice of the zeitgeist that focuses on a specific idea or sociological phenomenon, with an emphasis on the words and phrases that it has generated. These snapshots cover various aspects of modern life, including relationships, business, technology, war, aging, multiculturalism, and even fast food, all the while introducing us to hybrid words: If your kids can''t seem to get away from their computers, they may be addicted to "fritterware" (time-wasting game software). If you''re a new mother with a passion for petitioning, you may be a "lactivist" (breast-feeding activist). And if you keep finding yourself staying way later at the office than you ever imagined, you may be suffering from "presenteeism." Word Spy is an exciting and informative travelogue through the evolving landscape of our language and, consequently, the cultures and subcultures that continually mold and shape not just the language but all of us who speak it.From the Trade Paperback edition.

An accessible guide to using a Mac or transitioning from Windows to Mac This book helps new-to-Mac users get more comfortable with their computers. Switching to a Mac Pocket Genius guides readers in learning more about their computers, including becoming familiar with the interface, performing routine tasks, and moving data. The author wants to help users get around Mac challenges and avoid or remedy common problems they encounter.

Master two of the most powerful features of Excel

Even if you use Excel all the time, you may not be up to speed on two of Excel''s most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this practical guide.

Using a series of step-by-step tutorials and easy-to-follow screenshots, this book shows you in a visual way how to create and customize PivotTables and PivotCharts, use them to analyze business data, and ultimately achieve more with less work.

Explains the benefits PivotTables and PivotCharts, two powerful features of Excel that allow users to create dynamic spreadsheets Covers creating and customizing, analyzing business data, building custom calculations, linking to external data sources (including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes), creating macros to automate tasks, and more Uses step-by-step tutorials and easy-to-follow screenshots, a "learn by seeing" approach for visual learners

Practical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.

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!

Do you look at the pictures in a book before anything else on a page? Would you rather see an image instead of read about how to do something? Search no further. This book is for you. Opening Windows 7 Simplified allows you to read less and learn more about the Windows operating system.

The easiest way for visual learners to get started with Windows 8

The popular Simplified series makes visual learning easier than ever, and with more than 360,000 copies sold, previous Windows editions are among the bestselling Visual books. This guide goes straight to the point with easy-to-follow, two-page tutorials for each task. With full-color screen shots and step-by-step directions, it gets beginners up and running on the newest version of Windows right away. Learn to work with the new interface and improved Internet Explorer, manage files, share your computer, and much more.

Perfect for the absolute beginner, with easy-to-follow instructions and colorful illustrations that show what''s happening on the screen Covers Windows basics, navigating the interface, creating accounts to share a computer, customizing Windows, and working with files Demonstrates how to browse the web with the new version of Internet Explorer, how to use media features, and much more The bestselling Simplified series is designed to make it easy for visual learners to start using new technologies right away

Windows 8 Simplified gives visual learners confidence as they start using the new version of Windows quickly and easily.

The easiest way for visual learners to get started with Windows 8

The popular Simplified series makes visual learning easier than ever, and with more than 360,000 copies sold, previous Windows editions are among the bestselling Visual books. This guide goes straight to the point with easy-to-follow, two-page tutorials for each task. With full-color screen shots and step-by-step directions, it gets beginners up and running on the newest version of Windows right away. Learn to work with the new interface and improved Internet Explorer, manage files, share your computer, and much more.

Perfect for the absolute beginner, with easy-to-follow instructions and colorful illustrations that show what''s happening on the screen Covers Windows basics, navigating the interface, creating accounts to share a computer, customizing Windows, and working with files Demonstrates how to browse the web with the new version of Internet Explorer, how to use media features, and much more The bestselling Simplified series is designed to make it easy for visual learners to start using new technologies right away

Windows 8 Simplified gives visual learners confidence as they start using the new version of Windows quickly and easily.

The easy, visual way to learn this popular database program

Part of the Office 2013 productivity suite, Access enables you to organize, present, analyze, and share data on a network or over the web. With this Visual guide to show you how, you''ll master the fundamentals of this robust database application in no time. Clear, step-by-step instructions are illustrated with full-color screen shots that show exactly what you should see on your screen. Learn to enter new records; create, edit, and design tables and forms; develop queries that generate specific reports; add smart tags to your tables; and much more.

While it is the most widely used database application, Access is not particularly intuitive; the Visual system''s two-page lessons and full-color screen shots make this complex software easier to learn Concise, step-by-step instructions and clear illustrations show you exactly what to expect Covers scores of tasks, including entering and setting up new records, organizing and sharing data, designing tables and forms, and generating reports Shows how to perform more complex operations, such as finding dependencies between database objects and adding smart tags to tables

Teach Yourself VISUALLY Access 2013 uses clear steps and high-resolution screen images to get you up and running with this popular database program.

Save yourself time, hassle, and confusion with this essential guide to the iPhone!

The popularity of the iPhone continues to grow every day and shows no sign of slowing down. Now that you''ve got the latest and greatest iPhone, it''s time you discovered all the best and most fun ways to use it! This handy guide presents you with all the important and interesting information you want to know, in a hip, helpful way. Packed with tips, tricks, and techniques, this new edition covers all the practical angles as well as the newest and coolest features, such as iOS 7, Siri, FaceTime video calling, HD video recording, multitasking, and much more.

Reveals numerous tips, tricks, and techniques in a handy trim size to help you get the most out of your iPhone 5s or iPhone 5c Features the hip, practical Portable Genius approach, designed to show you the key features that keep your digital lifestyle moving right along Highlights innovative ways to complete various tasks and spare you hassle and aggravation Details working with the newest features, including iOS 6.1, Siri, FaceTime, HD video recording and editing, multitasking, and more

iPhone 5s and iPhone 5c Portable Genius is all you need to make the most of your iPhone.

Save yourself time, hassle, and confusion with this essential guide to the iPhone!

The popularity of the iPhone continues to grow every day and shows no sign of slowing down. Now that you''ve got the latest and greatest iPhone, it''s time you discovered all the best and most fun ways to use it! This handy guide presents you with all the important and interesting information you want to know, in a hip, helpful way. Packed with tips, tricks, and techniques, this new edition covers all the practical angles as well as the newest and coolest features, such as iOS 7, Siri, FaceTime video calling, HD video recording, multitasking, and much more.

Reveals numerous tips, tricks, and techniques in a handy trim size to help you get the most out of your iPhone 5s or iPhone 5c Features the hip, practical Portable Genius approach, designed to show you the key features that keep your digital lifestyle moving right along Highlights innovative ways to complete various tasks and spare you hassle and aggravation Details working with the newest features, including iOS 6.1, Siri, FaceTime, HD video recording and editing, multitasking, and more

iPhone 5s and iPhone 5c Portable Genius is all you need to make the most of your iPhone.

Get the basics of Excel and then go beyond with this new instructional visual guide

While many users need Excel just to create simple worksheets, many businesses and professionals rely on the advanced features of Excel to handle things like database creation and data analysis. Whatever project you have in mind, this visual guide takes you step by step through what each step should look like. Veteran author Paul McFedries first presents the basics and then gradually takes it further with his coverage of designing worksheets, collaborating between worksheets, working with visual data, database management and analysis, VBA, and more.

Offers step-by-step instructions on a variety of tasks, some everyday and some more unique Shows you how to create basic spreadsheets, insert functions and formulas, work with pivot tables, and more Features a two-color interior features numerous screen shots to enhance your learning process for tasks such as creating and managing macros, generating and working with analytics, and using the advanced tools

Offering you a deep dive into Microsoft Excel, this book is the complete package for learning Excel with step-by-step, clear visual instructions.

The easy, visual way to learn this popular database program

Part of the Office 2013 productivity suite, Access enables you to organize, present, analyze, and share data on a network or over the web. With this Visual guide to show you how, you''ll master the fundamentals of this robust database application in no time. Clear, step-by-step instructions are illustrated with full-color screen shots that show exactly what you should see on your screen. Learn to enter new records; create, edit, and design tables and forms; develop queries that generate specific reports; add smart tags to your tables; and much more.

While it is the most widely used database application, Access is not particularly intuitive; the Visual system''s two-page lessons and full-color screen shots make this complex software easier to learn Concise, step-by-step instructions and clear illustrations show you exactly what to expect Covers scores of tasks, including entering and setting up new records, organizing and sharing data, designing tables and forms, and generating reports Shows how to perform more complex operations, such as finding dependencies between database objects and adding smart tags to tables

Teach Yourself VISUALLY Access 2013 uses clear steps and high-resolution screen images to get you up and running with this popular database program.

Learn the Genius tips and tricks that will make your iPad even better - now updated for iPad Air 2 and iPad mini 3!

iPad Portable Genius is a practical, easy to read guide to getting the most out of your iPad. Written in a clear, no-nonsense style, this full-color resource describes the tips and tricks you may not discover on your own. You''ll find helpful information about the most commonly used features, along with techniques that can help you do better things faster. Genius icons throughout the text highlight smarter ways to get things done, and plenty of screenshots provide visual examples of the techniques described. With coverage of the latest iOS and the newer-generation iPad Air and iPad mini, this book is a handy reference for any iPad user.

Apple''s iPad is unrivaled as the industry leader. Each generation of the iPad includes even more features than before, and the app store offers a world of ways to further customize your iPad to suit your needs. iPad Portable Genius gives you the fundamental skills that not only enhance your current iPad use, but also carry over into upgrades, new apps and the underlying techniques that can help you make the most of the iOS. Learn to:

Find your way around iPad Air 2, iPad mini 3, and older models of the iPad and iPad mini Connect to a network and sync your apps, photos, music, and more Organize your contacts and track your appointments Get more out of e-mail, audio, video, and Web surfing Configure your iPad, download apps, and troubleshoot when things go wrong

You''ve got the most coveted tablet on the market—don''t you want to see what it can do? If you''re only using your iPad for e-mail and the Internet, you haven''t even scratched the surface. iPad Portable Genius is your handy guide to full iPad functionality.