Management Communication: Presenting Section Management Communication: Writing Section
Topics covered: Planning Writing Presenting.
You’ll learn how to manage and lead more effectively by organizing and executing successful business communication strategies. This course provides the skills and guided practice necessary to master important concepts in business communication. Topics covered: Ratio Analysis Cash Cycle and Growth Financial Forecasting Rearranging Financial Statements Capital Structure Time Value of Money and Project Valuation Risk and Return Valuing a Business. Narrated animations and numerous exercises help you grasp concepts quickly. Financial issues are presented within the fictional Golden State Canning Company, which provides a meaningful context that helps in mastering financial concepts. Spreadsheet Modeling: Introductory SectionĮxplore introductory concepts in finance ranging from ratio analysis to valuation. See more »Īuthors: Wayne Winston and Sarah Fairchild Sherry Topics covered: The Excel Environment Working with Data: Basic Techniques Increasing Spreadsheet Readability Excel Formulas Useful Excel Functions Charts Importing Data into Excel The Art of Spreadsheet Modeling Using Excel Solver Three Dimensional Formulas and the Table Feature Monte Carlo Simulation. Narrated animations, videos, and “do-it-yourself” exercises help you learn how to best design and structure spreadsheets to maximize their benefit in solving business problems. Learn how to use Microsoft Excel 2013 to create and leverage spreadsheet models to analyze both simple and complex business problems.
The essential skills that every professional needs to succeed. pre- and post-assessment tests to help you evaluate your strengths and weaknesses.practical exercises with real-world examples.an introduction to an essential management topic.Introducing self-paced learning programs from Harvard Business Reviewĭeveloped by Harvard Business School faculty for use in MBA and executive education courses at Harvard Business School and other leading business schools, our self-paced learning programs offer comprehensive introductions in their subject areas and provide the fundamental skills that every business professional needs to succeed. You can change this by right clicking on it and choosing which summaries to show.Online Courses Need to boost your job performance? We can help. The status bar also shows quick summaries of selected cells (count, sum, average, minimum or maximum values). You can tell if Excel is busy calculating a formula, creating a pivot report or recording a macro by just looking at the status bar. Status bar: This tells us what is going on with Excel at any time. If you want to access other sheets, just click on the sheet name (or use the shortcut CTRL+Page Up or CTRL+Page Down).ĥ. To see more rows or columns you can use the scroll bars to the left or at bottom. But the spreadsheet grid shows few rows & columns of active spreadsheet. Each Excel file can contain several sheets. Spreadsheet Grid: This is where all your numbers, data, charts & drawings will go. You will understand the relevance of it once you start building formulas.Ĥ. Formula Bar: This is where any calculations or formulas you write will appear. The most important ribbons are – Home, Insert, Formulas, Page Layout & Data.ģ. Since Excel has 1000s of features, they are grouped in to several ribbons. It depicts all the features of Excel in easy to understand form. But you can add any feature of Excel to to Quick Access Toolbar so that you can easily access it from anywhere (hence the name).Ģ. When you start Excel for the very first time, it has only 3 icons (Save, Undo, Redo). Quick Access Toolbar: This is a place where all the important tools can be placed. There are 5 important areas in the screen.ġ. When you open Excel, this is how it looks. So one of the basic survival skills is to understand how to navigate Excel and access the features you are looking for.
It is very easy to get lost once you open Excel. Excel is a massive application with 1000s of features and 100s of ribbon (menu) commands.