Skip to main content

Online Classes >> Career Skills
« back to courses page

career skills

Click on the class title to see the full description.

ST. CHARLES ARTS COUNCIL CLASSES:
If you have accessibility issues, please call 636-922-8233 for instructions on where to park and enter the building.


If you have questions, please provide us with the course title and number when email or call 636-922-8233.

Register one week prior to the start of class to avoid class cancellations.

 

 

 
We are faced with different types of business decisions each day that can change the data we work with along with our financial outcomes. Have you ever wondered what type of workplace skills you can learn to make wiser decisions? Learning Advanced Excel contains these tools that can help you prepare your worksheets accurately, examine your data for authentication, and then find those answers to your most difficult questions. This course will help you learn these required business functions along with the tools required to analyze data efficiently within the workplace. Save time for yourself by protecting your valuable data and know with assurance that the entered data is accurate without any errors. By completing the course, discover how to attractively visualize your data into meaningful information with confidence. Agenda Unit 1 - Advanced Functions Used To Make Business Decisions Applying multiple criteria to functions Using And criteria Using Or criteria Using And and Or and Not criteria Advanced Logical functions Using If -Then control statements Implementing If functions with Aggregate functions Unit 2 - Functions Used to Make Financial Decisions Learning basic financial functions Applying functions to perform loan calculations Computing loan payments Computing interest rate Computing number of payment periods Computing present value of a loan Working with additional functions Unit 3 - Applying Different Scenarios Using Excel Data Tools Understanding Different What-If Analysis Tools Performing What-If Analysis to see how data changes outcomes in formulas Using Scenario Manager Using Data Tables Using Goal Seek Applying rules to manage cell data Implement validation rules to avoid invalid entries Entering validation rules Avoiding duplicate data entries Unit 4 - Powerful Tools Used to Complete Data Implementation and Analysis Exporting and Importing Data into Workbook Protecting a workbook Making improved business decisions using pivot tables Creating an Excel Dashboard to visually display relevant data

4010002

Online 24/7; sessions starting 04/02/2018,ending 04/27/2018

Tuition: $195.00

Supply Fee: $0.00

Location : Online



View Details »
A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world. Begin with learning how an Excel worksheet is constructed, populated with content, and edited for delivery. Discover how various menu items, commands, settings and processes affects the look of your Excel worksheets and workbooks. Then, increase your efficiency by learning how to organize, display and calculate your data into useful information. Identify different types of data and how data can be best visually represented or formatted, by using different data tool techniques. Finally, you’ll learn a variety of Excel’s most powerful features to analyze data quickly and easily. This Certificate will help you discover how to attractively visualize your data into meaningful information with confidence.

4010003

Online 24/7; sessions starting 02/05/2018,ending 04/27/2018

Tuition: $495.00

Supply Fee: $0.00

Location : Online



View Details »
In today’s business environment, employers expect employees to have a solid set of interpersonal skills. The ability to solve problems quickly and effectively is a critical interpersonal skill well worth developing. Using the problem solving model in this course will enable you to be more successful. Interpersonal and businesses relationships fail because of poor problem solving. Find out how to recognize problems and deal with them more appropriately. You will take home techniques relevant for any organization or group context, but can also be easily adapted to work at an individual level. Agenda Unit 1 What is a problem? Detecting and identifying problems Differentiating problems from symptoms Recognizing the business reasons for creative problem solving Structuring problems with observation and fact-finding Unit 2 Identify and Evaluate Solutions Generating multiple solutions to solve problems Selecting the best solution Stretching outside your preferred style Evaluating the risks of taking action vs. not taking action Unit 3 Make and Implement a Decision Utilizing 4 decision-making methodologies to select a solution Exploring the best possible means of implementing the solution Identifying who will implement the solution Committing to a solution Unit 4 Problem Solving Follow Up Expressing organizational benefits Employing the 4 effective methods of obtaining feedback Planning follow up meetings Identifying improvements Documenting success and the process for future reference Continuously practicing your newly developed creative thinking skillsRequirementsInternet connection ,IE8 or higher, Chrome, FireFox and access to Adobe Flash Player

4010006

Online 24/7; sessions starting 04/02/2018,ending 04/27/2018

Tuition: $195.00

Supply Fee: $0.00

Location : Online



View Details »
Did you know most electronic presentations are built for the presenter and not the audience? Add impact to your presentations by using the most effective designs. It’s not about the software. It’s about how your audience processes your information. You’ll find simple, key ideas that will maximize your presentation for all learning styles. These ideas you’ll not find anywhere else.

4010011

Online 24/7; sessions starting 04/02/2018,ending 04/27/2018

Tuition: $195.00

Supply Fee: $0.00

Location : Online



View Details »
Have you ever wondered why Excel is one of the most powerful applications used today by many businesses? Excel is one of the most important applications that you can study now to take your skills to the next level! This course will help you increase your efficiency by learning how to organize, display and calculate your data into useful information. Find out how you can consolidate your data proficiently into readable rows and columns using different table designs and styles. Create a unique style for yourself to improve your spreadsheet appearance to make the content easier to understand for your target audience. Learn from the trainer on how beneficial it is to become more productive in generating different everyday business functions. Discover how easily pivot tables can be created to quickly summarize large amounts of data. Through this course, these tasks will make your work outstanding and unique in what you do. Agenda Unit 1 - Organizing Worksheet and Table Data Introduction to tables Formatting tables using styles Using formulas in tables Sorting and Filtering table data Unit 2 - Understanding Popular Excel Functions Understanding Name Manager Applying business functions Creating functions that handle text Performing basic lookup functions Creating functions that work with dates and times Unit 3 - Improving Worksheet Appearance Formatting cells in worksheets Correcting common function errors Creating and using worksheet outlines Customizing Excel user interface Unit 4 - Analyzing Data Using Data Validation and Pivot Tables Understanding how to convert text to columns Understanding how to analyze spreadsheet data Understanding the basic pivot table layout and key terms Creating and formatting simple pivot tables

4010004

Online 24/7; sessions starting 03/05/2018,ending 03/30/2018

Tuition: $195.00

Supply Fee: $0.00

Location : Online



View Details »
Must-have skills to succeed in the workplace include the ability to create, edit and manage presentations in Microsoft (MS) PowerPoint, documents in MS Word, email and calendars in MS Outlook, and spreadsheets in MS Excel. Microsoft Office Suite of applications is the most used software tool in the world. Stay current with this class, as it is always up-to-date and will change as the features of MS Office change over time. Master the most common uses so that you can work faster and more efficiently and can take your computer skills from plain and drab to exciting and engaging. You will leave class with a set of skills that are a workplace requirement in today’s fast paced ever-changing environment and will enable your future career success. Agenda Unit 1 Introduction to Microsoft Word Explore the different parts of the Word document and document navigation Learn how to format paragraphs, line spacing and fonts Add and modify bullets, lists, tables, headers, footers, page numbers and page breaks Insert graphical elements including drawing objects, pictures, and charts Utilize proofing features like spell check and grammar check Unit 2 Introduction to Microsoft Excel Explore the different parts of the Excel worksheet and document navigation Understand cells and their makeup and how to populate, format and merge cells Create and manage formulas, tables, charts, and multiple worksheet “workbooks” Printing and PDF file creation including setting print areas Unit 3 Introduction to Microsoft PowerPoint Explore the different parts of the PowerPoint presentation Understand slides and their makeup Create, Insert and format slides Insert and modify text, tables, charts, graphics, videos and images Unit 4 Microsoft Outlook Understand Outlook navigation and how the various aspects work together View, create and respond to email messages; format emails and set signature(s) Email etiquette: CC, BCC, threads, quoting and textual interpretation Navigate and search email folders Set email forwarding and filtering rules Request and edit appointments and respond to meeting requests

4010008

Online 24/7; sessions starting 02/05/2018,ending 03/02/2018

Tuition: $195.00

Supply Fee: $0.00

Location : Online



View Details »
A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world. Stay current with this class, as it is always up-to-date and will change as the features of Excel change over time. Examine the life of an Excel worksheet and workbook, from creation to presentation. Learn how an Excel worksheet is constructed, populated with content, and edited for delivery. Master the options that can take your Excel worksheet from plain, drab numbers to exciting and engaging multimedia. You will leave class with a set of skills that are in high demand and will be a deciding factor in your future success. Agenda Unit 1 Excel From The Ground Up Why businesses use Excel for spreadsheet management Technical requirements to use Excel (and all Office modules) Launch Excel and create your first Excel worksheet Discover how to protect and save your document Set your document’s Properties and Attributes including Subject, Title and Author Unit 2 Excel Document Creation Explore the different parts of the Excel worksheet and document navigation Understand cells and their makeup Learn how to populate, format and merge cells Create multiple worksheet “workbooks” Learn how to insert comments and check spelling Unit 3 Advanced Features and Functionality Create and manage formulas and functions Filter and sort tables and data Create “live” connections between multiple worksheets Create effective and informative table and charts Unit 4 Excel Management and Sharing Create meaningful file names and understand filing systems to manage Excel documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including setting print areas Learn how to export Excel tables and charts to PowerPoint presentations and Word documents Use Outlook to send Excel worksheets and workbooks to other users

4010009

Online 24/7; sessions starting 02/05/2018,ending 03/02/2018

Tuition: $195.00

Supply Fee: $0.00

Location : Online



View Details »
Bridget Brady is a speaker, trainer, author and entrepreneur. She has trained thousands of people to improve their voice, presentations, sales and over-all business success. Bridget also facilitates corporate training, and helps high level executives speak and present more effectively. Bridget has been a popular guest speaker on various internet/radio shows and live events, and most recently shared the stage with legendary speaker, Les Brown. Agenda Unit 1 Getting Started Right -Specific strategies to calm your nerves and overcome the fear of speaking. -Master the critical, first five minutes of every presentation. -How to create thought provoking questions to enroll your audience. -The power of speaking in benefits. Learning the WIIFM (“what’s in it for me”) for your audience. -How to tailor each presentation for different audiences. Unit 2 Correct Vocal Production & Vocal Health -Vocal production: correct breathing, grounding, and voice basics. -Vocal exercises for diction, resonance, and vocal placement. -Vocal health, to speak correctly, and never lose your voice. -Grounding and centering before every presentation. Unit 3 Advanced Presentation Techniques -Effective story-telling. -Keeping your audience active and engaged throughout your entire presentation. -The importance of “state changes”, especially during longer presentations or trainings. -How to use accelerated learning techniques. Unit 4 Putting it All Together -How to create a specific structure for every presentation. -How to apply all these techniques across different mediums. -How to successfully conclude your presentation and lead your audience to the next step.RequirementsInternet connection ,IE8 or higher, Chrome, FireFox and access to Adobe Flash Player

4010010

Online 24/7; sessions starting 02/05/2018,ending 03/02/2018

Tuition: $195.00

Supply Fee: $0.00

Location : Online



View Details »
Presentations. Whenever people here that word they have an emotional response. Some people get excited and others (most) get nervous. Tracy Morgan recently said something about this, and it was perfect, “People who are nervous can’t wait for it to end. But people who are excited can’t wait for it to begin.” In this class I will focus on two main topics: You and Them. With “You” we will look at how to identify and improve your presentation style - how do you use your body, your face and your hands. We will talk about charisma and if you have it - and if you don’t how you get it. And I will give you some tricks and tips on how to use the Power of The Pause and how to tap into your vulnerability and use it to connect with an audience with integrity and authenticity. With “Them” we will discuss how you identify different personality types that will be in your audiences and how to both respect their needs and give them not what they want, but what they need. I will also give you ideas on how to maintain eye contact, what to do when your equipment fails and the Top 10 Things you must do before you present. This course is designed to give you exercises that you can do on your own to strengthen your presentation muscle and maintain a great attitude when it comes to presenting.

4010012

Online 24/7; sessions starting 03/05/2018,ending 03/30/2018

Tuition: $195.00

Supply Fee: $0.00

Location : Online



View Details »
Presentations. Whenever people here that word they have an emotional response. Some people get excited and others (most) get nervous. In this Certificate series, you will learn how to effectively deliver a presentation to one person across the table, in front of a small group in a boardroom, from on-stage for a large audience, and host tele-seminars or webinars online. Come away with ideas on how to maintain eye contact, what to do when your equipment fails, and the Top 10 things you must do before you present. Finally, learn how your audience processes your information. You’ll find simple, key ideas that will maximize your presentation for all learning styles.

4010013

Online 24/7; sessions starting 02/05/2018,ending 04/27/2018

Tuition: $495.00

Supply Fee: $0.00

Location : Online



View Details »
Online users say a website’s design is the number one criteria for deciding whether a company is credible or not, according to recent research. Understanding what it takes to produce effective web design is essential in today’s market of highly saturated digital competition. Discover the basics of web design using HTML and CSS. The No prior knowledge of HTML or web design is required. Throughout the course you will get the info you need to plan and design effective web pages. Come away knowing how to implement web pages by writing HTML and CSS code. And discover ways to enhance web pages with the use of page layout techniques, text formatting, graphics, and images. Agenda Unit 1 The Principles of Web Design Plan the Structure of a Website / File Management Target your audience Designing Effective Web Layout and Navigation Unit 2 Structure vs Presentation Introduction to HTML5 Basic Markup Introduction to CSS3 - Linking and Embedding Stylesheets Unit 3 Web Graphics and Content Understanding web graphics Acquiring images / Copyright law and graphics on the web Optimizing images Adding images to your web page Unit 4 Publishing Your Site Domain Name Registration / Hosting Services Finding the appropriate Hosting space Publishing Website Using FTP-Client

4010005

Online 24/7; sessions starting 02/05/2018,ending 03/02/2018

Tuition: $245.00

Supply Fee: $0.00

Location : Online



View Details »