Excel Functions & Formulas in easy steps
Visual Basic in easy steps, 6th edition
RRP £11.99 each - buy both books together for only £16.00!
See below for details of each book:
By: Michael Price
Publication: August 31st, 2020
About the book
Excel Functions & Formulas in easy steps shows you how to get the most of Excel, once you’ve mastered the basics. You will learn how to build more powerful spreadsheets using the features of Excel formulas, and explore all the categories of Excel functions including financial, logical, mathematical, and data related functions. Then, review business-oriented scenarios and examples of functions in each of the groups, and consider the additional facilities offered through user-defined functions.
The topics covered apply to all recent versions of Microsoft Excel.
Table of Contents:
- Values and Formulas
- Managing Formulas
- Financial and Logical
- Text, Date and Time
- Lookup, Reference and Information
- Math, Trig and Statistical
- Engineering and Cube
- Compatibility and Database
- Web and Add-ins
By Mike McGrath
Publication date: July 31st, 2019
About the book
Visual Basic in easy steps, 6th edition shows you how to quickly create Windows applications using the latest free Visual Basic/Studio Community programming environment. This book gives you code examples, screenshots, and step-by-step instructions that illustrate each aspect of Visual Basic.
Visual Basic in easy steps, 6th edition begins by describing the Visual Studio Community installation process, then introduces form controls, application properties, the programming language, and problem-solving techniques.
Next, the book illustrates by example, how to build and deploy a complete Windows application. A chapter is devoted to scripting with Visual Basic. This first shows you how to create 'macros' for Word and Excel in Microsoft Office, using Visual Basic for Applications (VBA), then demonstrates how to manipulate files and data within the Windows operating system using VBScript. You will learn how to incorporate external data into your applications from text files, Excel spreadsheets, XML documents, live RSS web feeds, and SQL databases.
You need have no previous knowledge of any programming language so it's ideal if you're a newcomer to Windows programming. Each chapter builds your knowledge of Visual Basic. By the end of this book you will have gained a sound understanding of Visual Basic programming and be able to create your own interactive applications.
Visual Basic in easy steps, 6th edition has an easy-to-follow style that will appeal to anyone who wants to begin Windows programming. It will appeal to programmers who want to quickly learn the latest Visual Basic techniques, and to the student who is studying computing at school or college, and to those seeking a career in Information Technology who need a thorough understanding of Visual Basic programming.
Updated for Visual Basic 2019.