SquareOne Training

This beginner class introduces students to database software and teaches them how to construct a database using forms, tables, queries, and reports. Students also learn to appreciate the relevance and usefulness of an Access database to their current professional roles.

Students in this intermediate Access class will learn to use relational concepts and rules, principles of data structure, and referential integrity to assist them in developing databases. They also learn to conduct advanced queries and to prepare reports using such tools as string functions, concatenating fields, and custom styles.

Designed for those who are true beginners with Excel, this class shows how one can benefit from Microsoft’s most successful product. File Management, data input, and working with dates and functions constitute the bulk of the class’ curriculum.

This intermediate Excel seminar teaches the uses of range names, IF statements, and text and date functions. The syllabus also includes working with tables, pivot charts, and sparklines.

This Excel class teaches students to employ IF formulas (including nested IFs and COUNTIF), pivot tables, and pivot charts. Students taking the course also learn to work with large data, to remove duplicates, to employ sort and custom sort, and to freeze panes.

Lookup and information functions, protecting and sharing spreadsheets, and auditing formulae are all part of this advanced Excel class. Macros and creating macro buttons are also among the advanced but highly practical topics presented.

This class shows beginner students how to understand and create dashboards with Excel. Students learn to capitalize on pivot tables, sparklines, slicers, and timelines in order to transform a spreadsheet into something both intelligible and visually engaging.

Students in this class learn to employ Power Query, the most powerful data automation tool in the Excel arsenal. Among the topics covered are JOIN types, fuzzy lookup, merge columns, unpivot columns, and transposing.

For beginners or those who have taught themselves to use PowerPoint, this class teaches how to create effective and eye-catching presentations in the most efficient way. Charts, graphics, and SmartArt are among the tools that are placed at students’ disposal, along with templates, the slide master, and even the printing of audience hand-outs.

Participants in this advanced PowerPoint course learn many bells and whistles that can take a presentation to the proverbial next level. Adding multimedia elements (sound, video, animation), hiding slides, and even rehearsal timings are all covered in this information-packed one-day seminar.

Creating, editing, and formatting documents are covered in this introductory Microsoft Word course. Students also learn to use AutoCorrect, to employ templates, and to create tables.

Among the functions covered in this intermediate Word class are advanced tables, forms, headers, footers, columns, frames, and pictures. Students will also come away knowing how to execute a mail merge.

This class introduces students to Adobe After Effects’ interface and the principles of basic animation, including transparency, motion tracking, and nesting. To conclude, students are given an introduction to 3D animation.

This beginner-friendly class acquaints students with the Adobe Illustrator’s interface and its repertoire of drawing tools. The course then shows students how to work with color, text, layers, and objects; it finishes by going into the preparation of Illustrator designs for print and web.

Master pages, layers, and sophisticated typesetting (manual kerning, drop caps, hyphenation) in the first part of this advanced InDesign training program. Students will also learn how to manage long documents, to generate tables of contents and indices, to use drawing tools, and to apply special effects.

Creating, retouching and enhancing images lie at the heart of this introduction to Photoshop, suitable for professional and amateur users alike. Features covered include painting, the Clone Stamp, Brush tools, and the Filter Gallery, along with working with layers, adding text, and resizing images.

This AutoCAD course gives students a solid foundation in using the software to create 2D drawings. In addition to the basics, students learn to save time working with blocks, to add annotations to their drawings, and to work with layouts.