About this Course:

This beginner-level course is designed for professionals who are willing to gain first-hand knowledge of Microsoft Excel 2013. This course helps professionals build familiarity with key formulas and functions of Excel 2013. Professionals get to learn the frequently-used formulas used in Spreadsheet Creation, Tables & Graphs Insertion, and other fundamental functions. This course covers the key concepts of Excel 2013 such as Ribbon and Quick Access Toolbar, Interface, Backstage View, Shortcuts, and many more.

Professionals will also get to learn the fundamental functions & formulas of Excel 2013 involved in Worksheet Designs & Themes, Freezing Panes Option, Customized Viewing, and Worksheets Grouping. Professionals having the surface knowledge of the Microsoft Excel fundamentals can greatly benefit from this course and will get to know about the upgrades and new features in the 2013 version.

Microsoft Excel is an incredibly common and easy-to-use spreadsheet program designed and developed in the year 1985. The invention of Excel and Digital Spreadsheets entirely streamlined business processes allowing businesses to compile and gather financial records and business data seamlessly. Nowadays, Microsoft Excel is commonly used to create and develop Pivot Tables & Graphs.

Course Objectives:

The core objective of this course is to help professionals develop a better understanding and sound knowledge of the following key concepts:

• Sum Formula in Excel 2013
• Average Function in Excel
• Count Formula in Excel 2013
• IF Function in Excel
• TRIM Function in Excel
• MAX and MIN Formula in Excel
• Nested IF Function in Excel
• Checking for Errors in Excel 2013

Audience:

• Professionals willing to know the working features of Excel 2013
• Professionals who need Excel for their Business Productivity

Prerequisites:

Professionals planning to enroll in the Excel 2013: Frequently Used Formulas and Functions course must comply with the following prerequisites:

• Basic Knowledge of Using Microsoft Excel 2013