Nonfiction » Computers & Internet » Desktop applications / spreadsheets

VBA for Excel: Programming VBA Macros - The Easy Introduction for Beginners and Non-Programmers
Price: $2.99 USD. Words: 14,970. Language: English. Published: January 31, 2018. Categories: Nonfiction » Computers & Internet » Programming, Nonfiction » Computers & Internet » Desktop applications / spreadsheets
This is an introductory course to Visual Basic for Applications (VBA). It is written for learners with no prior programming experience. Unlike many other books, this introduction focuses on the topics you really need to know to apply VBA successfully at work or at home. You can work through this course in less than a day and become significantly more productive in your work with Excel.
Microsoft Excel Practical Formulae
Price: $6.65 USD. Words: 17,310. Language: English. Published: January 4, 2016. Categories: Nonfiction » Computers & Internet » Desktop applications / spreadsheets, Nonfiction » Computers & Internet » Office productivity applications
This book covers a practical range of basic through to advanced formulae. We cover basic data analysis functions such as SUM, COUNT and IF, and then move to intermediate criteria-based and data tidy functions such as VLOOKUP, CONCATENATE and IFERROR. Next onto advanced data analysis with SUMIF, SUMIFS and INDEX/MATCH and finally onto dynamic functions such as INDIRECT and OFFSET.
Microsoft Excel Basic Formulae
Price: $2.35 USD. Words: 6,670. Language: British English. Published: December 22, 2015. Categories: Nonfiction » Computers & Internet » Desktop applications / spreadsheets, Nonfiction » Computers & Internet » Office productivity applications
This book takes you right back to formula basics; exactly what a formula is. You'll learn about using functions in your formulas; from simple addition, through to statistical analysis, criteria-based calculations and how to look-up information. It will give you the basic calculation tools you need in order to present and make sense of a spreadsheet in a quick easy way.
Microsoft Excel Charts and Pivots
Price: $6.65 USD. Words: 15,530. Language: English. Published: June 23, 2016. Categories: Nonfiction » Computers & Internet » Desktop applications / spreadsheets, Nonfiction » Computers & Internet » Office productivity applications
This book covers some really exciting ways to work with Excel. We talk about how to improve a basic report using powerful analysis and visualisation tools. The main areas we cover are charts and pivot tables; how to build both from scratch, best practice tips, dynamic charts, pivot charts and slicers. We’ll also look at in-cell visualisation; sparklines and heatmaps, dashboards and infographics.
Microsoft Excel Basic Macros
Price: $7.99 USD. Words: 11,910. Language: British English. Published: October 25, 2016. Categories: Nonfiction » Computers & Internet » Desktop applications / spreadsheets, Nonfiction » Computers & Internet » Office productivity applications
I want to give you some VBA basics which will help you read and use VBA code. VBA is a powerful and complex environment but I want to give you the tools and confidence to do basic coding to help you automate tasks. I will give you examples of how to create and run simple but useful code which you can implement immediately; you need no prior knowledge of programming, just an understanding of Excel.
Microsoft Excel Your Way to a Better Job
Price: $7.99 USD. Words: 23,260. Language: English. Published: March 30, 2017. Categories: Nonfiction » Computers & Internet » Desktop applications / spreadsheets, Nonfiction » Business & Economics » Careers
#80 Tips to Improve Your Prospects and Get a Pay Rise. Excel can open doors, but you need to figure out what you need to know, and that’s what this ebook is designed to help you discover. On top of that I’ll give you some great ways to put Excel to strategic use and make the right moves to prime and ask for that pay rise.
Microsoft Excel 75 Formulae Examples
Price: $5.35 USD. Words: 15,440. Language: English. Published: April 26, 2017. Categories: Nonfiction » Computers & Internet » Desktop applications / spreadsheets, Nonfiction » Computers & Internet » Office productivity applications
#75 No Frills Working Formulae Examples. Your understanding of formulae and the functions available to you within Excel allow you to design better spreadsheets. I just want to give you 75 examples; the formula, how it works and an example of it in action. I cover some basic functions, data manipulation, if conditions, counting, summing, look-ups and dates.
Pivot Tables In Depth For Microsoft Excel 2016
Price: $8.99 USD. Words: 40,880. Language: English. Published: September 20, 2017. Categories: Nonfiction » Computers & Internet » Desktop applications / spreadsheets
Pivot Tables In Depth For Microsoft Excel 2016 is a book for both new and experienced users of Pivot Tables. It will take you through a journey in which you will learn nearly everything about Pivot Tables and apply this knowledge with ease. If you want to impress your manager or you simply want to master the use of a great tool then you are buying the right book.
Funções de Excel para Financeiros
Price: $3.99 USD. Words: 38,260. Language: Portuguese. Published: April 1, 2012. Categories: Nonfiction » Computers & Internet » Desktop applications / spreadsheets, Nonfiction » Business & Economics » Accounting / financial
Este livro contém uma colecção de funções do Excel, cujo funcionamento é explicado com exemplos de aplicabilidade dentro do âmbito da Economia e Finanças. É assim dada especial atenção às funções financeiras do Excel onde, a par da explicação sobre a sua aplicabilidade, se dá um entendimento matematicamente fundamentado sobre o seu funcionamento. Utilize o Excel para o seu cálculo financeiro.
Microsoft Excel 2016: Data Analysis with PivotTables
Series: Work Smarter Tips. Price: $4.99 USD. Words: 4,040. Language: English. Published: February 5, 2019 by IFS Harrison. Categories: Nonfiction » Computers & Internet » Desktop applications / spreadsheets, Nonfiction » Education & Study Guides » Computers & technology
PivotTables will help you analyze, summarize, and pick apart your large spreadsheets fast. You could sit for hours, pouring over hundreds, or thousands of rows. Filtering, sorting, and calculating like there's no tomorrow. And when you need to alter the data, you can do it all again. Or you could take a different approach. You can spend seconds, and create PivotTables.
Excel VBA: A Beginners' Guide
Price: $1.99 USD. Words: 11,420. Language: English. Published: October 5, 2015. Categories: Nonfiction » Computers & Internet » Desktop applications / spreadsheets, Nonfiction » Computers & Internet » Programming
Excel VBA is very helpful for you to do your routine task, create your own function, reduce the manual effort and increase your productivity. With the help of VBA you can customize and manipulate data present in the excel sheet as you want. This book will be very helpful and comes in handy for the beginners who don’t have any programming knowledge.
Learn Excel Functions: Logical Functions (IF, AND, OR, NOT)
Price: $0.99 USD. Words: 2,950. Language: English. Published: August 15, 2015. Categories: Nonfiction » Computers & Internet » Desktop applications / spreadsheets
Excel functions is used to save the time and effort of user. Excel by default comes with numerous functions to meet the requirement of user, sort data, calculate data by formula, manipulate data etc. Logical functions play a vital role in it. When you are familiar with logical function you can do most of the stuff in excel with very little effort and time.

Related Categories