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.