Important to know:
The course video is English with Romanian subtitles and test questions are in Romanian.
Overview
Excel 2010 provides you with a wide variety of statistical functions that allow you to perform data analysis in worksheets, several cube-like functions that allow you to display information from cubes, and matrix tools. In addition, using the Developer tab, you can further customize an Excel workbook to enhance its functionality with ActiveX formatting and controls.
These courses discuss the various statistical functions, including those designed to work with averages, determine the median, identify rank and percentage, and sample populations. In addition, this course explores available cube features such as CUBEMEMBER, CUBESET, and CUBEVALUE. Centralization of data using conditional functions such as SUMIF and COUNTIFS is also addressed. This course also examines the methods that Excel 2010 offers for working with matrices, including one-dimensional and two-dimensional matrices. Adding a form and ActiveX controls to Excel worksheets is also covered.
Target Audience
End users who want to gain dexterity in using Microsoft Excel 2010 at a full-fledged user level who are familiar with spreadsheets, Microsoft Office, and online workspaces.
Objectives
DB Academy provides top notch online courses mastering your skills partnering with reputable companies. Boost your career with Corporate trainings.
For those who are individual learners, team members of a business, business professionals.
By registering you accept terms and conditions
Already on DB Academy?
Business Leaders / HR Responsibilities / Other company representatives who want to upskill employees.
By registering you accept terms and conditions
Already on DB Academy?
For companies which want to colobrate with DB Academy and publish educational content for their customers.
By registering you accept terms and conditions
Already on DB Academy?
Authanticate to DB Academy.
New to DB Academy?
Forgot your password?
