Online Course in Applied Finance in USA

Search Online Courses in Applied Finance in USA 2017

Applied Finance

The USA remains the world’s most popular destination for international students. Universities in the US dominate the world rankings and the country also offers a wide variety of exciting study locations. State university systems are partially subsidized by state governments, and may have many campuses spread around the state, with hundreds of thousands of students.

Online Course in Applied Finance in USA

Read More

Course in Career Success (Beginner)

Coursera
Online Part time Open Enrollment USA USA Online

This series of courses will help you build, develop and hone the essential skills needed to improve your employability and advancement in today’s dynamic workforce. The courses in this Specialization may be taken in any order. Each course can also be taken independently. [+]

Online Courses in Applied Finance in USA. This series of courses will help you build, develop and hone the essential skills needed to improve your employability and advancement in today’s dynamic workforce. The courses in this Specialization may be taken in any order. Each course can also be taken independently. The Specialization concludes with a Capstone project that will give you the opportunity to integrate and apply the skills you have gained throughout the courses to your individual and organizational needs. Courses Project Management: The Basics for Success This course combines the essential elements of Project Management and Team Leadership into one course. Through class engagement and reflection, you will acquire further understanding of the responsibilities of leadership and become better prepared to apply this knowledge to the project environment. Work Smarter, Not Harder: Time Management for Personal & Professional Productivity You will be able to gain and apply your knowledge and understanding of personal and professional awareness, organization and commitment, and use the tools, methods and techniques that you have learned in goal setting, prioritization, scheduling, and delegation to overcome time management challenges and enhance productivity. Finance for Non-Financial Professionals Impact your financial decisions and learn how to affect the performance of your unit's profitability and of your organization. In this course gain a basic understanding of finance and accounting concepts to drive your organization's growth. Upon completion of this course, you will have gained general financial knowledge and an in-depth understanding of the impact of your decisions outside your functional area. Content of the course includes selected aspects of finance from a non-financial specialist perspective. Specific topics include: financial analysis; planning, forecasting, and budgeting; cash flow, and strategic financing. This class will be interactive and will require the active involvement of the participants in finance related activities. Communication in the 21st Century Workplace In today's fast-paced business environment, employees at all levels find themselves being asked to handle more tasks, meet more deadlines, take on more responsibilities, and adapt to more change. Added to these challenges is the constantly shifting diversity of the workplace, where coworkers cope with generational, gender, age and cultural differences. Communication, both verbal and nonverbal, is at the foundation of everything we do and say, and is especially important in the 21st century workplace. The good news is that communication is a learned skill, and can be improved upon with the right training. The focus of this course is to heighten students’ awareness of workplace communication, and add new interpersonal skills, with the end result of becoming a more competent communicator overall. Target areas include: the process and functions of communication, behavioral patterns, perceptions as reality, verbal and nonverbal cues and behaviors, confidence, assertiveness, tact, anger management, criticism and constructive feedback, conflict resolution, team building, leadership, interviewing, and communicating more effectively with technology (email, Skype, texting, etc.). High-Impact Business Writing Effective writing is a powerful tool in the business environment. Learn how to articulate your thoughts in a clear and concise manner that will allow your ideas to be better understood by your readers. Improve your business writing skill by learning to select and use appropriate formats for your audience, use the correct medium and adjust your writing style accordingly, as well as identify your objective and communicate it clearly. You'll also learn to spot, correct and avoid the most common writing pitfalls, and gain valuable experience analyzing, writing and revising a wide spectrum of business documents. From a simple interoffice memo to a twenty-page business proposal, learn how to put good business writing to work for you. The Art of Negotiation The art of negotiation comes into play daily in the life of employees at all levels and in every position. Participants explore how current approaches to negotiation strategy and tactics are used, what negotiation entails, types of negotiation relationships that exist from hard bargain to win-win, to fully partnered relationships and personal ones. The course explores the personal and behavioral characteristics of an effective negotiator. Participants discuss how empowerment, power, and authority affect the negotiation process and outcome. Topics include how important it is to plan and prepare for a negotiation session. Fundamentals of Management Are you about to enter the workforce? Are you an emerging professional? Are you new to your role in the organization? All prospective new employees benefit from understanding management principles, roles and responsibilities, regardless of position. Now you can acquire an in-depth understanding of the basic concepts and theories of management while exploring the manager's operational role in all types of organizations. Gain insight into the manager's responsibility in planning, organizing, leading, staffing and controlling within the workplace. It’s never too soon to plan your professional path by learning how the best managers manage for success! Effective Problem-Solving and Decision-Making Critical thinking – the application of scientific methods and logical reasoning to problems and decisions – is the foundation of effective problem solving and decision making. Critical thinking enables us to avoid common obstacles, test our beliefs and assumptions, and correct distortions in our thought processes. Gain confidence in assessing problems accurately, evaluating alternative solutions, and anticipating likely risks. Learn how to use analysis, synthesis, and positive inquiry to address individual and organizational problems and develop the critical thinking skills needed in today’s turbulent times. Using case studies and situations encountered by class members, explore successful models and proven methods that are readily transferable on-the-job. Essentials of Entrepreneurship: Thinking & Action Success in business can be greatly enhanced with an understanding of key entrepreneurial characteristics and competencies solutions. This interactive course provides potential entrepreneurs with the knowledge of succeeding in an entrepreneurial opportunity. Topics include: how creativity, opportunity and feasibility are best evaluated; business strategies for new businesses; importance of a business plan; achieving success in a new business. At the end of the course students will have the skills and confidence to evaluate starting a business, in addition to becoming more enterprising in how they approach their roles should they decide to work in organizations. Career Success Project The purpose of the Capstone Project in the Career Success Specialization is for you to apply the methods and techniques you learned in the series of courses to a personal experience, giving you a way to communicate your value to potential employers. You’ll focus your communication, management, negotiation, problem solving, business writing, time management, finance, entrepreneurship, and project management skills into a single project that demonstrates your career readiness. [-]

Course in Investment Management (Beginner)

Coursera
Online Part time Open Enrollment USA USA Online

In this Specialization, you will understand how investment strategies are designed to reach financial goals in a global context. You will learn the theory that underlies strong investment decisions, as well as practical, real-world skills that you can apply when discussing investment proposals with your advisor, managing your personal assets or your client’s investment portfolio. [+]

In this Specialization, you will understand how investment strategies are designed to reach financial goals in a global context. You will learn the theory that underlies strong investment decisions, as well as practical, real-world skills that you can apply when discussing investment proposals with your advisor, managing your personal assets or your client’s investment portfolio. You will start by developing a global understanding of financial markets and what impacts rational and irrational behaviors have in finance at the micro and macro levels. You will then learn how to adequately build and manage a portfolio with a long-term view while gaining an appreciation for novel research advances in finance and related areas as well as future trends that are shaping the investment management industry. In the final Capstone Project, you will create a sensible 5-year investment plan that accounts for an investor's goals and constraints in a dynamic economic landscape. Key speakers from UBS, our corporate partner, will contribute to this specialization by providing you with practical insights they have gathered through years of experience working for the world’s largest wealth manager. Course Understanding Financial Markets In this course, you will learn what the main financial markets and their characteristics are as well as how they are linked to the economy. Our very diversified team of experts will start by teaching you how the price of stocks and bonds are computed and why they move while you will become increasingly aware of the notion of risk and why it matters when measuring an investment's performance. The focus will then move to less popular markets such as gold, emerging markets, real estate, hedge funds and private markets. These will be analyzed with an emphasis on their particular risks and return opportunities as well as how they can help in building efficient portfolios. Finally, the policies of central banks and their impact on financial markets will be presented to you along with the link between the economy and the price of financial assets. All along these different steps, experts from UBS, our corporate partner, will show you how the concepts you just acquired are effectively applied in a leading global bank. This focus on practicality means you will not only understand what is going on in global financial markets but also start to figure out how you can use them to achieve financial goals, be it a client's or your own. Meeting Investors' Goals In this course, you will dive into the concepts of rationality and irrationality and understand how they impact our investment decisions and what the consequences can be at the market level. You will first explore the different biases that we, as humans, are subjected to when facing investment decisions and how they may impact the outcomes of these decisions. Moreover, you will see how emotions and ethical concerns such as honesty and trust influence market participants. When they are considered as a group rather than individually, you will discover how rationality and irrationality can drive asset prices to and away from their fair value. Finally, you will be presented with different portfolio construction methodologies and investment styles that make up the landscape of today's portfolio management industry. At key points throughout the course, you will benefit from the practical knowledge of experts from our corporate partner, UBS, in how to build and manage clients' portfolios. Portfolio and Risk Management In this course, you will gain an understanding of the theory underlying optimal portfolio construction, the different ways portfolios are actually built in practice and how to measure and manage the risk of such portfolios. You will start by studying how imperfect correlation between assets leads to diversified and optimal portfolios as well as the consequences in terms of asset pricing. Then, you will learn how to shape an investor's profile and build an adequate portfolio by combining strategic and tactical asset allocations. Finally, you will have a more in-depth look at risk: its different facets and the appropriate tools and techniques to measure it, manage it and hedge it. Key speakers from UBS, our corporate partner, will regularly add a practical perspective on these different topics as you progress through the course. Securing Investment Returns in the Long Run In this course, you will learn about the famous dichotomy between active and passive investing, how to appropriately measure and analyze investment performance and what the future trends in the investment management industry are. You will first learn about absolute and relative performance, risk-adjusted returns and how to decompose investment performance. The focus will then shift to the two main categories of investment vehicles, active and passive funds, and what they entail in terms of expected performance. Finally, you will explore the worlds of sustainable finance, neurofinance and fintech, three areas of research that will shape the future of the investment management industry. You will also benefit from the insights of experts from UBS, our corporate partner, on the practical implementation of the various concepts we will develop in this course. Planning your Client's Wealth over a 5-year Horizon In this Capstone project, you will have to choose between three different characters (each with a unique set of financial constraints and objectives) and design an appropriate wealth plan for them over the next 5 years. You will have to use the knowledge you gained in each of the four preceding courses to reach that objective. Indeed, you will need to know which assets to consider and how to manage them depending on changes in the economic outlook (Course 1), how to evaluate and deal with your character's emotional biases in order to suggest them a wealth strategy they will be able to follow (Course 2), how to build an optimal portfolio and manage its risk once the strategy has been designed (Course 3) and how to adequately measure the performance of your plan while taking advantage of investment vehicles and future trends in the investment management industry to further your character's goals (Course 4). This Capstone project was designed in collaboration with UBS, our corporate partner, who benefits from years of experience in guiding clients with their wealth planning. [-]

Course in Business and Financial Modeling (Beginner)

Coursera
Online Part time 6 months Open Enrollment USA USA Online

Wharton's Business and Financial Modeling Specialization is designed to help you make informed business and financial decisions. These foundational courses will introduce you to spreadsheet models, modeling techniques, and common applications for investment analysis, company valuation, forecasting, and more. [+]

Online Courses in Applied Finance in USA. Wharton's Business and Financial Modeling Specialization is designed to help you make informed business and financial decisions. These foundational courses will introduce you to spreadsheet models, modeling techniques, and common applications for investment analysis, company valuation, forecasting, and more. When you complete the Specialization, you'll be ready to use your own data to describe realities, build scenarios, and predict performance. Courses Fundamentals of Quantitative Modeling How can you put data to work for you? Specifically, how can numbers in a spreadsheet tell us about present and past business activities, and how can we use them to forecast the future? The answer is in building quantitative models, and this course is designed to help you understand the fundamentals of this critical, foundational, business skill. Through a series of short lectures, demonstrations, and assignments, you’ll learn the key ideas and process of quantitative modeling so that you can begin to create your own models for your own business or enterprise. By the end of this course, you will have seen a variety of practical commonly used quantitative models as well as the building blocks that will allow you to start structuring your own models. These building blocks will be put to use in the other courses in this Specialization. Introduction to Spreadsheets and Models The simple spreadsheet is one of the most powerful data analysis tools that exists, and it’s available to almost anyone. Major corporations and small businesses alike use spreadsheet models to determine where key measures of their success are now, and where they are likely to be in the future. But in order to get the most out of a spreadsheet, you have know how to use it. This course is designed to give you an introduction to basic spreadsheet tools and formulas so that you can begin harness the power of spreadsheets to map the data you have now and to predict the data you may have in the future. Through short, easy-to-follow demonstrations, you’ll learn how to use Excel or Sheets so that you can begin to build models and decision trees in future courses in this Specialization. Basic familiarity with, and access to, Excel or Sheets is required. Modeling Risk and Realities Useful quantitative models help you to make informed decisions both in situations in which the factors affecting your decision are clear, as well as in situations in which some important factors are not clear at all. In this course, you can learn how to create quantitative models to reflect complex realities, and how to include in your model elements of risk and uncertainty. You’ll also learn the methods for creating predictive models for identifying optimal choices; and how those choices change in response to changes in the model’s assumptions. You’ll also learn the basics of the measurement and management of risk. By the end of this course, you’ll be able to build your own models with your own data, so that you can begin making data-informed decisions. You’ll also be prepared for the next course in the Specialization. Decision-Making and Scenarios This course is designed to show you how use quantitative models to transform data into better business decisions. You’ll learn both how to use models to facilitate decision-making and also how to structure decision-making for optimum results. Two of Wharton’s most acclaimed professors will show you the step-by-step processes of modeling common business and financial scenarios, so you can significantly improve your ability to structure complex problems and derive useful insights about alternatives. Once you’ve created models of existing realities, possible risks, and alternative scenarios, you can determine the best solution for your business or enterprise, using the decision-making tools and techniques you’ve learned in this course. Wharton Business and Financial Modeling Capstone In this Capstone you will recommend a business strategy based on a data model you’ve constructed. Using a data set designed by Wharton Research Data Services (WRDS), you will implement quantitative models in spreadsheets to identify the best opportunities for success and minimizing risk. Using your newly acquired decision-making skills, you will structure a decision and present this course of action in a professional quality PowerPoint presentation which includes both data and data analysis from your quantitative models. Wharton Research Data Services (WRDS) is the leading data research platform and business intelligence tool for over 30,000 corporate, academic, government and nonprofit clients in 33 countries. WRDS provides the user with one location to access over 200 terabytes of data across multiple disciplines including Accounting, Banking, Economics, ESG, Finance, Insurance, Marketing, and Statistics. [-]

Budget and Financial Reports Online Short Course

Courses for Success
Online Part time Open Enrollment USA USA Online

Everyday businesses deal with budgets and financial reports in some form or fashion. At minimum, business managers review budget numbers and run financial reports for decision-making and reporting to shareholders and Federal regulators once a month. [+]

Back Your Business with Bulletproof Finance Everyday businesses deal with budgets and financial reports in some form or fashion. At minimum, business managers review budget numbers and run financial reports for decision-making and reporting to shareholders and Federal regulators once a month. Many companies devote the last few months of the calendar year to creating budgets for the next calendar year. In addition, organizations create and disseminate year-end financial reports to investors. The goal of this course is to give the participant a basic understanding of budgets and financial reports so they can hold relevant discussions and render decisions based on financial data. This course will define key terms like ROI, EBIT, GAAP, and extrapolation. Furthermore, this course will discuss commonly used financial terms, financial statements, budgets, forecasting, purchasing decisions, and laws that regulate the handling of financial information. By the end of this Budget and Financial Reports Online Short Course, you will be able to: Identify financial terminology Understand financial statements Identify how to analyse financial statements Understand budgets How to make budgeting easy Understand advanced forecasting techniques Understand how to manage the budget Identify how to make smart purchasing decisions Identify the legal aspects of finances Course Fast Facts: Easy to follow and understand Only 6 to 8 hours of study is required 12 months access to course Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your own pace, in your own time Download printer friendly course content Certificate (IAOTS Accredited) Course Delivery Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone. Recognition & Accreditation These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction. Units of Study Module One - Getting Started Module Two - Glossary What is Finance? Commonly used Terms Key Players Important Financial Organisations Understanding GAAP Module Three - Understanding Financial Statements Balance Sheets Income Statements (AKA Profit and Loss Statements) Statement of Retained Earnings Statement of Cash Flow Annual Reports Module Four - Analysing Financial Statements (Part 1) Income Ratios Profitability Ratios Liquidity Ratios Working Capital Ratios Bankruptcy Ratios Module Five - Analysing Financial Statements (Part 2) Long - Term Analysis Ratios Coverage Ratios Leverage Ratios Calculating Return on Investment (ROI) Module Six - Understanding Budgets Common types of budgets What information do I need? Who should be involved? What should a budget look like? Module Seven - Budgeting Made Easy Factoring in historical data Gathering related information Adjusting for special circumstances Putting it all together Computer based methods Module Eight - Advanced Forecasting Technigues Using the average Regression Analysis Extrapolation Formal Financial Models Module Nine - Managing the Budget How to tell if you're on track Should your budget be updated Keeping a diary of lessons learned When to panic Module Ten - Making Smart Purchasing Decisions 10 questions you must ask Determining the Payback period Deciding whether to lease or buy Thinking outside the box Module Eleven - A Glimpse into the Legal World A brief history The Sarbanes-Oxley Act CEO / CFO Certification 8th Company Law Directive Module Twelve - Wrapping Up Words from the Wise WILLIAM ARTHUR WARD - Wise are those who learn that the bottom line doesn't always have to be their top priority W. CLEMENT STONE - Try, try, try and keep on trying is the rule that must be followed to become an expert in anything COLIN POWELL - There are no secrets to success. It is the result of preparation, hard work and learning from failure. Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

The Ultimate Financial Management Training Bundle, 10 Courses

Courses for Success
Online Part time Open Enrollment USA USA Online

The Ultimate Financial Management Training Bundle contains 10 key courses that will equip you with the knowledge, skills and confidence to not only find but get the most out of new career opportunties! [+]

Online Courses in Applied Finance in USA. EXCLUSIVE ONLY AT KEYSTONE ACADEMY! Learn Key Financial Management Skills Suitable for any Business The Ultimate Financial Management Training Bundle contains 10 key courses that will equip you with the knowledge, skills and confidence to not only find but get the most out of new career opportunities! This comprehensive online course bundle includes resume writing, communication strategies, self confidence, goal setting, stress management and much more! By working through this Financial Management Course package you will be able to take control of your finances or even take the performance of your accounts department to the next level. Included in this bundle is both our Budget & Financial Reports and Basic Bookkeeping courses which will give you a powerful foundation to work from, these comprehensive courses are filled with knowledge you can put straight into practice in your workplace. The Time Management and Organizational Skills courses also will give you a massive boost in your productivity while building solid organizational skills that will help you prioritize and achieve your day to day and even career goals. Finally this course bundle features a great set of Microsoft courses covering Excel 2013 & 2010 at beginner, advanced and expert levels so you can master the version of Excel you use in your workplace, you'll be the office Excel guru once you've completed these. This is an incredible opportunity to invest in yourself and your future, Sharpen Your Financial Management Skills with Courses For Success Today! Course Fast Facts: All courses are easy to follow and understand Only 6 to 8 hours of study is required per course Unlimited Lifetime Access Study as many courses as you want Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your own pace, in your own time Download printer friendly course content Certificates (IAOTS Accredited) How to study online course? Upon enrolment an automated email will be sent, advising you of our enrolment process (please check your junk email inbox if not received as this is an automated email), in order for you to access your online material, which is Available 24/7 on any computer or smart mobile device. Recognition & Accreditation These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction. Units of Study Receive Lifetime Access to Course Materials, so you can review at any time. The Ultimate Financial Management Training Bundle, 10 Courses, below is a summary of each course: Course 1 - Certificate In Budget and Financial Reports Online Course Back Your Business with Bulletproof Finance Understanding Financial Statements Balance Sheets Income Statements (AKA Profit and Loss Statements) Annual Reports Analysing Financial Statements Income Ratios Profitability Ratios Liquidity Ratios Working Capital Ratios Bankruptcy Ratios Long - Term Analysis Ratios Calculating Return on Investment (ROI) Understanding Budgets Common types of budgets What information do I need? Who should be involved? What should a budget look like? Budgeting Made Easy Computer based methods Advanced Forecasting Technigues Managing the Budget How to tell if you're on track Should your budget be updated Keeping a diary of lessons learned When to panic Making Smart Purchasing Decisions A Glimpse into the Legal World Course 2 -Certificate In Basic Bookkeeping Online Course Understand and Implement Basic Bookkeeping Principles Basic terminology Accounts Receivable Accounts Payable Inventory Payroll Accounting Methods Differences between Cash and Accrual Cash Management Keeping track of your business Understanding the balance sheet Types of Assets Types of Liabilities Equity Other financial statements Income Statement Cash Flow Statement Capital Statement Budget vs Actual Payroll accounting / terminology End of period procedures Financial Planning, budgeting and control Reasons for Budgeting Creating a Budget Comparing Budget to Actual Expenses Auditing Course 3 - Certificate In Time Management Online Course Better manage your time to be the highest achiever Create SMARTER Goals Prioritizing Your Goals Visualize your Goals-Visualization Setting SMART goals Prioritizing your time The 80/20 Rule Being Assertive...Saying “NO” to Requests you can’t meet. Planning wisely Using To Do List Tackling procrastination Why We Procrastinate Nine Ways to Overcome Procrastination Crisis management When Crisis Calls...do you have a Contingency Plan? Creating a Plan Executing the Plan Organizing your workspace De-Clutter Managing Workflow Dealing with E-mail...email etiquette Using Calendars Delegating made easy Setting a ritual Metting management Alternatives to meetings Course 4 - Certificate In Organizational Skills Online Course Achieve Your Goals By Being Organized and Productive Just do it You don't have to keep everything Three boxes: Keep, donate and trash A place for everything and everything in it's place Prioritize Write it down Urgent / Important Matrix Divide tasks 80/20 rule Scheduling your time Have a master calendar Setting deadlines Remove or limit the time wasters Coping with things outside of your control To do lists Use a day planner Finish what you start Focus on the important Do quick tasks immediately Paper and paperless storage Find a system that works for you Make it consistent Make it time sensitive Setting up archives Organization in your work area Tools to fight procrastination Remove distractions Give yourself a reward Break up large tasks Organising your inbox Setting delivery rules Folder and message hierachy Deal with email right away Flag and highlight important item Avoid the causes of disorganization Discipline is the key to staying organized Stay within your systems Learn to say No Have organisation be part of your life Plan for tomorrow, today Courses 5 & 6 - Certificate In Excel 2010 & Certificate In Essentials 2013 Online Course Learn the basics of the best version of excel for you Opening Excel Opening Excel Understanding the Interface Using Backstage View Understanding Worksheets Understanding Workbooks Working with the interface Your first worksheet An Overview of Excel’s Views Switching Views Creating Custom Views Using Zoom Switching Between Open Files Viewing Excel data Building formulas Using Excel functions Formulas vs. Functions Using the SUM Function Using Other Basic Excel Functions Understanding the Formulas Tab Using the Status Bar to Perform Calculations Understanding the New Function Names Using quick analysis Formatting your data Using styles, themes and effects Printing and sharing your workbook Course 7 & 8 - Certificate In Excel 2010 & Certificate In Advanced 2013 Online Course Learn advanced excel features Insert SmartArt Add text to a diagram Resize and move a diagram Reset a diagram Understand the contextual tabs Add pictures from your computer Add Clip Art Add text boxes Draw shapes Trace precedent cells Trace dependents of a cell Display formulas within the sheet Work with comments Insert a chart Use the Chart Tools tab Understand the parts of a chart Change the chart style Resize and move a chart Insert a Pivot Table Use the Pivot Table Tools tab Choose fields and group data in a Pivot Table Change Pivot Table data and refresh the view Apply a Style to a Pivot table Use Real-life examples in a Pivot Table Create a Pivot Chart from a Pivot Table Create a Pivot Chart from Data Display the Developer tab and much more. Grouping and outlining data Courses 9 & 10 - Certificate In Excel 2010 & Certificate In Expert 2013 Online Short Course Working with Permissions and Options Marking Workbook as Final Protecting the Current Sheet or the Workbook Structure Saving a Workbook as an Excel Template Editing a Shared Workbook Performing Advanced Formula and Function Tasks About the Excel Calculation Process Enabling or Disabling Automatic Workbook Calculations Using the IFERROR Function to Evaluate Formulas Working with Array Formulas Creating One-Dimensional and Two-Dimensional Constants Creating a Simple Array Creating an Advanced Array Working with Date and Time Functions Working with Financial Functions Working with Text Functions Working with Cube Functions Working with Statistical Functions Running a Macro by Clicking an Area of a Graphic Object Configuring a Macro to Run Automatically Upon Opening the Workbook Changing a Macro Using a Data Form Using a List Box Control Using a Combo Box Control Using a Spin Button Control Using a Scroll Bar Control Applying Advanced Chart Features Working with PivotTables and PivotCharts Using the Automated Analysis Tools Add-In And much more! Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]