Computer Skills
As a student, you will use Microsoft Office products on a regular basis. However, you may not have experience with everything available in the Office Suite. Make sure to learn more about word processing, presentation creation, and spreadsheets by reviewing books that we have on these topics.
For interactive help, please check out free videos and tutorials on Computer, Internet, and Microsoft Office Basics from our PrepSTEP library resource.
Microsoft Word
Microsoft Word 2016 by
Whether you are a beginner or experienced user, learn about new features in this version or discover and use some of Word's functions for the first time. Joan Lambert, author of multiple books on the Microsoft Office Suite, creator of many Lynda.com videos and an experienced corporate trainer used her experience and knowledge to cover the most relevant functions for users at different levels. Suggested uses: * Workplace - flat for easy storage and access at a moments notice to find a function you need to use, or to jog your memory for a function you do not use often * Company Training - reduce help-desk calls and keep productivity flowing for a team or for your entire company * Students/Teachers/Parents - help with the learning curve in a classroom or for your child and any projects requiring Word * College Students - make sure you are using features that can make your life easier
ISBN: 9781423226055Publication Date: 2015-12-01
Microsoft 365 Word Tips and Tricks by
Explore Word's top tools and undiscovered features, and learn how to use them optimally in a business or real-world settingKey Features*Use MS Word more efficiently and leverage this handy guide to help you when you get stuck*Collaborate online effectively and format a variety of professional documents expertly*Hone your MS Word troubleshooting skills to solve formatting problems and issues encountered by everyday usersBook DescriptionMicrosoft Word, or MS Word, is a word processor developed by Microsoft. Although Word is one of the office productivity applications included in the Microsoft Office suite, it can also be purchased as a standalone product. MS Word enables you to create, edit, and save professional documents, among other helpful features. Anyone who wants to get better at working with Word will be able to put their MS Word knowledge to use with this practical guide.The book takes a hands-on problem- and solution-based approach to implementation and provides associated methodologies that will have you up and running and productive in no time. Complete with step-by-step explanations of essential concepts and practical examples, you'll begin by exploring different versions of Microsoft Word and understand how these versions impact collaboration with others, along with exploring the features available. Throughout the book, you'll learn how to work more productively and efficiently, with others as well as by yourself, using Word's sharing and collaboration features and the new reading and accessibility features.By the end of this Microsoft Word book, you will be able to troubleshoot common issues that may arise when working with documents.What you will learn*Track a document's changes as well as comment on and review changes by others, both locally and remotely*Use Word's navigation and view features to improve productivity*Generate more consistently formatted documents with Styles*Perform common tasks through simple formatting techniques, Quick Parts, customizing AutoCorrect/AutoFormat, and memorizing keyboard shortcuts*Troubleshoot the most frustrating formatting problems experienced by Word users*Create more universally accessible documents by adding Alt Text using the accessibility checker and other Word featuresWho this book is forThis book is for business professionals with basic experience of Office apps looking to utilize the Windows version of Microsoft Word to create, edit, format, read, print, and collaborate with short and long documents at home, at work, and on the go. The book assumes some very basic knowledge of Word and word processing programs in general, such as open, save, copy, and paste.
ISBN: 9781800565432Publication Date: 2021-11-12
Microsoft PowerPoint
Microsoft Powerpoint 2016 by
Whether you are a beginner or experienced user, learn about new features in this version or discover and use some of PowerPoint's functions for the first time. Joan Lambert, author of multiple books on the Microsoft Office Suite, creator of many Lynda.com videos and an experienced corporate trainer used her experience and knowledge to cover the most relevant functions for users at different levels. Look for "PowerPoint 2016 Tips & Tricks", and use the pair to become a power user that can create exactly the presentation you want to give. Suggested uses: * Workplace - flat for easy storage and access at a moments notice to find a function you need to use, or to jog your memory for a function you do not use often * Company Training - reduce help-desk calls and keep productivity flowing for a team or for your entire company * Students/Teachers/Parents -help with the learning curve in a classroom or for your child and any projects requiring PowerPoint * College Professors/Students - give polished presentations to your classes that give your hard work the look it deserves
ISBN: 9781423226093Publication Date: 2016-05-01
A Trainer's Guide to PowerPoint by
Learn the Secrets Needed to Master PowerPoint for Training As a successful facilitator, you know the importance of the resources in your professional toolkit. How you engage your audience and improve learning can be affected by how well you use them. But mastery of PowerPoint evades many. Feedback on presentations can range from "What was the point?" to "That changed my life." Most, though, fall closer to the former. If you are looking for a guide to the PowerPoint practices that will push your presentations into the latter category, look no further. A Trainer's Guide to PowerPoint: Best Practices for Master Presenters is Mike Parkinson's master class on the art of PowerPoint. While Parkinson wants you to understand how amazing a tool PowerPoint is, he's the first to tell you that there is no magic button to make awesome slides. There are, however, proven processes and tools that deliver successful PowerPoint content each and every time you use them. In this book he shares them, detailing his award-winning PowerPoint process and guiding you through three phases of presentation development--discover, design, and deliver. What's more, Parkinson is a Microsoft PowerPoint MVP--most valuable professional--an honorific bestowed by Microsoft on those with "very deep knowledge of Microsoft products and services." He shares not only his tips and best practices for presentation success, but also those from several of his fellow MVPs. Parkinson invites you to master PowerPoint as a tool--just like a paintbrush and paint--and to realize that the tool doesn't make the art, you do.
ISBN: 9781947308527Publication Date: 2018-10-02
Microsoft Excel
Microsoft Excel Functions and Formulas with Excel 2019/Office 365 by
In this completely updated edition covering Excel 2019, previousversions, and Office 365, Microsoft Excel Functions & Formulas 5/E demonstratesthe secrets of Excel through the use of practical and useful examples in aquick reference format. Easy to use and equipped with a variety offunctions, Microsoft Excel is the tool of choice when it comes to crunchingnumbers, building charts, and analyzing tables. The book's extensive examplesand added video tutorials make it an excellent resource for all Excel users whowant to understand, create, and apply formulas. Experienced users will alsofind Microsoft Excel Functions & Formulas 5/Ean excellentreference for many of the program's advanced formulas and functions. The textis easy to understand with numerous step-by-step instructions and the actual,ready to use, Excel screenshots of the input and output from the formulas. Thebook includes companion files with video tutorials, over 250 worksheet files ofexamples for numerous functions, formulas, and all the figures from the text. FEATURES Includescompanion files with video tutorials, over 250 Excel worksheet examples, andall of the figures from the text (including 4-color) Completelyupdated to cover Microsoft Excel 2019, previous versions, and Office 365 Saveshundreds of hours with the latest Excel tips, worksheets, and shortcuts Writtenby a proven author with Microsoft ValuedProfessional(MVP) status The Companion Files are also available for downloading from the publisher by emailing proof of purchase to info@merclearning.com.
ISBN: 9781683923732Publication Date: 2019-03-05
Microsoft Excel 365 Formulas by
Quick and easy 6 page laminated guide loaded with essentials focusing on creating and using formulas efficiently and effectively. For beginners or experienced users, formulas are Excel's superpower that can be yours. Find hundreds of the most popular and useful functions for formulas fast and with clear succinct steps to get the task done. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant use of formulas for users at different levels. Look for Excel 365, Excel 365 "Tips and Tricks", "Advanced" and "Pivot Tables" QuickStudy guides to have a complete power-user reference set. 6 page laminated reference guide includes: Order of Operations Creating Formulas Using Tables in Formulas Organizing Data Using Named Ranges Summary & Statistical Functions Counting Values in Cell Ranges Performing Financial Calculations Principal & Interest Payments Calculating Present & Future Value Calculating Time to Reach an Investment Goal Performing Conditional Calculations Using IF & IFERROR Logical Comparisons Error Codes Processing Text Using Formulas Extracting Text From a Cell Cleaning Imported Data Combining Multiple Text Strings Performing Date Calculations Finding & Displaying Cell Values & Formula Text Look Up Cell Values Display Formula Text Division, Decimals & Rounding Dividing Values to Find Quotients & Reminders Finding the Integer & Decimal Parts of Numbers Rounding Numbers Up & Down Generating Random Values Auditing Formulas Suggested uses: Workplace - flat for easy storage and access at a moments notice to find a formula function you need to use, or to jog your memory for a function you do not use often Company Training - reduce help-desk calls and keep productivity flowing for a team or for your entire company Students/Professors - make lives easier for students in many majors needing Excel for data management and calculation
ISBN: 9781423246664Publication Date: 2021-05-01
Microsoft Excel 365 Advanced by
Quick and easy 6 page laminated guide loaded with essential functions and how to perform them in Excel 365 (and Excel 2019). Beginners and experienced users, can find hundreds of the most popular and useful functions fast with clear succinct steps to get the task done. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant functions for users at different levels. Look for Excel 365, Excel 365 "Tips and Tricks", "Formulas" and "Pivot Tables" QuickStudy guides to have a complete power-user reference set. 6 page laminated reference guide includes: Conditional Formats Highlighting Rules Data Bar, Color Scale & Icon Set Formats Managing Conditional Formats Filer Data Using Slicers What-If Analysis Analyzing Data Using Scenarios Calculating Alternatives Using Data Tables Calculating Target Values Using Goal Seek Finding Optimal Values Using Solver Pivot Tables & Pivot Charts Timelines Excel Data Model Data Validation Sparklines Suggested uses: Workspace - flat for easy storage and access at a moments notice to find a function you need to use, or to jog your memory for a function you do not use often Company Training - reduce help-desk calls and keep productivity flowing for a team or for your entire company Students/Professors - make lives easier for students in many majors needing Excel for data management and calculation
ISBN: 9781423246657Publication Date: 2021-05-01
