Online Courses >> Career Advantage

« back to courses page
Career Advantage
 

Advanced Excel 

ID:72949
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

Start date: 06/05/17

End date: 06/30/17

Total Cost: $195.00

Online 24/7; sessions starting 06/05/2017,ending 06/30/2017

Instructor : John Rutledge  

Location : Online



View Details »

Advanced Excel 

ID:73075
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

Start date: 08/07/17

End date: 09/01/17

Total Cost: $195.00

Online 24/7; sessions starting 08/07/2017,ending 09/01/2017

Instructor : John Rutledge  

Location : Online



View Details »

Advanced Excel 

ID:74878
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

Start date: 11/06/17

End date: 12/01/17

Total Cost: $195.00

Online 24/7; sessions starting 11/06/2017,ending 12/01/2017

Instructor : John Rutledge  

Location : Online



View Details »
Geared for professionals at every stage, this course provides resources and support to re-assess your career trajectory, develop the tools you need to launch yourself into a promotion, a new job or a whole new field. We will start with the basics – career assessments: who are you? what are you interested in? what are you good at? and where do you want to go? Then we will work on some research skills to find those opportunities or create them yourself. Lastly, each participant will craft the tools to take them to the next step – resumes, cover letters and other ways to reach out and cultivate your next career launch. Each participant will be able to customize their work to suit their unique direction and needs. This Career Preparation class is designed for people who are wanting to clarify their career options within a specific field or explore possibilities for a career change. The goal of the class is to help participants learn more about careers that match their interests and become more confident about career planning and strategic career moves. Agenda Unit 1 Skill and values identification Envisioning an “ideal career” Networking and research skills Basics of Job Search strategies Unit 2 Developing the Master Resume Understanding the resume & cover letter Selecting the right approach for networking Understanding informational interviews Unit 3 Draft #1 resume & cover letter Identifying professionals for an interview Social Network profile Unit 4 Final resume & cover letter Interviews & reports Wrap-up & resources

Start date: 07/03/17

End date: 07/28/17

Total Cost: $195.00

Online 24/7; sessions starting 07/03/2017,ending 07/28/2017

Instructor : Kassia Dellabough 

Location : Online



View Details »
Geared for professionals at every stage, this course provides resources and support to re-assess your career trajectory, develop the tools you need to launch yourself into a promotion, a new job or a whole new field. We will start with the basics – career assessments: who are you? what are you interested in? what are you good at? and where do you want to go? Then we will work on some research skills to find those opportunities or create them yourself. Lastly, each participant will craft the tools to take them to the next step – resumes, cover letters and other ways to reach out and cultivate your next career launch. Each participant will be able to customize their work to suit their unique direction and needs. This Career Preparation class is designed for people who are wanting to clarify their career options within a specific field or explore possibilities for a career change. The goal of the class is to help participants learn more about careers that match their interests and become more confident about career planning and strategic career moves. Agenda Unit 1 Skill and values identification Envisioning an “ideal career” Networking and research skills Basics of Job Search strategies Unit 2 Developing the Master Resume Understanding the resume & cover letter Selecting the right approach for networking Understanding informational interviews Unit 3 Draft #1 resume & cover letter Identifying professionals for an interview Social Network profile Unit 4 Final resume & cover letter Interviews & reports Wrap-up & resources

Start date: 10/02/17

End date: 10/27/17

Total Cost: $195.00

Online 24/7; sessions starting 10/02/2017,ending 10/27/2017

Instructor : Kassia Dellabough 

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.

Start date: 04/03/17

End date: 06/30/17

Total Cost: $495.00

Online 24/7; sessions starting 04/03/2017,ending 06/30/2017

Instructor : John Rutledge  

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.

Start date: 06/05/17

End date: 09/01/17

Total Cost: $495.00

Online 24/7; sessions starting 06/05/2017,ending 09/01/2017

Instructor : John Rutledge  

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.

Start date: 09/05/17

End date: 12/01/17

Total Cost: $495.00

Online 24/7; sessions starting 09/05/2017,ending 12/01/2017

Instructor : John Rutledge  

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.

Start date: 06/05/17

End date: 06/30/17

Total Cost: $195.00

Online 24/7; sessions starting 06/05/2017,ending 06/30/2017

Instructor : Fred Bayley 

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.

Start date: 08/07/17

End date: 09/01/17

Total Cost: $195.00

Online 24/7; sessions starting 08/07/2017,ending 09/01/2017

Instructor : Fred Bayley 

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.

Start date: 11/06/17

End date: 12/01/17

Total Cost: $195.00

Online 24/7; sessions starting 11/06/2017,ending 12/01/2017

Instructor : Fred Bayley 

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

Start date: 07/03/17

End date: 07/28/17

Total Cost: $195.00

Online 24/7; sessions starting 07/03/2017,ending 07/28/2017

Instructor : Amy Klous 

Location : Online



View Details »