PowerPoint 2019 Intermediate picks up where PowerPoint 2019 Beginner left off. Here you’ll learn how to create slides from an imported Word outline, how to add equations and other more specialized text formatting, how to work with WordArt, shapes, and SmartArt, as well as how to add charts, videos, online pictures, 3D models, and icons to your presentations. You’ll also learn about rulers and guidelines, headers and footers, the basics of master slides, sections, slide transitions, and how to add comments or incorporate group edits. Also, the various views available in PowerPoint and how to create a PDF or export your presentation slides as images. If you’re ready to take your PowerPoint knowledge from beginner-level to more advanced, this is the book for you.
Excel 2019 Intermediate expands upon the basics taught in Excel 2019 Beginner. Written specifically for users of Excel 2019, this book teaches users how to take their knowledge of Excel to the next level with charts, PivotTables, conditional formatting and other intermediate-level topics such as data validation. So if you’ve mastered the basics of Excel and are looking to move to that next level, this is the book for you. keywords: Microsoft Excel 2019, conditional formatting, insert symbols, hide rows or columns, group data, subtotal data, pivottables, pivot tables, charts (bar column line scatter pie doughnut histogram), remove duplicate values, convert text to columns, limit allowed inputs in cells, hide or unhide a worksheet, lock cells or worksheets, auto fill, zoom, spellcheck, pinned worksheet
In this final book of the Excel Essentials 2019 series, Excel 2019 Formulas and Functions, M.L. Humphrey takes a deeper dive into how formulas and functions work in Microsoft Excel. Learn the difference between formulas and functions and how to find any function you need in Excel as well as how to troubleshoot common issues with formulas and functions. Approximately sixty functions are covered in detail, including functions like IFS and TEXTJOIN that were added for Excel 2019. In total, over a hundred functions are covered in this book. By the time you’re done you should be comfortable working with formulas and functions in Excel, know how to use the most common functions, and know how to find others when you need them. keywords: microsoft excel 2019, formulas, functions, TEXTJOIN, IFS, TRIM, CONVERT, ROUND, RANDBETWEEN, VLOOKUP, SUMIFS, COUNTIFS, AVERAGEIFS, MINIFS, MAXIFS, SWITCH, CHOOSE, TRANSPOSE, INDEX, MATCH, MEDIAN, MODE.MULT, FORECAST.LINEAR, FREQUENCY, SUMPRODUCT, FACT, COMBIN, WEEKDAY, WEEKNUM, NETWORKDAYS.INTL, troubleshooting errors, copying formulas, cell notation
Access 2019 Intermediate starts where Access 2019 Beginner left off.? Geared towards users of Access 2019, this book covers more complicated table and query issues such as how to include default values, use validation rules, and include fixed values in a query. It also covers union queries, crosstab queries, and how to ask for user input in a query. ?After that it covers in detail how to create and format forms and reports within Access, including how to apply conditional formatting to values as well as sum, group, and sort results. ?Perfect for those who’ve mastered the basics of Access and are now ready to take their knowledge a step further.
The Excel 2019 Formulas and Functions Study Guide is a companion book written to complement Excel 2019 Formulas & Functions by M.L. Humphrey. This guide contains a series of quizzes meant to test a reader’s knowledge of how formulas and functions work in Excel as well as approximately a hundred different functions. The quizzes are presented in an order that mirrors that of Excel 2019 Formulas & Functions. At the end of the book are ten bonus exercises meant to test a reader’s ability to apply Excel functions to real-world scenarios.
Get up and running fast with the PowerPoint 2019 PowerPoint continues to be the go-to tool for business presentations. The software helps anyone who needs to communicate clearly by creating powerful and effective slideshow presentations featuring data in the form of charts, clip art, sound, and video. You can even use it to create presentations for the Web. In PowerPoint 2019 For Dummies, expert Doug Lowe shows you how to use this popular tool to make show-stopping presentations that will get your message across — and your audience excited. Create a slide presentation with special effects Work with master slides and templates Collaborate with other users in the cloud Add charts, clip art, sound, and video Want to learn to use PowerPoint quickly and efficiently? Look no further!
Word 2019 Intermediate expands upon the basics taught in Word 2019 Beginner.? Written specifically for users of Word 2019, this book covers more advanced topics such as breaks, styles, tables, track changes, and multilevel lists. ?If you’ve mastered the basics of Word and are looking to move to the next level, this is the book for you.
Serving as both a training guide for Microsoft PowerPoint and a study guide for the PowerPoint certification exam, Microsoft PowerPoint Introduction and Certification Study Guide is an indispensable resource for PowerPoint users at every level of expertise. Starting with the essentials and building to more complicated steps, each chapter breaks one of five essential PowerPoint skill sets into manageable pieces. These are the exact skills measured by the exam, but the logical skill progression benefits all PowerPoint users and prepares you to create effective and compelling presentations. Concise steps and descriptions make the information easy to follow and remember. Clearly labeled screenshots and images clarify important PowerPoint features without being overwhelming. Those taking the exam will find practical tips on how to locate a testing center, register for the exam, and get the best score possible, along with study materials including practice exam software and video tutorials for every outcome in the book. Whether you are looking to develop your PowerPoint skills or to positively impact your school or work life through certification, Microsoft PowerPoint Introduction and Certification Study Guide can help you do both. Why certification is important Microsoft PowerPoint Certification is an easily verifiable way to showcase your willingness to learn new skills and software, and it provides a myriad of other benefits as well. Not only can certification enhance your PowerPoint skills, it can help get you hired, boost academic performance, prepare for the demands of the job, open doors to career opportunities, and be more productive and confident working on projects at school, home, or work. Microsoft PowerPoint (Microsoft 365 Apps and Office 2019) certification is the first step to prove your skill level and open doors to career opportunities. Outline of the book Build a strong foundation in PowerPoint and prepare for the exam with this all-in-one manual. In the first chapter, get comfortable with PowerPoint’s user interface and important terminology. A brief review of efficient practices reminds users of valuable keyboard shortcuts and commands. Those interested in taking the exam will learn how to register for the exam and find an exam center, what to expect during the exam, and get information on scoring and how to retake the exam. The subsequent chapters teach you how to independently create presentations using the core skills measured by the Microsoft PowerPoint Certification Exam: manage presentations; manage slides; insert and format text, shapes, and images; insert tables, charts, smartArt, 3D models, and media; and apply transitions and animations. Practice tasks, a self-exam and review questions after each chapter help solidify the skills you learn. Video camera icons within the text denote exercises that have a corresponding video tutorial, 85 in all, for when you need extra help or learn best by observation. Free PowerPoint practice exam software included Unlike any other PowerPoint exam manual available, this book includes free PowerPoint practice exam software. The final chapter focuses on the practice exam, which closely mimics the format of the real exam. Custom-built and specially designed by SDC Publications, the practice exam can be taken multiple times so you are comfortable with the test software, how to mark and return to questions, question format, live in-application steps, and how the results are presented. Study materials for all learning styles 50 flashcards Exam day study guide Free, custom-made Practice Exam Software 85 short narrated video tutorials for every exercise in the book About the author Daniel John Stine AIA, IES, CSI, CDT, is a registered architect with over twenty years of experience in the field of architecture. Throughout these years of professional practice, Stine has leveraged many of the Microsoft Office products to organize and manage complex projects. In addition to Microsoft Office certification study guides, Stine has written multiple books on architectural design software, all written using Microsoft Word and published by SDC Publications.