LANTEC of Lousiana Corporate Training Center

This course introduces the fundamentals of Microsoft Access. This 1-day course will give students an overview of database design. They will learn how 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 students how to use more advanced features of Microsoft Access. This program 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, lock down 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 using VBA for more advanced functions.

This 1-day Excel course introduces beginners to the fundamentals of Excel, helping them become comfortable working with spreadsheets. This course covers the basics of spreadsheets, the Excel interface, 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 required for full certification.

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 broad range of 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 Expert exam 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 PivotTable features. This course covers a variety of PivotTable essentials, such as using lists, utilizing 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 Power Pivot, 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-making and looping 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, adjust layouts, and manipulate and analyze data. They will complete several lab projects in which they practice their skills and learn how to publish completed PivotTables online.

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