A complete Excel training course, this CD-ROM contains three complete one-day modules that teach VBA basics and show how to use the macro recorder and then edit the code in order to make a usable macro. Examples demonstrate how to control charts and pivot tables using VBA, and clear explanations reveal the difference between methods and properties. The second module covers how to calculate with VBA covering loops, functions, formulas, and arrays. The third module discusses how to build a successful application that will interact with the user. Userforms and event handlers are also discussed.

Slide Your Way Through Excel VBA: Learn to Keep Excel Under Control with VBA (Visual Training series)

Computers & Technology

Verschuuren, Dr. Gerard

Software

Holy Macro! Books

Equivalent to a three-day course in Excel, this thorough and entertaining CD-ROM contains 600 slides of self-paced training revolving specifically around how scientists can best utilize the popular spreadsheet program. With updated information on Excel 2010 and 2013, the CD-ROM is based on the author’s professional training sessions and provides multiple-choice questions as efficient progress markers. Among the techniques taught are how to add a trend line to a chart in two clicks, when to use PEARSON instead of CORREL, creating a multifactorial or polynomial trendline, including error bars on a chart, using a hidden worksheet for data validation lists, and many others tailored to what scientists need most when using Excel and the common pitfalls that may occur.

Excel 2013 for Scientists (Visual Training series)

With examples from the world of science, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Scientists can learn the tips and techniques of Excel—and tailor them specifically to their experiments, designs, and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE vs Z, how to keep data-validation lists on a hidden worksheet, use pivot tables to chart frequency distribution, generate random samples with various characteristics, and much more. Ideal for students and professionals alike, this handbook will enable greater productivity and efficiency and it is updated to include all new functions in Excel 2010 and Excel 2013.

Excel 2013 for Scientists (Excel for Professionals series)

This CD-ROM is not only an excellent learning tool to master VBA but also a gold mine for very powerful and useful macros. It has more than 1,200 PowerPoint slides that guide you through the learning process and comes with Excel files for you to work on as well as files that have the VBA code all done. Developed and tested for business training, this CD-ROM is ideally suited for self-instruction using a screen shot approach versus an overabundance of text. More than 1,400 slides, with examples drawn from actual cases, are divided into three modules covering VBA basics, how to calculate with VBA, and letting VBA interact with the user.

Excel 2013 VBA (Visual Training series)

Programming

These self-paced, self-checking courses provide Microsoft Office users with the training required for proficiency in Access and Excel. Presented visually on more than 1,400 slides, and with frequent self-checks to ensure mastery, these tutorials include a convenient navigation system that allows the learners to jump to any specific location. The examples used stem from real-life scenarios, and the courses can be tailored to review only the items the learner needs. With more than 125 million users of Access and more than 400 million users of Excel, these self-directed courses have the potential to help those needing greater skills but lacking the time for classroom instruction.

Your Access to the World: A Complete Course on Microsoft Access (Visual Training series)

Certification

These self-paced courses provide technology users with the training required for proficiency. Presented visually on more than 1,400 slides, and with frequent self-checks to ensure mastery, these tutorials include a convenient navigation system that allows the learners to jump to any specific location.

Master the Web: A Complete Course on HTML and JavaScript (1)

Access VBA Made Accessible: A Complete Course on Microsoft Access Programming (Visual Training series)

For scientists and engineers tired of trying to learn Excel with examples from accounting, this self-paced tutorial is loaded with informative samples from the world of science and engineering. Techniques covered include creating a multifactorial or polynomial trendline, generating random samples with various characteristics, and tips on when to use PEARSON instead of CORREL. Other science- and engineering-related Excel features such as making columns touch each other for a histogram, unlinking a chart from its data, and pivoting tables to create frequency distributions are also covered.

Excel for Scientists and Engineers (Excel for Professionals series)

Developed and tested for business training, this CD-ROM is ideally suited for self-instruction using a screen shot approach versus an overabundance of text.  More than 1,400 slides, with examples drawn from actual cases, are divided into three modules covering VBA basics, how to calculate with VBA, and letting VBA interact with the user.

Excel 2007 VBA (Visual Training series)

With examples from the world of science and engineering, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Physicists and engineers can learn the tips and techniques of Excel—and tailor them specifically to their experiments, designs, and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE vs Z, how to keep data-validation lists on a hidden worksheet, use pivot tables to chart frequency distribution, generate random samples with various characteristics, and much more. Ideal for students and professionals alike, this handbook will enable greater productivity and efficiency.

Excel 2007 for Scientists and Engineers (Excel for Professionals series)

See the best price to sell, buy, or rent books by Verschuuren, Dr. Gerard. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Verschuuren, Dr. Gerard