{"appState":{"pageLoadApiCallsStatus":true},"bookState":{"book":{"headers":{"timestamp":"2024-11-22T12:11:47+00:00"},"bookId":288839,"data":{"name":"Excel All-in-One For Dummies","title":"Excel All-in-One For Dummies","slug":"excel-all-in-one-for-dummies","breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"description":"<b>Excel-erate your productivity with the only guide you'll need to the latest versions of Microsoft Excel</b> <p>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 <i>Excel All-in-One For Dummies.</i> <p>Follow along with Excel expert and veteran author Paul McFedries as he walks you through every feature and technique you <i>need</i> 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. <p>This indispensable reference allows you to: <ul> <li>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</li> <li>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</li> <li>Enjoy the convenience of a single, comprehensive resource detailing everything you need to know about Excel</li> </ul> <p>Perfect for people coming to Excel for the very first time, <i>Excel All-in-One For Dummies, Office 2021 Edition</i> is also a must-read resource for anyone looking for a refresher on foundational or advanced Excel techniques.","bookOutOfPrint":true,"testBankPinActivationLink":"","publishedDate":"2021-12-14T12:11:16+00:00","primaryISBN":"9781119830726","secondaryISBNs":"9781119830757,9781119830740","learningType":"Advance","primaryCategory":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategory":{"categoryId":0,"title":null,"slug":null,"_links":null},"amazon":{"default":"https://www.amazon.com/gp/product/1119830729/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119830729/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119830729-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119830729/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119830729/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/covers/9781119830726.jpg","width":250,"height":350},"authors":[{"authorId":11290,"name":"Paul McFedries","slug":"paul-mcfedries","description":" <p><b>Paul McFedries</b> is a Google<sup>®</sup> Workspace administrator, a thankless job if ever there was one. Paul is also a full-time technical writer who has somehow found the time to write more than 100 books that have sold more than four million copies worldwide. ","hasArticle":true,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/11290"}},{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":" Greg Harvey is a language scholar who has traced the roots of Tolkiens work in European folklore and pre-Christian religious beliefs. He has studied 12 languages, including Elvish, Latin, and Anglo-Saxon. ","hasArticle":true,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9027"}}],"relatedArticles":{"_links":{"self":"https://dummies-api.dummies.com/v2/articles?book=288839&offset=0&size=5"}},"relatedBooks":[{"bookId":281709,"name":"Excel 2019 For Dummies","slug":"excel-2019-for-dummies","primaryCategory":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"categoryList":["technology","software","microsoft-products","excel"],"image":{"src":"https://www.dummies.com/covers/9781119513322.jpg","width":250,"height":350},"_links":{"self":"https://dummies-api.dummies.com/v2/books/281709"}},{"bookId":290168,"name":"Office 2021 All-in-One For Dummies","slug":"office-2021-all-in-one-for-dummies","primaryCategory":{"categoryId":33652,"title":"General Microsoft","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"categoryList":["technology","software","microsoft-products","general-microsoft"],"image":{"src":"https://www.dummies.com/covers/9781119831419.jpg","width":250,"height":350},"_links":{"self":"https://dummies-api.dummies.com/v2/books/290168"}},{"bookId":281706,"name":"Excel 2016 All-in-One For Dummies","slug":"excel-2016-all-in-one-for-dummies","primaryCategory":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"categoryList":["technology","software","microsoft-products","excel"],"image":{"src":"https://www.dummies.com/covers/9781119077152.jpg","width":250,"height":350},"_links":{"self":"https://dummies-api.dummies.com/v2/books/281706"}}],"cheatSheet":{"articleId":288828,"slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","title":"Excel 2021 All-in-One For Dummies Cheat Sheet","description":"In Microsoft Excel, you can use the keyboard to select cells and access hot key sequences that can greatly speed up the process of selecting program commands. Excel also makes it easy to share workbooks saved on your OneDrive and sort multiple fields in a table.","categoryList":["technology","software","microsoft-products","excel"]},"bookAuthorBio":"<p><b data-author-id=\"11290\">Paul McFedries</b> has written over 100 books with topics ranging from Windows 10 to Microsoft Office, Apple gadgets, and Amazon Alexa. His most recent <i>For Dummies</i> titles include <i>Google’s G Suite, Cord Cutting, and Excel Data Analysis.</i></p> <p><b data-author-id=\"9027\">Greg Harvey, PhD </b>was author of over 30 <i>For Dummies</i> titles covering Excel.","additionalResourceLink":"","bookCompanionPage":{"pageId":0,"name":null,"slug":null,"_links":null},"seo":{"metaDescription":"Excel All-in-One For Dummies (1119830729) is your handy reference and guide to all things Excel, from the basics to advanced.","noIndex":0,"noFollow":0}},"_links":{"self":"https://dummies-api.dummies.com/v2/books/288839"}},"bookLoadedStatus":"success","bookExtras":{},"bookExtrasLoadedStatus":"initial"},"adsState":{"pageScripts":{"headers":{"timestamp":"2024-11-22T05:50:01+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"\r\n<script src=\"https://cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"https:\" ? \"https://sb\" : \"http://b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"https://sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n","enabled":true},{"pages":["all"],"location":"footer","script":"\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"https://zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'></div>\r\n","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":" <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"https://www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":295890,"title":"Career Shifting","hasSubCategories":false,"url":"/collection/career-shifting-295890"},{"collectionId":294090,"title":"Contemplating the Cosmos","hasSubCategories":false,"url":"/collection/theres-something-about-space-294090"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":299891,"title":"For the College Bound","hasSubCategories":false,"url":"/collection/for-the-college-bound-299891"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":301547,"title":"For the Game Day Prepper","hasSubCategories":false,"url":"/collection/big-game-day-prep-made-easy-301547"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"Book4","path":"/book/technology/software/microsoft-products/excel/excel-all-in-one-for-dummies-288839/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"excel","book":"excel-all-in-one-for-dummies-288839"},"fullPath":"/book/technology/software/microsoft-products/excel/excel-all-in-one-for-dummies-288839/","meta":{"routeType":"book","breadcrumbInfo":{"suffix":"Books","baseRoute":"/category/books"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"profileState":{"auth":{},"userOptions":{},"status":"success"}}

Excel All-in-One For Dummies book cover

Excel All-in-One For Dummies

Authors:

Paul McFedries ,

Overview

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.

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.

Excel 2021 All-in-One For Dummies Cheat Sheet

In Microsoft Excel, you can use the keyboard to select cells and access hot key sequences that can greatly speed up the process of selecting program commands. Excel also makes it easy to share workbooks saved on your OneDrive and sort multiple fields in a table.

About The Authors

Paul McFedries has written over 100 books with topics ranging from Windows 10 to Microsoft Office, Apple gadgets, and Amazon Alexa. His most recent For Dummies titles include Google’s G Suite, Cord Cutting, and Excel Data Analysis.

Greg Harvey, PhD was author of over 30 For Dummies titles covering Excel.