Microsoft Office 2019 Step by Step


Book Description

This is learning made easy. Get more done quickly with Office 2019. Jump in wherever you need answers - brisk lessons and colorful screenshots show you exactly what to do, step by step. Covers Word, Excel, PowerPoint and Outlook Format Word documents for maximum visual impact Build powerful, reliable Excel workbooks for analysis and reporting Prepare highly effective PowerPoint presentations Use Outlook to organize your email, calendar, and contacts Includes downloadable practice files




The Ultimate Office Prank Book


Book Description

Making life in cubicle land a bit more fun, this book is a clever and amusing list of practical jokesùa list that will challenge even seasoned saboteurs to take risks and reap the awkward rewards. Whether itÆs filling the vending machine with a coworkerÆs desk supplies, attaching fishing wire to phones and keyboards, or putting Jello in the toilets, pranks have been an office staple since the first cubicle was born. Split into chapters labeled Entry-Level, Middle Management, and Executive, jokesters are entertained with 200+ increasingly dangerous pranks. Complete with Tips for Talking Your Way Out of Anything and a list of important phone numbers, including the fire and police departments and the American Bar Association, this book is the perfect humorous gift for a friend, family member, or coworker!




Microsoft Office Inside Out (Office 2021 and Microsoft 365)


Book Description

Conquer Microsoft Office—from the inside out! Dive into the Microsoft Office application suite—and really put its productivity tools and services to work for you! This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to make the most of Office's most powerful tools for productivity and decision-making. Renowned Office expert Joe Habraken offers a complete tour of Microsoft Office, with cutting-edge techniques and shortcuts for Word, Excel, PowerPoint, Outlook, Publisher, the 365 Online apps, and more. Discover how experts tackle today's key tasks—and challenge yourself to new levels of mastery. Create amazing content faster with Office's new features, tools, and shortcuts. Share, collaborate with, and secure Office files in the cloud. Organize, edit, and format complex documents with Microsoft Word. Build tables of contents, captions, indexes, and footnotes that automatically update. Efficiently enter and manage data in Excel workbooks, and format it for easy understanding. Build flexible, reliable Excel workbooks with formulas and functions—including XLOOKUP and other enhancements. Integrate data from external sources, including stock and currency data, and Wolfram curated knowledge. Transform data into insight with Pivot Tables and Excel charts — including new recommended charts and the Quick Analysis gallery. Quickly create presentations with PowerPoint themes, Reuse Slides, and Libraries. Build more impactful slides with advanced formatting, SmartArt, animation, transitions, media, and free stock images. Use PowerPoint tools to present more effectively—in person or online via Microsoft Teams. Systematically improve email productivity and security with Outlook. Manage appointments and tasks and quickly plan meetings.




Office 365 Essentials


Book Description

Leverage Office 365 to increase your organization's efficiency by managing users, domains, licenses, and much more in your organization with most powerful subscription software. Key Features Get acquainted with the basics of Office 365 Configure and manage workloads efficiently using Office 365 A comprehensive guide covering every aspect of planning, and managing this multifaceted collaboration system. Book Description Office 365 is suite of advanced collaboration tools used by many well known organizations and their system administrators. This book starts with an introduction to Office 365 and its basic fundamentals. Then we move towards workload management and deployment. You will delve into identities, authentications, and managing office 365. We also cover concepts such as collaboration with Microsoft teams and tools such as Delve and Skype for collaboration. Towards the end of the book, you'll master monitoring and security concepts. By the end of this book, you will have hands-on experience working with Office 365 and its collaboration tools and services What you will learn Learn how to implement Office 365 from scratch and how to use best practices to be a successful Office 365 professional Understand Microsoft productivity services to take your organization or business to the next level by increasing productivity. Learn how workloads and applications interact and integrate with each other Learn to manage Skype for Business Online Get support and monitor service health with Office 365 Manage and administer identities and groups efficiently Who this book is for If you are working as a system administration or an IT professional and are keen to learn the fundamentals of Office 365, then this book is for you. No prior knowledge of office 365 is necessary.




Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)


Book Description

Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad help you automate Excel tasks to get more done, faster than ever. Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Microsoft Excel. You'll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you will: Quickly master Excel macro development Work more efficiently with ranges, cells, and formulas Generate automated reports and quickly adapt them for new requirements Learn to automate PivotTables to summarize, analyze, explore, and present data Leverage more of Excel VBA's power with classes, collections, and Advanced Filter Make the most of User-Defined Functions (UDFs), including new LAMBDA functions Build sophisticated UserForm custom dialogs to collect data from other Excel users Integrate data from the Internet, Access and SQL Server databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Extend Excel's power by controlling other Office programs and Windows itself Create Office Add-ins to expand worksheet functionality or streamline retrieval of external information Get started creating brand-new TypeScript applications for Excel Online 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




The New Corner Office


Book Description

Drawing on her 18 years of experience working remotely, plus original interviews with managers, employees, and free agents who've perfected their remote routines, Laura Vanderkam shares strategies for productivity, creativity, and health in the new corner office. How do you do great work while sitting near the same spot where you watch Netflix? How can you be responsive without losing the focus necessary for getting things done? How can you maintain and grow your network when you spend less time face to face? The key is to detach yourself from old ways of working and adopt new habits to match your new environment. Long before public health concerns pushed many of us indoors, some of the most successful people fueled their careers with carefully perfected work-from-home routines. Drawing on those profiles and her own insights, productivity expert and mother of five Laura Vanderkam reveals how to turn "being cooped up" into the ultimate career advantage. Her hacks include: • Manage by task, not time. Going to an office for 8 hours makes you feel like you've done something, even if you haven't. Remote workers should set 3-5 ambitious goals for each day and consider the work day done when these are crossed off. • Get the rhythm right. A well-planned day features time for focused work, interactive work, and rejuvenating breaks. In place of a commute, a consciously chosen shut down ritual keeps work from continuing all night. • Nurture connections. Wise remote workers can build broader and more effective networks than people sitting in the same cubicle five days a week. Whether you're an introvert or an extrovert, a self-starter or someone who prefers detailed directions, you can do your clearest thinking and deepest work at home--and have more energy left over to achieve personal goals or fuel bigger professional ambitions. In fact, soon you might find it hard to imagine working any other way.




Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)


Book Description

Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winston's hands-on, scenario-focused guide helps you use today's Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts. Solve real problems with Microsoft Excel—and build your competitive advantage Quickly transition from Excel basics to sophisticated analytics Use recent Power Query enhancements to connect, combine, and transform data sources more effectively Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music Build more sophisticated and compelling charts Use the new XLOOKUP function to revolutionize your lookup formulas Master new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries Illuminate insights from geographic and temporal data with 3D Maps Improve decision-making with probability, Bayes' theorem, and Monte Carlo simulation and scenarios Use Excel trend curves, multiple regression, and exponential smoothing for predictive analytics Use Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook




Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)


Book Description

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




Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)


Book Description

Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if you've never created a pivot table before, this book will help you leverage all their flexibility and analytical power— including important recent improvements in Microsoft 365 Excel. Drawing on more than 30 years of cutting-edge Excel experience, MVP Bill Jelen (“MrExcel”) shares practical “recipes” for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks you'll find nowhere else. By reading this book, you will: Master easy, powerful ways to create, customize, change, and control pivot tables Transform huge datasets into clear summary reports Instantly highlight your most profitable customers, products, or regions Use the data model and Power Query to quickly analyze disparate data sources Create powerful crosstab reports with new dynamic arrays and Power Query Build geographical pivot tables with 3D Maps Construct and share state-of-the-art dynamic dashboards Revamp analyses on the fly by dragging and dropping fi elds Build dynamic self-service reporting systems Share your pivot tables with colleagues Create data mashups using the full Power Pivot capabilities in modern Excel versions Generate pivot tables using either VBA on the Desktop or Typescript in Excel Online Save time and avoid formatting problems by adapting reports with GetPivotData Unpivot source data so it's easier to work with Use new Analyze Data artificial intelligence to create pivot tables




The Office BFFs


Book Description

INSTANT #1 NEW YORK TIMES BESTSELLER An intimate, behind-the-scenes, richly illustrated celebration of beloved The Office co-stars Jenna Fischer and Angela Kinsey’s friendship, and an insiders' view of Pam Beesly, Angela Martin, and the iconic TV show. Featuring many of their never-before-seen photos. Receptionist Pam Beesly and accountant Angela Martin had very little in common when they toiled together at Scranton’s Dunder Mifflin Paper Company. But, in reality, the two bonded in their very first days on set and, over the nine seasons of the series’ run, built a friendship that transcended the show and continues to this day. Sharing everything from what it was like in the early days as the show struggled to gain traction, to walking their first red carpet—plus exclusive stories on the making of milestone episodes and how their lives changed when they became moms—The Office BFFs is full of the same warm and friendly tone Jenna and Angela have brought to their Office Ladies podcast.