Library is empty. Tip: You can use Accounts.academy File Uploader to upload several files at the same time.



Tip: Only available for Python and Ruby for now. You can upload .py and .rb files

ABOUT THIS COURSE

Microsoft Excel 2010 is spreadsheet software designed to perform basic and complex mathematical computations and functions. This is a Intermediate course of Microsoft Excel 2010 covering the topics Complex Formulas, Basic Functions, Reviewing and Sharing, Templates, Charts, Sparklines, Conditional Formatting, Pivot Table, What-If Analysis etc. This Microsoft Excel tutorial will be a right start for a person who chooses for this course can learn Complex Formulas, Basic Functions and other advanced functions of Microsoft Excel. This Excel online course will mold you to do basic functions and complex formulas in Microsoft Excel 2010. YOU CAN REGISTER FOR THE COURSE NOW..

COURSE DESCRIPTION

Classes are by Geo P D, Course includes 9 chapters of Microsoft Excel 2010 and the Course contains 28 Demos in Microsoft Excel 2010 Intermediate Course. This will take about 2 Hours. This is a paid course..

WHAT AM I GOING TO GET FROM THIS COURSE

After learning Microsoft Excel 2010 Intermediate Course, you will understand and do Complex Formulas, Basic Functions, Reviewing and Sharing, Templates, Charts, Sparklines, Conditional Formatting, Pivot Table, What-If Analysis..

PREREQUISITES

You will need to have a Note Book and Pen to write Microsoft Excel 2010 Intermediate Notes. Microsoft Excel 2010 Software is required.

TARGET AUDIENCE

If you have the basic knowledge about Microsoft Excel, then you can learn Microsoft Excel 2010 Intermediate. Everyone Who likes to Improve their Skills and more Productive at Work using Complex Formulas and Basic functions can choose this course and who wants to Learn Interesting tips & tricks can choose this course..

Course Curriculum

Section 1: Creating Complex Formulas
Lesson Objectives details Open Locked
Introduction details Open Locked
The order of operations details Open Locked
Create a complex formula using the Order of Operations details Open Locked
Working with cell references details Open Locked
Relative references details Open Locked
Absolute references details Open Locked
Frequently asked questions
Exam
Section 2: Working With Basic Functions
Lesson Objectives details Open Locked
Introduction details Open Locked
Know the parts of Functions and Arguments details Open Locked
Create a Basic Function in Excel details Open Locked
The Function Library details Open Locked
The Insert Function Command details Open Locked
Frequently asked questions
Exam
Section 3: Reviewing and Sharing Workbooks
Lesson Objectives details Open Locked
Introduction details Open Locked
Track Changes details Open Locked
Adding, Editing and Deleting Comments details Open Locked
Accepting and Rejecting Changes details Open Locked
Adjusting how Changes are viewed details Open Locked
Finalizing your Workbook details Open Locked
Protecting your Workbook details Open Locked
Frequently asked questions
Exam
Section 4: Using Templates
Lesson Objectives details Open Locked
Introduction details Open Locked
Create a New Workbook using a Template details Open Locked
Frequently asked questions
Exam
Section 5: Working With Charts
Lesson Objectives details Open Locked
Introduction details Open Locked
Types of Charts details Open Locked
Identify the Parts of a Chart and Create a Chart details Open Locked
Chart Tools details Open Locked
Frequently asked questions
Exam
Section 6: Working With Sparklines
Lesson Objectives details Open Locked
Introduction details Open Locked
Sparklines details Open Locked
Create Sparklines details Open Locked
Change the Appearance of your Sparklines and Display Range details Open Locked
Frequently asked questions
Exam
Section 7: Using Conditional Formatting
Lesson Objective details Open Locked
Introduction details Open Locked
Create a Conditional Formatting Rule details Open Locked
Conditional Formatting Presets details Open Locked
Frequently asked questions
Exam
Section 8: Creating Pivot Tables
Lesson Objectives details Open Locked
Introduction details Open Locked
Using a Pivot Table details Open Locked
Pivoting Data details Open Locked
Using Report Filters details Open Locked
Slicers details Open Locked
Using a Pivot Chart details Open Locked
Frequently asked questions
Exam
Section 9: Using What-If Analysis
Lesson Objectives details Open Locked
Introduction details Open Locked
Using Goal Seek details Open Locked
Other Types of What-If Analysis details Open Locked
Frequently asked questions
Exam

Use of this site is subject to express terms of use. By continuing past this page, you agree to abide by these terms.