Microsoft Excel Step by Step (Office 2021 and Microsoft 365), Lambert Joan, Frye Curtis
Старое издание
Автор: Frye Curtis Название: Microsoft Excel 2019 Step by Step ISBN: 1509307672 ISBN-13(EAN): 9781509307678 Издательство: Pearson Education Цена: 7889.00 р. Наличие на складе: Есть у поставщикаПоставка под заказ. Описание: The quick way to learn Microsoft Excel 2019
This is learning made easy. Get more done quickly with Microsoft Excel 2019. 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 easier viewing
Perform calculations and find and correct errors
Create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines
Visualize data with 3D maps, funnel charts, and other powerful tools
Import, process, summarize, and analyze huge datasets with Excel's improved PowerPivot and Power Query
Build powerful data models and use them in business intelligence
Описание: 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
Автор: 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: 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.
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.
Автор: 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.
Описание: 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
Автор: 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.
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.
Автор: Albion Jensen, Jensen Название: Excel 2021: a step-by-step guide to lear ISBN: 191437875X ISBN-13(EAN): 9781914378751 Издательство: Неизвестно Рейтинг: Цена: 4689.00 р. Наличие на складе: Нет в наличии.
Описание:
Learn how to get the most out of Microsoft Excel, even if you are a complete Excel beginner!
You will repeatedly hear the same criticism of most Excel books: "you have to already know Excel to understand the book". This book is different. If you have no previous exposure to Excel 365, and your only computer skill is using a web browser, you'll have absolutely no problems working through the lessons. Everything is concisely described in a way that absolutely any student, of any age or ability, can easily understand.
This Essential Skills book makes it easy for absolutely anybody to very rapidly learn Excel 365 to a standard that will greatly impress most employers because it doesn't confuse by teaching skills that are not common in the workplace.
Our Excel 365 Expert Skills book comprehensively teaches the rarer Excel skills that less than 10% of Excel users typically master (and many office workers will not have a need for).
Here are some other reasons that you should choose this book to learn Excel 365:
It covers the Excel 365 edition of Excel: This book is specifically written for Excel 365. Excel 365 has now evolved into a very different product than Excel 2019. It is not possible to learn Excel 365 features using an Excel 2019 book.
It is up-to-date: This book is the fourth edition covering the new Excel 365 Jan 2021 semi-annual version.A new Excel 365 semi-annual version is released every six months (in January and July) and automatically updated to your computer. We then publish a new edition of this book to support the latest update. This means that new features are covered and the screen grabs will exactly match what you see on your screen. It can be very frustrating to try to learn Excel 365 using an out-of-date book.
Smart Method books are #1 best sellers: Every Smart Method Excel book (and there have been twenty-two of them starting with Excel 2007) has been an Amazon best seller in its category. This provides you with the confidence that you are using a best-of-breed resource to learn Excel.
It is the book of choice for teachers. As well as catering for those wishing to learn Excel by self-study, Smart Method books have long been the preferred choice for Excel teachers as they are designed to teach Excel and not as reference books. Books follow best-practice adult teaching methodology with clearly defined objectives for each learning session and an exercise to confirm skills transfer. With single, self-contained lessons, the books cater for any teaching or self-learning period. Many learners have learned Excel by setting aside just a few minutes each day to complete a single lesson. Others have worked through the entire book in a single day.
Companies who have taken Smart Method courses include:
The United States Army, Daimler Chrysler, Time Warner, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, Unilever, BMW, Virgin, The BBC, British Petroleum, The Foreign and Commonwealth Office, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, RBS, The British Museum, The National Gallery, Pokerstars, Virgin, O2, BMW... and many, many others.
Whether you're a complete beginner or a casual spreadsheet user, Excel Formulas and Functions 2020 Basics is the guide you're looking for.
Through a simple step-by-step process, you are going to learn how to work with Excel, whether you use it at the office or at home for personal reasons. The purpose of this comprehensive guide is to take you by the hand and teach you how to use all the powerful features and tools offered by Excel. Learn how and when to use the tools provided for you. Don't just memorize functions and formulas when you can let Excel do the heavy lifting for you.
Study this versatile business, personal financing, and data analyzing tool with this basic step-by-step guide for beginners. Here are some of the things you'll learn:
1.Create and edit spreadsheets by using lists or tables.
2.Master formulas and use functions to improve them.
3.Explore all the new tools and features that allow you to use Excel without memorizing every component.
Whether you need a step-by-step guide, or a simple course to refresh your memory, Excel Formulas and Functions 2020 Basics has got you covered.
In the past decade Excel became one of the most useful office and personal tools out there. While it used to be associated with office administrators,
accountants, and analysts in the past, nowadays it's used by everyone. It's easy to learn and it provides us with the ability to help ourselves by
analyzing the data that matters in our lives. More and more users turned to Excel for help with their personal finances, for example.
Nothing beats having a spreadsheet and a chart to open your eyes and tell you where all your money goes. And this is where this step-by-step guide comes in to give you a helping hand.
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru
