Using Microsoft Office

We've all been there before, staring at a computer screen with no idea what to do - don't worry Using Excel 2019 is here to help. Written by best-selling technology author, lecturer, and computer trainer Kevin Wilson, Using Excel 2019 is packed with easy to follow instructions, photos, illustrations, helpful tips and video demos. Updated to cover Microsoft Excel 2019, this guide will show you how to: Start Excel and find your way around the ribbon menu Build spreadsheets, enter data, import data and format text Add borders, text orientation, colours and highlights Use conditional formatting Build formulas to manipulate data Use built in functions to add up, average and count data Use Lookup and IF functions Create charts from spreadsheet data and customise the layout Work with workbooks, open, save, and print workbooks Basic File Management Understand data analysis using goal seek, scenarios, forecasts, Build pivot tables and pivot charts Use data validation techniques to help keep data entry accurate and more... You'll want to keep this edition handy as you make your way around Microsoft Excel. Have Fun!

Unlock the full potential of Microsoft Publisher with this comprehensive guide written by best-selling technology author and trainer Kevin Wilson. Whether you're beginning with the basics or an experienced user aspiring to enhance your skills, Using Microsoft Publisher is your indispensable guide to navigating and mastering Microsoft Publisher. Using Microsoft Publisher is packed with easy-to-follow instructions, full color illustrative photos, screenshots, and helpful tips, including video demos for a hands-on learning experience. In this guide you'll learn: • Getting Started with Publisher: Learn how to navigate around the main user interface, customize your workspace, and create shortcuts for quick access. • The Ribbon Menu: Learn how to use the ribbon menu's functionalities and explore the Home, Insert, Page Design, and other crucial tabs. • Building a New Design: Discover the fundamentals of good design, using contrast, repetition, alignment, and proportion. Understand how these principles can improve your publications. • Creating Publications: Learn how to create new publications, page sizes, orientations, and understanding margins. • Enhancing with Graphics: Master the art of adding and editing images, clip art, and shapes. Learn text wrapping techniques and image adjustments for a professional look. • Managing Publications: Learn how to save documents in various formats such as PDF, as well as opening saved projects, and setting up page layouts effectively. • Advanced Publisher Features: Explore advanced topics such as creating multipage spreads, using mail merges, and designing with tables and guides. • Exercises and Real-World Applications: Practice with hands-on exercises and practical examples to apply your skills effectively. This guide is an indispensable resource for learning the intricacies of Microsoft Publisher, designed to enhance your abilities and provide you with the expertise necessary to craft professional-quality publications with ease. So scroll up and get your copy of Using Microsoft Publisher today!

Unlock the full potential of Microsoft Excel with this comprehensive guide written by best-selling technology author and trainer Kevin Wilson. Whether you're beginning with the basics or an experienced user aspiring to enhance your skills, Using Microsoft Excel is your indispensable guide to navigating and mastering one of the world's leading spreadsheet applications. Using Microsoft Excel is packed with easy-to-follow instructions, full color illustrative photos, screenshots, and helpful tips, including video demos for a hands-on learning experience. In this guide you'll learn: • User-Friendly Navigation: Start with the basics of the Microsoft Excel's interface and learn how to use the ribbon menu and backstage view. • Spreadsheet Mastery: Learn how to create spreadsheets, manage data entry, and master text formatting. • Stylish Data Presentation: Learn how to style and present your work in Microsoft Excel with sophisticated formatting options, borders, color-coding, and conditional formatting. • Formulas and Basic Functions: Construct custom formulas and use built in functions to calculate, analyze, and transform your data. • Advanced Excel Functions: Go beyond the basics with Lookup, Index, IF/Date/Text/nested functions, cell referencing and other advanced tools to streamline your data processing. • Compelling Charts and Analytics: Transform data from Microsoft Excel spreadsheets into informative charts and master layouts to visually communicate your data. • Efficient Workbook Management: Manage your Microsoft Excel environment effectively. Learn about file management and workbook navigation as well as printing and exporting worksheets. • In-Depth Data Analysis: Explore advanced tools such as goal seek and scenarios for professional-level data analysis. As well as a look at the ToolPak and Solver add-ins. • PivotTable Proficiency: Become adept at creating pivot tables and pivot charts for dynamic data breakdowns and insights. • Excel Extensions: Extend the functionality of Microsoft Excel with various add-ins to meet your specific analytical needs. • Macros & VBA Introduction: Step into the world of Macros and VBA to automate tasks and boost your productivity. • Seamless Collaboration: Discover strategies for effective teamwork in Microsoft Excel with workbook sharing, real-time co-authoring and commenting. • Flawless Data Validation: Ensure data integrity with various validation techniques, essential for accurate data management. This guide is an indispensable resource for learning the intricacies of Microsoft Excel, designed to enhance your abilities and provide you with the expertise necessary to craft professional-quality spreadsheets with ease. So scroll up and get your copy of Using Microsoft Excel today!

We've all been there before, staring at a computer screen with no idea what to do - don't worry Using Word 2019 is here to help. Written by best-selling technology author, lecturer, and computer trainer Kevin Wilson, Using Word 2019 is packed with easy to follow instructions, photos, illustrations, helpful tips and video demos. Updated to cover Microsoft Word 2019, this guide will show you how to: Start Word and find your way around the ribbon menu Format text: bold, italic, underlined, strike, and super/sub script Align, highlight and change text colour Cut, copy, paste and using the clipboard Use headers, footers, columns, watermarks, and cover pages Insert page numbers, contents pages and indexes Add page borders, and page breaks Sort text, adjust line spacing, and tabs, as well as bullet and numbered lists Save, print, share and collaborate with others Insert SmartArt, charts, tables, equations and special characters Add images, crop, wrap text and use effects Use pre-designed templates, and build your own Mail merge letters, labels and envelopes Check spelling and grammar Improve your work with thesaurus and insights You'll want to keep this edition handy as you make your way around Microsoft Word. Have Fun!

Unlock the full potential of Microsoft Word with this comprehensive guide written by best-selling technology author and trainer Kevin Wilson. Whether you're a beginner or experienced user, this guide is updated to cover the latest features and will help you navigate and master Microsoft Word quickly and easily. Using Microsoft Word is packed with easy-to-follow instructions, full color illustrative photos, screenshots, and helpful tips, including video demos for a hands-on learning experience. In this guide you'll learn: • Easy Navigation: Start by opening Microsoft Word, mastering the ribbon menu and user interface for a streamlined workflow. • Text Formatting: Learn to apply styles such as bold, italic, and underline for impactful text presentation, as well as applying font sizes, colors and paragraph styles. • Document Editing Skills: Gain proficiency with cut, copy and paste, and effective clipboard use in Microsoft Word. • Professional Document Design: Implement advanced design elements such as headers, footers, and watermarks in Microsoft Word. • Structured Documents: Organize your work with page numbers, page breaks, tables of contents, and indexes. • Visual Enhancements: Improve the readability of your Microsoft Word documents with page borders, line spacing, text alignment, and tab adjustments. • List Management: Create bullet and numbered lists for clear content presentation. • Team Collaboration: Utilize Microsoft Word's collaboration tools for effective teamwork on documents. • Incorporate Graphics and Charts: Enrich your documents with Equations, WordArt, SmartArt, charts, shapes, and images. • Templates: Use pre-designed templates and learn how to create your own. • Mail Merge: Execute mail merges for letters, labels, and envelopes efficiently in Microsoft Word. • Proofing and Language Tools: Ensure linguistic accuracy with Microsoft Word's spell check and grammar tools. Learn to save time with autocorrect and autotext. • Content Enrichment: Enhance your work with thesaurus and researcher. • Automation: Learn how to record and use macros to perform repetitive tasks This guide is an indispensable resource for learning the intricacies of Microsoft Word, designed to enhance your abilities and provide you with the expertise necessary to craft professional-quality documents with ease. So scroll up and get your copy of Using Microsoft Word today!