Whether you’re an investment banker, consultant, accountant, or specialist in healthcare, technology or industrials, this class offers the broadest, most valuable Excel skill set of any of course we offer.
DurationLearning Outcomes:
Excel best practices, including common “shortcut” keys and other efficiency tips
Best practices for building formulas (auto sum, filling, anchoring)
Customizing toolbars in Excel (including adding icons to your toolbar)
Auditing formulas and cell references
By utilizing both basic and advanced Excel tools, this course is designed to dramatically improve a participant’s ability to use Excel efficiently.
Whether you’re an investment banker, consultant, accountant, or specialist in healthcare, technology or industrials, this class offers the broadest, most valuable Excel skill set of any of course we offer.
This course is ideal
The financial services industry (investment banking, consulting, research, asset management, brokerage, sales & trading, insurance, private equity, venture capital, entrepreneurship and start-ups)
Corporate/strategic development or finance group of a corporation
Marketing, brand management or operations for a corporation or any position responsible for a product or divisional budget, projections and profit/loss statement
Enhancing their learning in finance and financial statement analysis classes
Non-finance roles, but interested in gaining a solid foundation in applied corporate finance
Topics Covered
Complete topics step by step or jump to any of the below at any time.
Basic Excel setup – macro security, iterations, calculations settings
Financial modeling essentials – appropriate color schemes, page setup, and customizing toolbars in Excel
Common shortcut keys and other efficiency tips
Understanding how to efficiently design historical inputs and forecast financial projections
Prerequisites
This course is open to all. To maximize the benefit of this course we recommend an understanding of financial statements and Microsoft Excel.
The Course is optimized for PC based Excel
Since 1999, Training The Street (TTS) offers targeted training courses to academic, corporate, and public enrollment clients. TTS provides unparalleled training and practical skills development in accounting, corporate finance, financial modeling, and valuation topics for finance professionals.
By incorporating a mix of hands-on instruction, computer-based exercises, mini-lectures, group projects, visual presentations, and practical illustrations, we teach you real-world applications of finance theory in a way that brings finance fundamentals to life.
Our differences make up the core of our strength
At Training The Street, we are committed to providing a safe and inclusive environment and strive wholeheartedly to be free from racism and discrimination of any kind.
We are therefore committed to going above and beyond to build a more just and equitable environment where all individuals can achieve their full potential.
It is the policy of Training The Street to provide and promote equal opportunity for all people without regard to race, color, creed, national origin, gender, age, sexual orientation, religion, marital status, familial status, veteran’s status, gender identity, or the presence of any sensory, mental, or physical disability.
We are proud to acknowledge that our differences make up the core of our strength.
The Academy’s Microsoft Office Specialist 2016 Boot Camp is a 5-day course that focuses on Word, Excel, and PowerPoint. This course prepares students for Microsoft Exams 77-725 (Word 2016), 77-727 (Excel 2016), 77-729 (PowerPoint 2016).
This Introduction to PowerPoint 2019 training class is designed for students who are interested in learning the fundamentals needed to create and modify basic presentations using Microsoft Office PowerPoint 2019.
Students will design, modify, and manage basic diagrams. You will create a workflow diagram, a network diagram, build organization charts, design a floor plan, and build cross- functional flowcharts.
In addition to basic formatting you'll learn how to cut & paste, copy and paste, set margins, line spacing, justification, add graphics, add borders & shading, add bullets & numbers, run Spell Checker & Grammar Checker, use the Thesaurus, add Special Symbols, use Find & Replace, and more!
Excel can help you organize, calculate, analyze, revise, update, and present your data like a pro. This entry level class will show you how to create and develop Excel worksheets and workbooks in order to work with and analyze the data, modify and format a worksheet, perform calculations.
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the USA, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore