Böcker utgivna av Gtech Publishing

Gain expert Excel skills and easily perform complex tasksWhether 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 dataExcel 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.

Enhance Your Productivity with Excel AutomationMaybe you regularly format a set of Excel data you'll like to automate, or you regularly perform repetitive data-crunching tasks that you're trying to automate. Perhaps you got a new job (congratulations). If you are new to Excel programming and you want a crash course to get you up and running with creating your own Excel applications, you've come to the right place. This book will hold your hands through the process of learning how to program Excel to maximize its power, and in the process, enhance your productivity. Excel 2019 Macros and VBA starts off with a walkthrough on how to use the macro recorder to record your actions in Excel. Then we delve right into Visual Basic for Applications (VBA) and all the essentials you need to start creating applications from scratch that automate Excel.Create Your Own Customized Functions for Any Kind of CalculationHave you ever had a calculation you would like to perform but it requires a convoluted Excel formula with several nested functions? Excel formulas are great, but when your solution requires multiple decisions, formulas can begin to get too convoluted. Visual Basic for Applications (VBA) gives you more flexibility in what you can do. VBA provides a cleaner and more efficient way to perform complex calculations and return the result with just one custom function.Unlike some other programming books, this book does not assume you have any programming experience. The information has been delivered in a user-friendly manner without unnecessary technical jargon.All source code samples from the book are included in a downloadable file.After reading this book, you'll know how to: Record and run macros. Edit and customize your recorded macros. Assign macros to custom buttons on the Excel toolbar or in your worksheet. Use the Visual Basic Editor. Create and use variables, procedures, and modules in VBA. Control program flow with programming constructs for decision making and looping. Use the Excel object model to create applications to automate Excel. Use a wide array of debugging tools to obliterate even difficult to find bugs and errors in your code. Create efficient custom functions for complex calculations instead of using cumbersome Excel formulas. Create Excel add-ins to easily package and distribute your work. Use several predesigned macros in this book in your own worksheets.Get Excel 2019 Macros and VBA today and start your journey towards being an Excel programming expert.

Leverage the Full Power of Excel FunctionsExcel 2019 Functions provides a detailed walkthrough of 70 of the most useful Excel functions, including many tips to enable you to maximize the power of Excel through the use of functions.This book provides a detailed description of each function, its arguments, and its use is demonstrated with fitting examples. Learn how to use functions like VLOOKUP, IFS, COUNTIFS, DATEDIF, NETWORKDAYS, FIND, NPV, SUMIFS etc. From simple calculations to building complex spreadsheets that require multiple formulas, knowing the right function to use can increase the accuracy and efficiency of your work.Achieve More with Less EffortLearn new functions introduced in Excel 2016 and 2019 like the IFS functions that make it easier to create powerful formulas much simpler syntax.Excel 2019 Functions will be a great reference guide for you whether you're a beginner or already skilled with Excel. By the time you finish this guide, you will understand how functions work in Excel, how to find the right functions, and how to combine them in solving complex problems.This book comes with downloadable Excel practice files for all examples. Hence, you can follow the tutorials without needing to create the examples from scratch in Excel. You can also copy the tried and tested formulas and use them in your own workbooks.In this book, you'll learn how to: Find and enter functions in Excel. Use lookup and reference functions to find and reference values in your formulas. Use logical functions to execute conditional statements and calculations. Deploy IFS functions in place of convoluted nested functions for more efficient and robust formulas. Use a wide array of date and time functions to address all kinds of date calculations. Manipulate text strings with text functions. Carry out financial calculations with special financial functions. And much more...Buy now to get started today!