Książka Excel 365 Advanced Topics Nathan George

Excel 365 Advanced Topics

Autor: Nathan George
Język: Angielski
Oprawa: Miękka
Wydawca: GTech Publishing
Dostępność: Dostępna u dostawcy
Wysyłamy za 14-21 dni
84.33
Gain expert Excel skills and easily perform complex tasksWhether you have basic Excel skills or you'...

Informacje o książce

Język
Angielski
Oprawa
Książka - Miękka
Data wydania
2023
strony
304
EAN
9781915476098
ISBN
1915476097
Enbook ID
43067989
Waga
572
Wymiary
191 x 235 x 16

Pełny opis

Gain expert Excel skills and easily perform complex tasks


Whether you have basic Excel skills or you're a power user, Excel 365 Advanced Topics is full of tips, techniques, and tools that will save you time and effort in performing challenging tasks in Excel. When building complicated spreadsheet solutions, using the right tool in Excel can increase the accuracy and efficiency of your work. This book does not only show you how to use specific features but also in what context those features need to be used.


Get real-world solutions for your data


Excel 365 Advanced Topics focuses on a selection of topics relevant to real-world productivity tasks you're likely to perform at home or at work requiring more than a basic knowledge of Excel. Even if you're an Excel power user, you'll find lots of ideas and tips in this book that will save you time and effort.


Includes tons of examples and readymade formulas that you can copy and use in your own worksheets. The downloadable practice files enable you to follow the book hands-on, which is the best way to learn.


This book covers Excel for Microsoft 365 (2023 update).


In this book, you'll learn how to:

  • Transform data in Excel using the Power Query Editor.
  • Remove duplicate rows from a data list.
  • Consolidate data from different worksheets or workbooks.
  • Import and use data from external sources like Microsoft Access databases, CSV text files, and websites.
  • Troubleshoot and fix formula errors with various tools.
  • Use functions like IFS and SUMIFS to create simpler but more efficient conditional formulas in place of convoluted nested IF functions.
  • Use modern dynamic array functions like TEXTBEFORE, TEXTAFTER, and TEXTSPLIT to manipulate text strings.
  • Carry out financial calculations with functions like PV, FV, and NPV.
  • Use Macros to automate Excel tasks.
  • Analyze different data scenarios and create projections with What-If Analysis tools.
  • Dynamically analyze large sets of data with Pivot Tables and Pivot Charts.
  • Protect your workbook, worksheets, or specific cells in your worksheets from unauthorized or accidental changes.


Możesz być zainteresowany

Mastering Excel 365

Nathan George
159.21

Mastering Excel 365

Nathan George
174.86
108.04

Excel 365 Basics

Nathan George
111.98

Excel 2023

Leonardo L. wright
65.63
172.40

Excel 2021

JIAYI SIMONDS
68.88
65.43
123.69
320.31
233.91
853.39

Puma in Paris

Kreitlow Brian Kreitlow
34.04

Bitter Years

Francoise Poos
321.20

DAX Patterns

Russo Marco Russo
141.89

Klienci, którzy kupili tę książkę, kupili również

EXCEL 2019 - 365

VICTOR LEONEL YESCAS GUEVARA
127.92
133.14

Excel 2024

Ulrike Sprung
59.43
118.67
46.93

Vzťahy a pasce

Honza Vojtko
52.74

Příručka pro bohy

Jan van Helsing
72.52
67.01