Microsoft Excel has a wide array of versatility and application across countless industries. However, it can be very particular in how the formulas need to be written to reference images, cells, sheets, and even other files. In this project, we discuss navigating the web of connections Excel is capable of, in hopes of making your life just a little bit easier.

Writing well is one of the most important skills you can develop to be successful in the business world. Over seventy companies and thirty thousand students--from professional writers to new employees to non-native English speakers to seasoned executives--have used the techniques in Business Writing to power their ability to communicate and launch their ideas. This course will teach you how to apply the top ten principles of good business writing to your work, how to deploy simple tools to dramatically improve your writing, and how to execute organization, structure, and revision to communicate more masterfully than ever. From the very first lesson, you'll be able to apply your new learning immediately to your work and improve your writing today. Your ideas are powerful. Learn how to deliver them with the clarity and impact they deserve. "Thank you for giving me the knowledge I need in life. [Business Writing] was helpful, life changing, and has made a huge impact in my writing." -- Message from a Business Writing student The principles you'll learn in this course enable you to become a great business writer. They also provide the foundation for moving into Graphic Design and Successful Presentation, so that you can unleash your best professional self whenever--and however--you present your ideas in the workplace. This course can be taken for academic credit as part of CU Boulder’s Master of Science in Data Science (MS-DS) degree offered on the Coursera platform. The MS-DS is an interdisciplinary degree that brings together faculty from CU Boulder’s departments of Applied Mathematics, Computer Science, Information Science, and others. With performance-based admissions and no application process, the MS-DS is ideal for individuals with a broad range of undergraduate education and/or professional experience in computer science, information science, mathematics, and statistics. Learn more about the MS-DS program at https://www.coursera.org/degrees/master-of-science-data-science-boulder.

In this project you will learn to use the searching, sorting, and filtering features of Microsoft Excel. Using the free version of Office 365’s Excel for the web, you will manipulate spreadsheet data to make it more useful for effective business decision-making. Using a filter, you’ll isolate just the data needed. You can then sort it into a logical sequence that can turn data into the information needed for effective decision making.

This Innovation and Entrepreneurship course focuses on the interconnection between entrepreneurial thinking and innovation. Specifically, we look at models used in Silicon Valley to grow both start-up companies as well as innovation inside large organizations. Bringing together top Haas School of Business, UC Berkeley faculty, this course addresses critical areas for successful growth, including design thinking, open innovation, business models, product-market fit, and financing. This course will teach you how to think like an entrepreneur and provide you with the models, tools, and frameworks to further develop your business or idea. An emphasis will be placed on the IT space. In this first part, From Basics to Open Innovation, the following areas are included: innovation and entrepreneurship basics; the Silicon Valley entrepreneurship model; the importance of failure; market analysis: how to engage with customers; and open innovation.

In this third course, you will learn about liability and equity accounts and its effect on the balance sheet. If you have mastered bookkeeping basics and understand accounting assets, you are ready to jump into Liabilities and Equity in Accounting. You will explore the various types of liability, including: current and long term, payroll, and sales tax. Additionally, you will learn about the equity portion of the accounting equation and how to account for changes in owner’s equity. By the end of this course, you will be able to: -Describe the three main characteristics of liabilities. -Demonstrate an understanding of the basic payroll accounting functions and tasks. -Compare and contrast the different types of equity -Use the accounting equation to describe the financial position of an organization. Courses 1 and 2 in the Intuit Bookkeeping Professional Certificate, or the equivalent, are recommended prerequisites for this course.

In this project, you will learn how to analyze data and identify trends using a variety of tools in Microsoft Excel. Conditional formatting and charts are two tools that focus on highlighting and representing data in a visual form. With conditional formatting, you can define rules to highlight cells using a range of color scales and icons and to help you analyze data and identify trends or outliers. You will then use PivotTables to create summaries of the data that focuses on specific relationships which you will represent as a line chart and column chart. Both conditional formatting and charts are two useful ways of visually analyzing data and exploring trends.

Powtoon is a free cloud platform that allows the user to design animated presentations to better engage and educate their desired audience. In this course, we will design an attractive and educational animated training video. Adding animation to your presentation through movement of text and graphics creates a more dynamic and eye catching experience for your viewer. Powtoon can help you design an effective presentation where your information is displayed in an organized and well-timed fashion. Animation allows you to present material in a fun, visually enhanced way which can improve audience engagement and add emphasis to key ideas and concepts. Powtoon provides a number of free presentation options that can get you well on your way to becoming a better animator and video designer. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

The goal of this third course in the Project Management Specialization examines the philosophy and process of managing projects using Agile project management. Students in this course will learn the Agile philosophy and process including the Scrum framework, sprints, and user stories. Upon completion of this course, you will be able to distinguish between predictive and agile project management methodologies and understand the benefits of delivering value early in an engineering project. This course can be taken for academic credit as part of CU Boulder’s Master of Engineering in Engineering Management (ME-EM) degree offered on the Coursera platform. The ME-EM is designed to help engineers, scientists, and technical professionals move into leadership and management roles in the engineering and technical sectors. With performance-based admissions and no application process, the ME-EM is ideal for individuals with a broad range of undergraduate education and/or professional experience. Learn more about the ME-EM program at https://www.coursera.org/degrees/me-engineering-management-boulder. Logo image courtesy of Alex Lion, available on Unsplash at https://unsplash.com/photos/qOvxHjOrx4k

This Capstone builds on the communication and content skills you’ve acquired throughout the Specialization and develops them further. During course lessons and Peer Assessments you will practice and expand the language skills necessary for success in the professional world. Throughout the course, you will have the opportunity to complete assessments relevant to the working world. In this course, you will: * Study cultural influences on communication more thoroughly, identify key cultural influences in your own experience and compare your culture with a different one to identify ways to improve communication and decrease misunderstanding. * Develop your email accuracy and style and engage in email correspondence with potential employers, clients or investors to set up interviews and/or meetings. * Practice and Demonstrate fluent and accurate spoken English as you prepare and present a short talk about a personal accomplishment or “Sales Pitch” for a product or service. * Polish your pronunciation through more connected speech including use of through groups, contractions/reductions, and linking. Week by week, as you practice your language skills, make connections with people important to you and develop your network, you will increase your opportunities for success. Completing this Capstone Project will help you reach your English language and professional goals now and in the future.

In this 2-hour long project-based course, you will learn how to create effective charts and a dynamic dashboard to visualize data sets. You will be able to work with vlookups, pivot tables and basic formulas and be able to create dynamic charts, sparklines, and a robust, dynamic dashboard to present the data. By the end of the project you will be able to: - Understand the terminologies of spreadsheets - Work with basic formulas in Google Sheets - Create 8 Basic Charts for visualizing data - Generate Dynamic Charts from a dropdown list - Generate Sparklines to represent data - Build a dashboard and introduce Basic and Advanced Charts - Use Slicers to filter data and create a robust and dynamic dashboard Note: If you don't have a Google account, you will need to create one to be able to complete the content.