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 Beginner course of Microsoft Excel 2010 covering the topics Start with Excel, Cell Basics, Columns and Rows, Saving, Simple Formulas, Printing, Sorting, Outlining, Filtering, Formatting Table etc. This Microsoft Excel tutorial will be a right start for a person who chooses for this course can learn Simple mathematical computations of Microsoft Excel. This Excel online course will mold you to do mathematical computation in Microsoft Excel 2010. YOU CAN REGISTER FOR THE COURSE NOW.

COURSE DESCRIPTION

Classes are by Geo P D, Course includes 12 chapters of Microsoft Excel 2010 and the Course contains 50 Demos in Microsoft Excel 2010 Beginner Course. This will take about 3 Hours. This is a paid course..

WHAT AM I GOING TO GET FROM THIS COURSE

After learning Microsoft Excel 2010 Beginner Course, you will understand and do Start with Excel, Cell Basics, Columns and Rows, Saving, Simple Formulas, Printing, Sorting, Outlining, Filtering, Formatting Table ..

PREREQUISITES

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

TARGET AUDIENCE

If you are new to Microsoft Excel Spreadsheet, then you can learn Microsoft Excel 2010 Beginner. Everyone who likes to Improve their Skills and more Productive at Work can choose this course and who wants to Learn basic mathematical computations can choose this course..

Course Curriculum

Section 1: Getting Started with Excel
Lesson Objectives details Open Locked
Introduction details Open Locked
The Excel Interface details Open Locked
The Ribbon details Open Locked
The Quick Access Toolbar details Open Locked
Backstage View details Open Locked
Creating and Opening Workbooks details Open Locked
Compatibility Mode details Open Locked
Convert a Workbook details Open Locked
Frequently asked questions
Exam
Section 2: Cell Basics
Lesson Objectives details Open Locked
Introduction details Open Locked
The Cell details Open Locked
Select Single and Multiple Cells details Open Locked
Insert and Delete Cell Content and Delete Cells details Open Locked
Copy & Paste and Cut & Paste Cell Content details Open Locked
Access More Paste Options details Open Locked
Frequently asked questions
Exam
Section 3: Modifying Columns, Rows and Cells
Lesson Objectives details Open Locked
Introduction details Open Locked
Modify Column Width details Open Locked
Modify Row Height details Open Locked
Insert Rows and Columns details Open Locked
Delete Rows and Columns details Open Locked
Wrapping Text and Merging Cells details Open Locked
Frequently asked questions
Exam
Section 4: Formatting Cells
Lesson Objective details Open Locked
Introduction details Open Locked
Change Font and Font Size details Open Locked
Use the Bold, Italic Underline and Border Commands details Open Locked
Font Color and Fill Commands details Open Locked
Text Alignment Commands details Open Locked
Formatting Numbers and Dates details Open Locked
Frequently asked questions
Exam
Section 5: Saving
Lesson Objective details Open Locked
Introduction details Open Locked
Use Save as Command details Open Locked
Use Auto Recover details Open Locked
Save as an Excel 97-2003 Workbook and as PDF details Open Locked
Frequently asked questions
Exam
Section 6: Creating Simple Formulas
Lesson Objectives details Open Locked
Introduction details Open Locked
Creating Simple Formulas details Open Locked
Creating Formulas with Cell References details Open Locked
Create a Formula Using the Point and Click Method details Open Locked
Edit a Formula details Open Locked
Frequently asked questions
Exam
Section 7: Worksheet Basics
Lesson Objectives details Open Locked
Introduction details Open Locked
Rename, Insert and Delete a Worksheet details Open Locked
Copy and Move a Worksheet details Open Locked
Color Worksheet Tabs details Open Locked
To Group and Ungroup Worksheets details Open Locked
Freeze and Unfreeze Worksheet Panes details Open Locked
Frequently asked questions
Exam
Section 8: Printing
Lesson Objectives details Open Locked
Introduction details Open Locked
View Print Pane and Print Selection details Open Locked
Change page orientation details Open Locked
Fit a worksheet on one page details Open Locked
Modify margins while in Print Preview details Open Locked
Use Print Titles details Open Locked
Insert a Break details Open Locked
Frequently asked questions
Exam
Section 9: Sorting Data
Lesson Objectives details Open Locked
Introduction details Open Locked
Sort in Alphabetical, Numerical and Date or Time Order details Open Locked
Custom sorting details Open Locked
Sort by Cell Color, Font Color, or Cell Icon details Open Locked
Sorting Multiple Levels details Open Locked
Frequently asked questions
Exam
Section 10: Outlining Data
Lesson Objectives details Open Locked
Introduction details Open Locked
Outlining Data using Subtotal details Open Locked
Showing and Hiding Data details Open Locked
Removing Groups and Subtotaling details Open Locked
Creating your Own Groups details Open Locked
Frequently asked questions
Exam
Section 11: Filtering Data
Lesson Objectives details Open Locked
Introduction details Open Locked
Filter and Clear Filtered data details Open Locked
Search Filter and Text Filter details Open Locked
Know Date Filter and Number Filter details Open Locked
Frequently asked questions
Exam
Section 12: Formatting Tables
Lesson Objectives details Open Locked
Introduction details Open Locked
Format information as a table details Open Locked
Modifying tables 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.