Catalog Search Results
Author
Description
Sick of seeing "#VALUE!"? Have you never worked with Microsoft Excel before or do you already know basic functions and elements? Would you like to master the most important features and functions of Microsoft Excel? Well, if you feel addressed by even one of these questions, this book is the right choice for you! Learn the essential functions of Microsoft Excel (applicable for the versions: 2019, 2016, 2013, 2010 and Office 365). Whether you want...
Author
Description
The new office package is continuously changing. New features are supplied frequently and provide new possibilities to users and administrators alike. This booklet supplies all novelties in Word, Excel, Outlook and PowerPoint-and entirely the novelties. It makes it easy for you to make up your mind what's in for you and what new possibilities will be at your disposal. You remain on top of the game!
Author
Description
Did you know that there was a lot more you can do with Excel than just manipulating and entering data? Were you looking for a way to learn the different strategies and techniques you can apply in Excel? If you did, you must definitely read this book.You would have gathered the basic information about Microsoft Excel, and how you can manipulate or format data in Excel. You would have also gathered information on how you can use different statements...
Author
Description
Author Oz Du Soleil's area of frustration with Excel is cleaning data. From his earliest days with Excel, he has found himself constantly needing to fix names that are ALLCAPS, peel addresses away from phone numbers, and fixing all the many other things that prevent data from being useful. In this intro to Power Query, Oz shows you five core techniques in Excel Power Query: Splitting data, Filling blanks, Joining data sets, grouping and summarizing,...
Author
Description
Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before. Written by the world's foremost PowerPivot blogger and practitioner, this guide is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience in a simple, step-by-step manner tailored to its learning style. The techniques presented allow...
Author
Description
Un outil simple d'utilisation, accessible à tous et destiné aux activités quotidiennes.
Ce livre s'intéresse à CALC, le tableur gratuit d'OpenOffice. Pour bien commencer l'apprentissage, vous devez étudier les fondamentaux comme les différents menus proposés dans le logiciel, la gestion des cellules, la gestion des lignes et des colonnes, le formatage des différentes informations, l'impression mais aussi la réalisation de calculs simples...
Author
Description
Microsoft Excel used to rule them all. It didn't matter what computer or operating system you had- if you needed to create a spreadsheet, you used Excel.
Times have changed! Today, there are many spreadsheet solutions out there. Some, like Google Sheets, are pretty barebones, and others, like Excel, feel at times feature creep-there are just so many options, it's easy to get lost. If you use a Mac, iPad, or iPhone, then you have a third option that's...
Author
Description
If you have an Excel workbook that needs to regularly harvest data from a web page, this book is for you. The book covers various methods for getting data from the web, from VBA to Selenium to Power Query. Addresses the complexities of getting data from the Modern Web and the lack of VBA support in Microsoft Edge.
Author
Description
For 40-some-odd years, the world of spreadsheets has been, ruled by one king: Microsoft Excel. Sure, there were far away challengers that tried to overtake the beast, I'm looking at you, Lotus 1-2-3, but none have come close to dethroning the powerful tool... until Google Sheets.
So what is Google Sheets? It's a cloud-based spreadsheet. Think Excel, but online. "But Excel is online," you say. Yes! But, Google was there first, and really has the advantage...
Author
Description
Excel's LOOKUP functions are some of the most popular and useful functions in Excel. VLOOKUP has been a staple function for forever, but the new XLOOKUP function is even more powerful and can replace not only VLOOKUP but also HLOOKUP and potentially other functions such as INDEX and MATCH.* * *This book is part of the Easy Excel 365 Essentials series of titles. These are targeted titles that are excerpted from the main Excel 365 Essentials series...
Author
Description
Pivot tables are one of the most valuable tools in Microsoft Excel. They let you quickly summarize a large data table and slice and dice that data any way that you want. You can even create a dynamic chart from that data using pivot charts.
This book provides a detailed introduction to using pivot tables as well as pivot charts, although it does presume prior familiarity with regular charts in Excel.
This book is part of the Easy Excel 365 Essentials...
Author
Description
Contains Almost 200 Screenshots. For Excel 365 or Excel 2021 Users.
Once you've mastered the basics of Microsoft Excel there are a number of additional tools that can take your use of Excel to the next level.
In this book we cover three of the biggest ones: conditional formatting, charts, and pivot tables (including pivot charts).
In addition we cover a handful of tricks such as removing duplicate values, converting text to columns, and grouping...
Author
Description
From the author of the original Excel Essentials series which has been described as "perfect for Excel newbies." Microsoft Excel is an incredibly powerful tool, both for business and personal use. From budgeting to data analysis, it can do it all. But sometimes learning Excel can be a little overwhelming. It's so powerful, it's hard to know where to focus. That's where this collection comes in. Excel 365 for Beginners gives you what you need to know...
Author
Description
A detailed guide to learn hacks of office 365
This guide will help you to make good powerpoint presentations along with basic office tips.
Based on detailed research this book will teach you how to:
- Use powerpoint
- Make good powerpoint presentations
- Use slideshow and transitions
- Use 'BING' along with office
- Use clutter with office
- Use delve
- Team Set up for group projects
- Take a poll
- Use gigjam
- Sync Skype plugin
If you want to...
Author
Description
Microsoft Excel is an incredibly powerful program that allows for the storage and manipulation of vast amounts of data. But it's much easier to use if you know the tricks and shortcuts that will speed up your data input and manipulation. That's what this short book contains. Control shortcuts, tricks, and tips that will help you input data the way you want it and then quickly move through that data and analyze it.
Author
Description
The IF functions are some of the most powerful functions in Microsoft Excel. With IF, IFS, COUNTIFS, SUMIFS, AVERAGEIFS, MINIFS, and MAXIFS you can perform almost any conditional calculation you want.
Note that many of the functions covered in this book are functions that were not available in earlier versions of Microsoft Excel, so if you're using a version of Excel prior to Excel 2019, you may want the original IF Functions title that is part of...
Author
Description
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...
Author
Description
If you're going to spend any amount of time working in Excel then you need to learn how to format cells, because inevitably your column won't be as wide as you want it to be or you'll want to have a cell with red-colored text or to use bolding or italics or something that isn't Excel's default.
That's what this book is for. It's a listing of different things you might want to do to format your data in Excel.
This book is part of the Easy Excel 365...
Author
Description
Excel is an incredibly powerful tool, but getting started with it can be a bit daunting. In this guide, M.L. Humphrey will walk you through how to use Excel to calculate what you’ll earn, spend, own, and owe, the four key elements you need to know to manage your money.
The focus of this guide is on how to use addition, subtraction, multiplication, and division to calculate these values. The guide is written as a companion to Budgeting for Beginners...
Didn't find it?
Can't find what you are looking for? Try our Materials Request Service. Submit Request