Home
Excel 365 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity
Barnes and Noble
Loading Inventory...
Excel 365 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity in Franklin, TN
Current price: $19.99
Barnes and Noble
Excel 365 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity in Franklin, TN
Current price: $19.99
Loading Inventory...
Size: OS
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
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.
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
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.
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
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.
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
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.
You May Also Like
More About Barnes and Noble at CoolSprings Galleria
Barnes & Noble is the world’s largest retail bookseller and a leading retailer of content, digital media and educational products. Our Nook Digital business offers a lineup of NOOK® tablets and e-Readers and an expansive collection of digital reading content through the NOOK Store®. Barnes & Noble’s mission is to operate the best omni-channel specialty retail business in America, helping both our customers and booksellers reach their aspirations, while being a credit to the communities we serve.
1800 Galleria Blvd #1310, Franklin, TN 37067, United States
