Excel Basics In 30 Minutes


Book Description

Do you want to learn Microsoft Excel, for a career boost, or to better handle numbers, lists, and data? This popular Excel tutorial covers basic concepts, formatting, AutoFill, formulas, functions, sorting, filtering, collaboration, and charts. Examples apply to Excel 2019, Excel Online, Excel mobile apps, and Google Sheets.




Excel Basics In 30 Minutes (2nd Edition)


Book Description

Do you want to learn how to use Microsoft Excel, for a career boost, or to better handle numbers, lists, and other data? This popular Excel user guide covers basic spreadsheet concepts, including the Excel interface, formatting, functions, formulas, AutoFill, charts, print, filtering, and sorting. Step-by-step instructions are easy to follow, and include many examples. Instructions apply to recent versions of Microsoft Excel, Excel Online, Excel for Android and iOS, and Google Sheets.




Google Drive and Docs in 30 Minutes (2nd Edition)


Book Description

Updated in 2018! The top-selling guide to Google’s free online office suite is now available in a revised and expanded second edition. Thirty minutes is all you'll need to get up to speed with Google Drive, Google Docs, Google Sheets, and Google Slides, the free online productivity suite and alternative to Microsoft Office. Millions of people use the software every day. You can use Drive, Docs, Sheets, and Slides to perform the following tasks: • Write letters and reports • Crunch numbers and create online data entry forms • Give presentations • Collaborate online with classmates and colleagues • Convert Microsoft Office documents to Google formats, and vice versa • Print documents, drawings, and spreadsheets • Export PDFs • Make pie charts, bar charts, and simple tables • Publish documents and spreadsheets online using the new Google Sites After covering registration, file creation and other basics, Google Drive and Docs In 30 Minutes (2nd Edition) zeroes in on the most important time-saving tips and productivity tools. Highlights include: • Converting files between Microsoft Office and Google formats. • Best practices for organizing files in Google Drive. • What to expect with collaboration and sharing. • The pros and cons of Google’s mobile apps for Drive, Docs, Sheets, and Slides. • Accessing older versions of files. • How to publish your documents to the Web for colleagues or members of the public to view. • Functions, sorting and filtering in Google Sheets (with examples). • Using Google Forms to gather data. • Google Slides: Is it a suitable alternative to Microsoft PowerPoint? • Working with offline files. • Downloading third-party apps. The tone of Google Drive and Docs In 30 Minutes is friendly and easy to understand, with lots of step-by-step instructions, screenshots, and examples. The guide can be used by anyone with a PC, Mac, or Chromebook. It also includes instructions for using Drive, Docs, Sheets, and Slides on Android and iOS phones and tablets. Google Drive and Docs In 30 Minutes, 2nd Edition is authored by Ian Lamont, an award-winning technology and business journalist. He has written several books in the "In 30 Minutes" series, including Dropbox In 30 Minutes, Twitter In 30 Minutes, and Excel Basics In 30 Minutes. Here's what readers are saying about Google Drive & Docs In 30 Minutes: “I am so glad this was made! I've been using Google Docs for a while now and have been encouraging my teacher colleagues to do so as well to facilitate collaboration. It has become my go-to text book to help new users understand quickly. If you're new to Google Drive or Google Documents, this will help you. If you're experienced, and want something to help those who come to you with questions, this is a nice tool to help them remember what you show them. I highly recommend it.” “I just got a new position that requires record keeping. Having used Google Docs in the past, I decided to update my knowledge. I googled "Docs for dummies" and this was one of the results. I liked the concept that the title implies - a concise guide that will distill what I need and allow me to complete a task quickly” “A clear and concise explanation of how to navigate your way through google docs.” “Excellent introduction to Google drive. Well researched, easy to read, nicely organized.”




Excel Basics In 30 Minutes (2nd Edition)


Book Description

"Written in plain English, with lots of step-by-step instructions and screenshots ... Instructions apply to recent versions of Excel including Excel 2013, Excel for Office 365 and Excel Online"--Publisher's description.




Google Drive and Docs In 30 Minutes (2nd Edition)


Book Description

All-new second edition of this popular Google Drive and Google Docs tutorial! Do you have 30 minutes to spare? It's all you'll need to get up to speed with Google Drive, Google Docs, Google Sheets, and Google Slides, the free online productivity suite and Microsoft Office alternative. Millions of people use the software every day on their computers and mobile devices. You, too, can use Drive, Docs, Sheets, and Slides to write reports, give presentations, crunch numbers, and collaborate online.




Slaying Excel Dragons


Book Description

A comprehensive guide to mastering Excel with shortcuts, data analysis, and advanced formulas. Perfect for all skill levels. Key Features Comprehensive coverage of Excel features and functions Practical examples and step-by-step instructions Focus on efficiency with keyboard shortcuts and advanced techniques Book DescriptionThis comprehensive guide is designed to elevate your Excel skills from beginner to advanced. Starting with the fundamentals, you'll learn how to navigate Excel's interface, use essential keyboard shortcuts, and manage data efficiently. As you progress, you'll dive into complex features like PivotTables, dynamic ranges, and advanced formatting, gaining the ability to handle intricate data tasks with ease. The guide also covers powerful formulas and functions, including VLOOKUP, INDEX/MATCH, and logical tests. These tools will empower you to automate calculations, perform detailed analyses, and streamline your workflow. Additionally, you'll explore Excel’s data analysis features, such as sorting, filtering, and creating dynamic charts, enabling you to present your data clearly and effectively. By the end of this book, you'll have a deep understanding of Excel's capabilities, equipped with the skills to tackle any spreadsheet challenge. Whether you're preparing for advanced data analysis or seeking to optimize your day-to-day tasks, this guide provides the knowledge and practical experience to make Excel work for you.What you will learn Master Excel's keyboard shortcuts Apply advanced formulas and functions Create and customize PivotTables Utilize data analysis features Format cells with conditional logic Create and edit complex charts Who this book is for This book is perfect for Excel users of all levels who want to improve their efficiency and data analysis skills. A basic understanding of Excel is recommended, but the book starts with foundational topics and builds to advanced features, making it accessible to beginners and valuable to advanced users alike.




Dropbox in 30 Minutes


Book Description

Thirty minutes is all the time you'll need to master the basics of Dropbox, a software application for storing and sharing photos, documents, spreadsheets, and other types of computer files. Using screenshots, step-by-step instructions, and plain English explanations, "Dropbox In 30 Minutes" will cut through the confusion. In just a half-hour, you'll understand how Dropbox works, and how to set up Dropbox on your desktop and phone. You'll also learn how to leverage Dropbox to perform the following types of tasks: Instant Backup: Files are automatically synchronized with your master Dropbox account, and changes are carried over to all of your computers. Even if your computer is damaged or lost, you'll still be able to access copies of the most recently synchronized files. Online Collaboration: Securely share a folder full of documents with coworkers who may be scattered across the country or across the globe. Photo Syncing: Using the Camera Uploads feature on the Dropbox mobile app, automatically sync the photos on on your phone to your PC/Mac -- without cables Whether you need to use Dropbox for work, school, or personal use, "Dropbox In 30 Minutes" is the perfect guide to get started. Read it when you're traveling, during your lunch break, or at home. A companion website contains videos and other free resources to help you better understand Dropbox.




Inside OLE


Book Description

OLE is a unified and extensible environment of object-based services with the overall purpose of enabling rich integration between components. As Microsoft's object technology, it represents major innovations in object-based programming, making it possible to create applications and software components with unprecedented capabilities. But with this power comes additional complexity and new programming paradigms. Inside OLE provides both a clear tutorial and a strong set of example programs, giving you the tools to incorporate OLE into your own development projects. Written by a member of the Microsoft OLE team, this book truly gives you the insider's perspective on the power of OLE for creating the next generation of innovative software. Inside OLE provides detailed coverage and reference material on OLE and object fundamentals: Objects and interfaces, connectable objects, custom components and the Component Object Model, and Local/Remote Transparency; storage and naming technologies: Structured storage and compound files, persistent objects, and naming and binding; data transfer, viewing, and caching: Uniform Data Transfer, viewable objects, data caching, OLE Clipboard, and OLE Drag and Drop; OLE Automation and OLE Property: Automation controllers; property pages, changes, and persistence; OLE Documents: OLE Documents and embedding containers; OLE Documents and local embedding servers; in-process object handlers and servers; linking containers; and in-place activation (visual editing) for containers and objects; and OLE Controls and the future of OLE: OLE Controls, future enhancements, and component software. If you're interested in fully exploring and understanding OLE and component software, there's no better source than Inside OLE.




Excel 2019 All-in-One For Dummies


Book Description

Make Excel work for you Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions—including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze, model, and visualize vast quantities of data from a variety of local and online sources. Get familiar with Worksheet design Find out how to work with charts and graphics Use Excel for data management, analysis, modeling, and visualization Make sense of macros and VBA If you’re a new or inexperienced user looking to spend more time on your projects than trying to figure out how to make Excel work for you, this all-encompassing book makes it easy!




Microsoft Azure Essentials - Fundamentals of Azure


Book Description

Microsoft Azure Essentials from Microsoft Press is a series of free ebooks designed to help you advance your technical skills with Microsoft Azure. The first ebook in the series, Microsoft Azure Essentials: Fundamentals of Azure, introduces developers and IT professionals to the wide range of capabilities in Azure. The authors - both Microsoft MVPs in Azure - present both conceptual and how-to content for key areas, including: Azure Websites and Azure Cloud Services Azure Virtual Machines Azure Storage Azure Virtual Networks Databases Azure Active Directory Management tools Business scenarios Watch Microsoft Press’s blog and Twitter (@MicrosoftPress) to learn about other free ebooks in the “Microsoft Azure Essentials” series.