Microsoft Excel 2010

(7 customer reviews)
Sale!

Leading the way

Microsoft Excel 2010

(7 customer reviews)

| Total Course Video Hours: 5 Hrs 14 Min
|  Videos: 34
|  Course Access: 12 Months Unlimited Access
|  Study Method: Online Video Lessons
|  Course Type: Certificate Course
|  Award: Cyber Studies Institute

Course Fee:

R1600,00

Current Special Ends in:

Days
Hours
Minutes
Seconds

Overview

This course is training for basic, intermediate, and advanced features of Microsoft Office Excel 2010 software. Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions. Specifically, you can use Excel to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional looking charts.

Curriculum

Introduction
„ Course Outline
„ Introducing Excel 2010
„ The Excel Interface
„ Keyboard Shortcuts
„ Section Review

 

Basic File Commands and Operations
„ Creating, Saving and Closing Workbooks
„ Personalizing Files and Opening Workbooks
„ Viewing Existing Workbooks and Applying Templates
„ Keyboard Shortcuts
„ Section Review

 

Creating, Managing and Navigating the Worksheets
„ Creating and Managing Worksheets
„ Navigating the Worksheets
„ Keyboard Shortcuts
„ Section Review

 

Entering and Managing Worksheet Data
„ Worksheet Basics and Cell Range Selection
„ Entering Cell Content and Multiple Cells
„ AutoContent and Undo, Redo and Repeat
„ Updating and Clearing Cell Content
„ Inserting and Deleting, Rows and Columns
„ Copying, Cutting, Pasting and Moving Contents
„ Keyboard Shortcuts
„ Section Review

 

Formatting Cells and Worksheets
„ Formatting Cells and Applying Formats
„ Alignment
„ Merging Cells and Cell Styles
„ Numbers
„ Apply and Modify Formats
„ Using Table Features
„ Keyboard Shortcuts
„ Section Review

 

Applying Formulas and Functions
„ Creating Formulas
„ Using Cell References
„ Managing and Updating Formulas
„ Creating Functions
„ Conditional Statements
„ Error Messages
„ Keyboard Shortcuts

 

Applying Formulas and Functions
„ Creating Formulas
„ Using Cell References
„ Managing and Updating Formulas
„ Creating Functions
„ Conditional Statements
„ Error Messages
„ Keyboard Shortcuts

 

Analyzing and Organizing Data
„ Find and Replace
„ Sorting
„ Filtering
„ Conditional Formatting and Keyboard Shortcuts
„ Section Review

 

Naming and Hyperlinks
„ Naming Cells and Ranges
„ Hyperlinks
„ Section Review

 

Displaying Data Visually Using Charts
„ Charting
„ Layout Chart Element Options and Format
„ Sparklines
„ Keyboard shortcuts
„ Section Review

 

Preparing to Print and Printing
„ Preparing to Print with Page Layouts
„ Section Review

 

Share Worksheet Data with Other Users
„ Sharing a Document and Managing Comments
„ Section Review

 

Including Illustrations and Graphics in a Workbook
„ Inserting and Formatting Pictures
„ Inserting and Formatting Clip Art
„ Inserting and Formatting Shapes, Word Art and Text Boxes
„ Inserting and Formatting Smart Art
„ Keyboard Shortcuts
„ Section Review

 

Customize the Excel Interface
„ Section Review

 

Course Review

7 reviews for Microsoft Excel 2010

  1. Evelyn

    This course has given me the skills to excel in my career.

  2. Zandile

    The course offered practical exercises that challenged me and allowed me to apply my knowledge.

  3. Sophia

    The course offered real-world examples that made the concepts relatable and easy to understand.

  4. Sanelisiwe

    The course material was easy to grasp, and the content was excellent.

  5. Zandile

    You’ve helped me secure my dream job. Thank you from the bottom of my heart!

  6. Adia

    The course had a great pace, allowing me to learn at my own speed without feeling overwhelmed.

  7. Zain

    I appreciated the regular check-ins and progress assessments that kept me motivated throughout the course.

Add a review

Your email address will not be published. Required fields are marked *

Excited to Study Enroll Qualify

If you are ready to take the next step, click on the “Enroll Now” button below or “Contact us now” on this course for a detailed course outline or if you have any questions. An expert course adviser is standing by to assist you.

CompTIA Authorized Partner

Cyber Studies Institute (Pty) Ltd is proud to be an Official CompTIA Authorized Partner. Ensuring that you receive the best training in the world.

CompTIA Authorized Partner

How does studying with CSI work?

Click here to read how the process of studying at CSI work.