Excel Best Practices for PC: Become an Excel Expert

by Training The Street (TTS) Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Training The Street (TTS) Logo

img Duration

8 Hours

Course Details

Learning Outcomes:

  • Basic Excel setup including iterations & calculations settings
  • 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

  • New York Branch

    275 Madison Avenue 12th Floor, Suite 1201, New York

Check out more MS Excel courses in USA

Computers Etc Software Training Logo

MS Excel (Beginner)

This Excel class is recommended for anyone who hasn't worked with formulas or charts before or those with little or no experience with Excel. Great refresher course for students who haven't used Excel in a long time.

by Computers Etc Software Training [Claim Listing ]
Georgia State University Logo

Next-Level PowerPoint

We’ve all been forced to sit through really boring and ineffective presentations. PowerPoint doesn’t have to be that way! We’ll share and practice using design tips to help you transform your presentations from boring to brilliant.

by Georgia State University [Claim Listing ]
PD Training Logo

Microsoft Excel 2016 Advanced

The PD Training Microsoft Excel 2016 Advanced Training Course provides you with comprehensive training in the advanced features of Excel 2016, including creating and running Macros, Flash Fill, formulas and functions, data management, customizations, auditing, grouping and transporting data and sol...

by PD Training [Claim Listing ]
Tech Now Logo

Microsoft Access Level 1 & 2 (MS-432)

In MS-432: Microsoft Access Level 1 & 2  the student will examine the basic database concepts and create and modify databases and their various objects using the Access relational database application.

by Tech Now [Claim Listing ]
City College Of San Francisco Logo

Microsoft Excel

This course provides in-depth coverage of the concepts and techniques required to use Microsoft Excel to create spreadsheets to express, analyze, and solve business-related problems, and to assist in the preparation for the Microsoft Office Specialist Excel certification exam.

by City College Of San Francisco [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy