Excel for Business Level I is the first of a three part series that aims to tackle the most common and practical uses of Excel in business. This is the perfect course for those who are either new to Excel or would like to improve their understanding and efficiency of its applications in business. By the end of this course, you will feel confident navigating through worksheets and working with formulas, databases, charts, formatting, shortcuts and printing. The skills you take away from this course will prove crucial to building a strong resumé and boosting your job performance. The course comes with a revolutionary video tutorial suite, and is taught by engaging instructors with several years of in-field and training experience.
Provides a brief description of the user interface for Microsoft Excel
Examines and describes multiple means of entering data
Perform mathematical expressions and review the Order of Operations rule
Introduces functions used to modify text in Excel
More advanced functions that require more than one input
Changing a cell reference into a constant, which is necessary in certain calculations
The addition of effects to an excel document to provide visual instruction
Use the Format Painer to copy format a from one cell (or range of cells) to another
Create rules that govern specific cell ranges and apply a predetermined format when those rules are triggered
Create a Column chart to visually examine data
Create a Pie chart to visually examine data
Explores the special functionality created when data is converted to a Table
End of class project to review key concepts from the class
NYIM is the premier computer software training company in NYC, with two decades of exceptional service provided to thousands of business professionals. NYIM's courses are taught by the leading industry professionals, with an engaging and interactive teaching approach. Our curriculums have been refined over years and focus on practical and hands-on applications for day-to-day business needs.