Catalog Search Results
61) Master Your Data with Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow
Author
Description
Power Query is the amazing new data-cleansing tool in both Excel and Power BI Desktop. Do you find yourself performing the same data cleansing steps day after day or month after month? Power Query will make it faster to clean your data the first time and a single click to clean your data every time after that. While Power Query is powerful, the interface is subtle - there are tools hiding in plain sight that are easy to miss. Go beyond the obvious...
Author
Description
LibreOffice Calc provides all power of expensive commercial programs without the cost.
This short and sweet beginner's guide to LibreOffice Calc takes you from your first steps to a competent user capable of adding, modifying and developing spreadsheets, doing analysis, creating formulas and charts.
Calc can provide • Sophisticated analysis tools • Easy to use interface • Powerful chart, image, and drawing handling • Beautiful looking spreadsheets...
Author
Description
Are you looking to unlock the full potential of Microsoft Excel? Dive into "Excel: A Comprehensive Guide," your ultimate companion on the journey to becoming an Excel expert.In the world of data analysis, financial modelling, and spreadsheet management, Excel reigns supreme. This meticulously crafted guide is your key to harnessing the incredible power of this versatile software. Whether you're a beginner eager to learn the basics or an experienced...
Author
Description
In this book one can find many artworks created by Picasso between 1881 and 1914. The first style of the artist was influenced by the works of El Greco, Munch and Toulouse-Lautrec, artists that he discovered when he was a student in Barcelona. Picasso, fascinated by the psychological expression during his Blue period (1901-1904), expresses his own mental misery: his genre paintings, still-lifes and portraits were full of melancholy. Later, Picasso...
Author
Description
The essential guide for getting started with Power BI. Power BI is an amazing cloud-based business analytics service provided by Microsoft that allows people to transform data into rich, interactive visual reports that presents a 360-degree business view and improves business decision making. This book is designed to get the Excel analyst started with Power BI, touching on Power Query and Power Pivot.
Author
Description
This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include data quality, validation, perfectly sorting with one click every time, matching lists of data, data consolidation,...
Author
Description
Are you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you.
Learn the basics of Excel, including a comprehensive review of every tab of the Excel Ribbon. See how to best display your data for maximum impact with formatting tools, Data Tables,...
Author
Description
Learn the basics of Microsoft Excel, Word, and PowerPoint 365 today with this collection of titles from the Excel 365 Essentials, Word 365 Essentials, and PowerPoint 365 Essentials series by M.L. Humphrey whose Microsoft books have been called "easy to follow", "a great introduction for new users", and "extremely helpful". Contains: Excel 365 for Beginners, Word 365 for Beginners, and PowerPoint 365 for Beginners.
Author
Description
Découverte d'OpenOffice CALC.
Ce livre s'intéresse aux macros que vous pouvez enregistrer dans OpenOffice CALC. En réalité, une macro est une procédure BASIC que vous modifiez dans un environnement spécifique de programmation. Vous pouvez ainsi créer des applications personnalisées pour contrler finement des interactions dans le tableur. Vous apprendrez également à développer des boîtes de dialogue pour faciliter la gestion des informations....
Author
Description
Dans ce guide captivant, plongez dans l'univers dynamique des chatbots et découvrez comment ils redéfinissent la manière dont nous interagissons en ligne. Du socle conceptuel à la mise en œuvre pratique, chaque chapitre offre des conseils stratégiques, des études de cas éclairantes et des outils essentiels pour créer des chatbots efficaces. Explorez les fondamentaux de la conception conversationnelle, intégrez l'intelligence artificielle...
Author
Description
For decades, our relationship with workplace technology has been, in a word, complicated. The pandemic only made it more so.
The stats are astonishing. Two in three employers cannot find qualified candidates to fill their open IT positions. By 2024, the deficit of software developers in the US alone will hit 500,000. Supply and demand for techies are out of whack and, most alarmingly, there's no end in sight.
The effects of this labor market imbalance...
Author
Description
Libro especializado que se ajusta al desarrollo de la cualificación profesional y adquisición del certificado de profesionalidad "ADGG0508. OPERACIONES DE GRABACIÓN Y TRATAMIENTO DE DATOS Y DOCUMENTOS". Manual imprescindible para la formación y la capacitación, que se basa en los principios de la cualificación y dinamización del conocimiento, como premisas para la mejora de la empleabilidad y eficacia para el desempeño del trabajo.
73) Excel VBA - A Step-By-Step Comprehensive Guide on Excel VBA Programming Tips and Tricks for Effectiv
Author
Description
If you want to take Excel to the next level, and improve your knowledge in VBA, you should learn how to implement the tools and functions that VBA offers in your work.
If your aim is to improve and automate processes using Excel VBA, you have come to the right place.
Over the course of the book, you will gather information on a wide array of tools and Excel options. The book will take you through some facts about Excel VBA and will also leave you...
74) Organización y operaciones con hojas de cálculo y técnicas de representación gráfica de documento
Author
Description
Libro especializado que se ajusta al desarrollo de la cualificación profesional y adquisición del certificado de profesionalidad "ADGG0108 - ASISTENCIA A LA DIRECCIÓN". Manual imprescindible para la formación y la capacitación, que se basa en los principios de la cualificación y dinamización del conocimiento, como premisas para la mejora de la empleabilidad y eficacia para el desempeño del trabajo.
Author
Description
Microsoft's revolutionary Power Pivot is a tool that allows users to create and transform data into reports and dashboards in new and much more powerful ways using the most-used analytical tool in the world: Excel. Written by a member of Microsoft's Power Pivot team and one of the leading Power Pivot bloggers, this guide to the business analysis resource follows Jim, a fictional business analyst, as he attempts to create a dashboard report for his...
Author
Description
While you can manipulate Excel to a fair degree through the use of formulas alone, there are always going to be tasks that require you to move and sort data in ways that are limited through the use of this knowledge alone. In these situations, it will generally be much more efficient time-wise to just create a program that can automate the task you are attempting. If you like the sound of this but don't know what steps to take to make it a reality,...
Author
Description
Creating tables in Excel allows for easier formatting and reporting, but the new syntax that it implies can be intimidating to the uninitiated. In this guide, one of the developers of the official Microsoft Excel 2013 templates-all of which employ tables-helps introduce readers to the multiple benefits of tables. The book begins by explaining what tables are, how to create them, and how they can be used in reporting before moving on to slightly more...
Author
Description
Too many businesses are overlooking a game-changing opportunity.
Microsoft Excel, if used effectively, can transform your business and free up your invaluable time.
Throughout these pages, we will be following Matt, a business owner just like you, as he discovers a wealth of practical and efficient solutions to his most pressing business needs.
Taken from over twenty years of Excel training, this guide will enable you to unleash the power in your...
79) Introduction To Financial Modelling: How to Excel at Being a Lazy (That Means Efficient!) Modeller
Author
Description
If you have had little formal training in developing financial forecasts in Excel or have ever burnt the midnight oil trying to get a Balance Sheet to balance, then this book is for you. A simple walkthrough of the common perils and pitfalls of financial modelling, this book constructs a solid foundation to build upon (pun most definitely intended). Taking little for granted, Liam examines the common Excel functions and functionalities necessary,...
Didn't find it?
Can't find what you are looking for? Try our Materials Request Service. Submit Request