Andy Altaner

INSTRUCTOR

4.2 (9 ratings)

"

In my classes, I start with the learner and never lose focus. I present principles that apply to all types of learning – mental, physical, and emotional

"

Andy Altaner is a Senior Technical Trainer with New Horizons, and has been providing technical consulting and training for the past twenty years with extensive experience in application development and database design. In addition to his classroom teaching experience, he has also consulted extensively on spreadsheet and database application development. Andy has been involved in many Microsoft Delivery Events, including the latest roll-outs of Windows and Office. He is certified in Microsoft Office, and proficient in all versions of MS Office applications, including Access, Excel, Outlook, PowerPoint, Project, Visio and Word. He also works in Crystal Reports (Business Objects), Access VBA, Excel VBA, and SQL. Prior to joining New Horizons, Andy served as the End User Support Manager at a major manufacturer, and has a Master of Business Administration Degree in Management Information Systems from Syracuse University. He also has a Bachelor’s Degree from Cornell University.

CREDENTIALS

MOS: Microsoft Office Excel 2016 Expert Business Objects Certified Professional XI MS Access, Project & Visio Crystal Reports SQL VBA

courses with Andy Altaner

Expert 05 Hrs 05 Min Andy Altaner

This course will teach students proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code.

Last Release: 07/22/19
Intermediate 06 Hrs 25 Min Andy Altaner

This is the intermediate course in the Microsoft Word 365 series. This course expands upon the topics covered in the Word 365 Introduction course. In this course, students will work with, create, manage, and customize Styles, Templates, and Themes. Students will also work with various types of data in Word using Tables, advanced Copy and Paste commands, and Charts. Students will then review advanced document layout options in Word and various collaboration tools. Lastly, students will work with graphic elements such as pictures, text boxes, shapes, the Drawing Canvas, SmartArt, Text Effects, Typography Effects, WordArt, and Equations. Additional graphic element features such as grouping, layering, and moving objects will also be covered.

Last Release: 06/12/19
Advanced 05 Hrs 52 Min Andy Altaner

In this course, students will automate with Microsoft Word 2019 through the use of building blocks, Quick Parts, fields, and Macros. Students will also utilize reference tools such as bookmarks, hyperlinks, cross references, footnotes, endnotes, bibliography tools, sources, and placeholders. Students will also learn techniques to manage long documents through a table of contents, indexing, and captions. Students will also work with Outline View and master documents, Mail Merge, and forms.

Last Release: 05/13/19
Advanced 05 Hrs 40 Min Andy Altaner

In this course, students will automate with Microsoft Word 365 through the use of building blocks, Quick Parts, fields, and Macros. Students will also utilize reference tools such as bookmarks, hyperlinks, cross references, footnotes, endnotes, bibliography tools, sources, and placeholders. Students will also learn techniques to manage long documents through a table of contents, indexing, and captions. Students will also work with Outline View and master documents, Mail Merge, and forms.

Last Release: 04/12/19
Intermediate 04 Hrs 11 Min Andy Altaner

This course is designed to teach students intermediate level skills in Microsoft Access 2019. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 2019 Advanced course.

Last Release: 04/01/19
Intermediate 04 Hrs 15 Min Andy Altaner

This course is designed to teach students intermediate level skills in Microsoft Access 365. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 365 Advanced course.

Last Release: 03/04/19
Beginner 04 Hrs 40 Min Andy Altaner

This course is an introduction to Microsoft Access 365. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 365 Intermediate course.

Last Release: 02/04/19
Beginner 04 Hrs 27 Min Andy Altaner

This course is an introduction to Microsoft Access 2019. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2019 Intermediate course.

Last Release: 01/11/19