Описание: Learn how to create Pivot Tables quickly and easily with this step-by-step guide
Updated for Microsoft(R) Excel(R) 2016 This book provides easy to follow step-by-step examples with screenshots demonstrating how to create Pivot Tables and basic Dashboards. In just a few short hours, you'll learn how to:
Organize and summarize data
Format & filter Pivot Table results
Create Pivot Charts
Display averages & percentages
Group data into predefined ranges
Use Slicers
Rank results
Apply calculated fields
Create Pivot Table reports from imported files
And more
In addition to the above, you will also learn how to create, format, and update a basic Dashboard using Pivot Table data. Including how to incorporate charts and performance symbols into your reporting.
A great resource for:
Business Analysts
Data Analysts
Financial Analysts
Administrative and Support staff
Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using one of Microsoft(R) Excel's(R) best features
Автор: Lambert Joan, Frye Curtis Название: Microsoft Excel Step by Step (Office 2021 and Microsoft 365) ISBN: 0137564279 ISBN-13(EAN): 9780137564279 Издательство: Gazelle Book Services Рейтинг: Цена: 5474.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: The quick way to learn Microsoft Excel!
This is learning made easy. Get more done, more quickly, with Microsoft Excel. Jump in wherever you need answers--brisk lessons and detailed screenshots show you exactly what to do, step by step.
Quickly set up workbooks, enter data, and format it for effective visual impact
Perform calculations and find and correct errors
Manage, filter, summarize, validate, reorder, and combine data
Identify trends, illustrate processes and relationships, and dynamically analyze data
Build sophisticated forecasts, key performance indicators (KPIs), and timelines
Visualize data with customized charts, 3D maps, and other powerful tools
Import, process, summarize, and analyze huge data sets with PowerPivot and Power Query
Use powerful Excel Data Models for advanced business intelligence
Автор: Habraken Joe Название: Microsoft Office Inside Out (Office 2021 and Microsoft 365) ISBN: 0137564090 ISBN-13(EAN): 9780137564095 Издательство: Gazelle Book Services Рейтинг: Цена: 7034.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: 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.
Автор: Humphrey M. L. Название: Microsoft Office for Beginners ISBN: 1950902234 ISBN-13(EAN): 9781950902231 Издательство: Неизвестно Рейтинг: Цена: 7348.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание:
A perfect resource for students or those new to working with Microsoft Office.
Learn the basics of Microsoft Excel, Word, and PowerPoint today with this collection of titles from the popular Excel Essentials, Word Essentials, and PowerPoint Essentials series by M.L. Humphrey. Learn Microsoft Office with titles that users have called "easy to follow", "a great introduction for new users", and "extremely helpful".
Contains: Excel for Beginners, Word for Beginners, and PowerPoint for Beginners.
Автор: Humphrey M. L. Название: Microsoft Office for Beginners ISBN: 1950902196 ISBN-13(EAN): 9781950902194 Издательство: Неизвестно Рейтинг: Цена: 5508.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание:
A perfect resource for students or those new to working with Microsoft Office.
Learn the basics of Microsoft Excel, Word, and PowerPoint today with this collection of titles from the popular Excel Essentials, Word Essentials, and PowerPoint Essentials series by M.L. Humphrey. Learn Microsoft Office with titles that users have called "easy to follow", "a great introduction for new users", and "extremely helpful".
Contains: Excel for Beginners, Word for Beginners, and PowerPoint for Beginners.
Автор: Oluwa Shmuel Название: Hands-On Financial Modeling with Microsoft Excel 2019 ISBN: 1789534623 ISBN-13(EAN): 9781789534627 Издательство: Неизвестно Рейтинг: Цена: 7171.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: This book aims to provide a gateway to financial modeling through easy to follow examples in Excel 2019. It will explore the process of modeling starting from a thorough understanding of the project to gathering historical information and arriving at assumptions. Good modeling practices are emphasized and demonstrated throughout the book.
Revised third edition for Excel 2019 Here's your chance to finally learn how to use Microsoft Excel In a single sitting, this quick and easy user guide will help you learn MS Excel basics, from navigating the home screen to working with formulas and charts. It's a great Excel tutorial that will help you in the office, at school, or even at home. Excel Basics In 30 Minutes, 3rd Edition is written in plain English, with lots of step-by-step instructions and screenshots that demonstrate exactly what to do. This MS Excel tutorial references Excel 2019, but most of the step-by-step instructions apply to earlier versions of MS Excel released as part of the Microsoft Office and Office 365 suites, including Excel 2016. If you don't own Excel, the book explains how to use two free online spreadsheets programs: Excel Online and Google Sheets (part of the Google Drive online office suite). The book also explains how to use the Excel mobile apps for Android and iOS.
Topics covered
Excel screen layout, cells, and terminology
Excel 2019 vs. Excel Online vs. Google Sheets
Excel for iOS and Excel for Android
Basic Excel formatting
AutoFill
Excel formulas and functions
How to make charts in Excel
Sorting and filtering
Collaboration and sharing
Exporting PDF, CSV, and other forms
Printing tips
Excel import and export formats (PDF, .CSV, .TSV, text, etc.)
This is not an Excel bible, but rather a basic Excel tutorial and reference that answers the core questions that any new Excel user will have:
What is a spreadsheet?
What are cells?
What is the button with the Greek letter for?
How can Excel spreadsheets create basic financial projections?
How can certain data in a worksheet be highlighted?
How can data be alphabetized or ranked?
How to edit a chart in Excel
How to print an Excel spreadsheet without cutting off columns
The third edition is up-to-date with new instructions and high-resolution screenshots of Excel 2019, Excel Online, and the new Google Sheets. It includes new sections about collaboration, OneDrive, and other features.
Revised third edition for Excel 2019 Here's your chance to finally learn how to use Microsoft Excel In a single sitting, this quick and easy user guide will help you learn MS Excel basics, from navigating the home screen to working with formulas and charts. It's a great Excel tutorial that will help you in the office, at school, or even at home.
Excel Basics In 30 Minutes, 3rd Edition is written in plain English, with lots of step-by-step instructions and screenshots that demonstrate exactly what to do. This MS Excel tutorial references Excel 2019, but most of the step-by-step instructions apply to earlier versions of MS Excel released as part of the Microsoft Office and Office 365 suites, including Excel 2016. If you don't own Excel, the book explains how to use two free online spreadsheets programs: Excel Online and Google Sheets (part of the Google Drive online office suite). The book also explains how to use the Excel mobile apps for Android and iOS.
Topics covered
Excel screen layout, cells, and terminology
Excel 2019 vs. Excel Online vs. Google Sheets
Excel for iOS and Excel for Android
Basic Excel formatting
AutoFill
Excel formulas and functions
How to make charts in Excel
Sorting and filtering
Collaboration and sharing
Exporting PDF, CSV, and other forms
Printing tips
Excel import and export formats (PDF, .CSV, .TSV, text, etc.)
This is not an Excel bible, but rather a basic Excel tutorial and reference that answers the core questions that any new Excel user will have:
What is a spreadsheet?
What are cells?
What is the button with the Greek letter for?
How can Excel spreadsheets create basic financial projections?
How can certain data in a worksheet be highlighted?
How can data be alphabetized or ranked?
How to edit a chart in Excel
How to print an Excel spreadsheet without cutting off columns
The third edition is up-to-date with new instructions and high-resolution screenshots of Excel 2019, Excel Online, and the new Google Sheets. It includes new sections about collaboration, OneDrive, and other features.
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru