LANTEC of Lousiana Corporate Training Center

This course introduces the fundamentals of Microsoft Access. This 1-day experience will give students an overview of database design. They will learn to create tables, queries, forms, and reports. In addition, they will learn best practices in database design and management.

This 1-day intermediate course teaches users how to use the more advanced features of Microsoft Access. This one-day course teaches students how to design relational databases, use advanced queries, join tables, validate data, and customize reports. Students will also learn how to effectively create parameter and action queries.

Students who have completed beginner and intermediate Microsoft Access classes can gain expert-level competency in this one-day program. They will learn how to share data across applications, lockdown and prepare a database for distribution, customize a form layout, use macros for improved user interface design, and much more. They will also be introduced to the use of VBA for more advanced functions.

This 1-day Excel course introduces beginners to the fundamentals of Excel, getting them comfortable working with spreadsheets. This course covers the basics of spreadsheets, the layout of Excel, entering data, using common formulas and functions, and a variety of other helpful tips and tricks. This course is a great start for anyone seeking Microsoft Excel certification. Additional courses will be needed.

This 1-day Excel course is designed for individuals familiar with Excel but who are looking to bolster their knowledge of Excel’s capabilities. Students will learn how to use data analysis tools, manage complex workbooks, and take advantage of Excel’s presentation features. This course covers a lot of broad chart-related content, including creating and working with charts, incorporating various styles and themes, using print options, and best practices around using excel data in other office applications, like Word or PowerPoint.

Experienced users of Excel can learn more advanced skills in this 1-day course. Students will learn how to use Excel’s lookup and decision-making functions, error-handling, array functions, and macros. They will also learn how to use the Power Pivot Data Model and Analysis Toolpak. Completion of this course should prepare students for the Microsoft Office Experts exams for Excel.

This 1-day Excel course is designed for individuals familiar with Excel who are looking to bolster their knowledge of the various database and PivotTables features. This course covers a variety of PivotTable essentials, such as using lists, table features, working with data, creating and enhancing PivotTables, and much more. Students will learn how to manipulate data from multiple datasets, enable and navigate PowerPivot, and create KPIs.

This 1-day course teaches experienced Excel users how to use advanced Excel features. They will learn how to use the Visual Basic Editor, the basics of Procedure, Public, and Module-Level Scope. Students will work with decision and loop structures and learn how to create custom dialog boxes. They will also learn how to debug code and handle errors.

This 1-day Microsoft Excel course teaches students how to work with PivotTables. Students will create PivotTables, rearrange layouts, and manipulate and analyze data. They will complete several lab projects in which they practice their skills and learn how to publish their finished PivotTables to the web.

This 2-day course teaches Microsoft Outlook basics such as module development, email management, contact management, calendaring, task management, and interface customization. The program teaches essential skills needed to automate email, handle complex scheduling, sort and filter email, and more. Students will also learn how to collaborate with colleagues using mail merging and sharing features.