Excel 2016 in easy steps + Excel Functions & Formulas in easy steps + Excel VBA in easy steps + Visual Basic in easy steps – SPECIAL OFFER

Written by In Easy Steps Team on . Posted in

In Easy Steps » Browse our Bookstore » Accounting and Finance » Excel 2016 in easy steps + Excel Functions & Formulas in easy steps + Excel VBA in easy steps + Visual Basic in easy steps - SPECIAL OFFER

SPECIAL OFFER!

Excel 2016 in easy steps (RRP £10.99)
Excel Functions & Formulas in easy steps (RRP £11.99)
Excel VBA in easy steps, 3rd edition (RRP £11.99)
Visual Basic in easy steps, 6th edition (RRP £11.99)

 

Buy all four books together for only £32.00!

See below for details of each book:

 

Excel 2016 in easy steps

By Michael Price
Publication: January 2016
Pages: 192
ISBN: 978-1-84078-651-4

Download or view first chapter and Table of Contents - FREE!

About the book

Excel 2016 in easy steps will help you get to grips with the latest version of this popular spreadsheet application. Areas covered include:

  • Creating, editing and manipulating worksheets
  • Formulas, Functions and Pivot Tables
  • Handy templates to give you a head start
  • Macros for everyday tasks to save time
  • Charts to get an overview of your data
  • Linking workbooks for automatic updates
  • Using the Excel Online app to share and collaborate on spreadsheets and workbooks
  • Adding images and illustrations to your spreadsheet to impress your colleagues!

Whether you’re upgrading to Excel 2016 or new to the spreadsheet concept, use this guide to learn the key features constructively and get more out of Excel 2016 – in easy steps!

 

Excel Functions & Formulas in easy steps

By: Michael Price
Publication: August 31st, 2020
Pages: 192
ISBN: 9781840788815

View or download first chapter and Table of Contents - FREE

 

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:

  1. Values and Formulas
  2. Managing Formulas
  3. Functions
  4. Financial and Logical
  5. Text, Date and Time
  6. Lookup, Reference and Information
  7. Math, Trig and Statistical
  8. Engineering and Cube
  9. Compatibility and Database
  10. Web and Add-ins

 

 

Excel VBA in easy steps, 3rd edition 

By Mike McGrath
Publication date: March 29th, 2019
Pages: 192
ISBN: 978-1-84078-824-2

View or download first chapter and Table of Contents - FREE!

About the book

Excel VBA in easy steps, 3rd edition neatly demonstrates VBA (Visual Basic for Applications) Macro programming in a clear and concise manner, so you can get more from the popular Microsoft Excel spreadsheet application. Areas covered include:

  • Recording and editing Macros
  • Creating your own Macro programs
  • Coding with the VBA language
  • Responding to Worksheet events
  • Programming Excel procedures
  • Making ‘DataForms’ for data editing
  • Producing ‘UserForms’ for data entry
  • Displaying dynamic Charts
  • Sharing your Excel apps to impress your colleagues!

Whether you’re upgrading to Excel 2019, exploring Excel in the Office 365 suite, or new to the Macro programming concept, use this guide to learn the key features constructively and get more out of Microsoft Excel – in easy steps!

 

 

Visual Basic in easy steps, 4th edition 

By Mike McGrath
Publication date: July 31st, 2019
Pages: 192
ISBN: 978-1-84078-872-3

View first chapter and Table of Contents - FREE!

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.

Quantity
Product in stock

Price: £32.00

Loading Updating cart...
LoadingUpdating...