Introduction to Microsoft Excel

Introduction to Microsoft Excel online course
Course Name

Introduction to Microsoft Excel

One of the very first personal computer (PC) applications was the spreadsheet, and one of the first spreadsheet creation and editing programs was Microsoft Excel. Nowadays, Excel comes preinstalled on nearly every new Windows machine—PC, tablet, and smartphone—which constitutes about 90 percent of today’s computing device market, and a huge majority of businesses use Excel in one capacity or another

While spreadsheets can be and do many things, their primary function is to display and manipulate data. And that’s what we’ll do in this short, four-week, comprehensive course—learn how to enter, display, and manipulate data in Excel spreadsheets. First, we’ll take a brief look at the two most recent versions of Excel, Excel 2013, and the cloud-based version, Excel 365, so that you can decide which one is right for you. Then, we’ll talk about all the ways in which you can enter data into spreadsheets, everything from typing it on your keyboard to importing it from other programs, such as QuickBooks and other accounting packages. After that, we’ll go over how to format your spreadsheets, so that they’re easy to read, effective, and attractive. And then, finally, we’ll cover manipulating the data in your spreadsheets, from sorting, to using formulas to add, subtract, multiply, divide, and average data, to creating professional-looking charts and graphs.

Upon completion of this course, you will understand the basics (and more) of creating spreadsheets, as well as several advanced data manipulation concepts—to prepare you for using Excel in today’s business environment, which will in turn make you a much more valuable employee (or perspective employee).

Week 1: Introducing Microsoft Excel
  • Using Excel 2013 Locally or Excel 365 in the Cloud
  • The Almighty Spreadsheet
  • Working with Workbooks
  • Working with Multiple Windows and Views
  • Anatomy of a Spreadsheet – Cells, Columns, and Rows
  • Types of Data Excel Supports
  • Entering Data
  • Data Entering Shortcuts
  • Importing Data
  • Moving, Inserting, and Replacing Data
Week 2: Formatting Spreadsheets
  • Displaying Data Effectively
  • Design, Layout, and Format
  • Freeze Panes and Other Neat Tricks
  • Using Predefined Designs and Templates
  • Headers and Labels
  • Borders and Shading
  • Formatting Columns
  • Formatting Rows
  • Formatting Cells
  • Wrap and Merge
  • Reformatting Worksheets
Week 3: Manipulating Data
  • Manipulating Data in Excel – An Overview
  • Sorting Data
  • Data Validation and Consolidation
  • Working with Formulas
  • What-If Analysis
  • Error Checking
  • Automating with Macros
Week 4: Displaying Data Visually
  • Charting Data – An Overview
  • Using the Right Chart or Graph for Your Data
  • Charting Your Data
  • Titles, Legends, Labels, and So On
  • Reformatting Your Charts
  • Deploying Your Data and Charts in Word
  • Deploying Your Data and Charts in PowerPoint
  • Data and Charts in Portable Electronic Documents
  • Inserting Images and Shapes
  • Review Mode and Comments
  • Working with Your Team in the Cloud
  • Printing Your Workbooks
Prerequisites
  • Basic computer skills
  • Knowledge of Windows or Mac OS: Creating, editing, saving, managing, and printing computer files.
Requirements
  • Software: Any version of Microsoft Office 2013 or Microsoft Office 365. (Users of Office 2010 will also be able to follow most of the course.)
Course Books

[
]
Course Price
  • Member Price: $100 US
  • Non-Member Price: $200.00 US
[Register Now]

Additional Information:
Your place in the course is confirmed by your payment. Introductory courses are intended for students with no experience in the subject matter and are seeking beginner level training.

Refund Policy: Please read our "Terms and Refund Policy" before registering for this course.

Additional Cost: Book and software migh be required for the course. Read the Requirements and Book section for more information. Course fee does not include the book and software cost .

Start Date: Click on the Register Now button to process to the registration page. You will see the start date of the class on that page.

How eClasses Work:Instructors post lectures, reading selections, and hands-on assignments once a week in the online classroom. Students can discuss the assignments with the instructor and amongst themselves in the classroom area. This format has no set meeting time, which allows students to attend class at a time most convenient to them, yet still provides logically organized communication between class participants. Students can apply for the completion certificate after finishing the class. Web Study certificate is also available. Click on the Certificates link on the top navigation bar for more information.

 

Register Now

Before you register for this class, please read carefully the Outline, Prerequisites, Requirements, Books, and Refund Policy sections.


4 Web Study Certificates

 Valid XHTML 1.0 Transitional  Valid CSS!  Level Triple-A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0

Introduction to Dreamweaver Online CourseDreamweaver Online CourseBuilding Data-Driven Websites Course
Web Videography CourseIntroduction to Microsoft Excel - Online CourseDigital Market Research Course
Contracting Your Services - Online CourseBlog Content Writing Course - OnlineWeb Content Writing Skills Course
DNS Administration CourseGoogle Web Analyics CourseWordpress Theme Design Course
Wordpress Content Management CourseDrupal Beginner CourseProject Management Training Course
Joomla Training CourseWeb Design Legal Issues CourseInteractive e-Survey Strategies Course
Search Engine Optimization CourseWebsite Promotion and Marketing Course - OnlineEmail Marketing Course Strategies
Social media Marketing CourseInternet Marketing Strategies CourseWeb Design Concepts Training Course
Web Design Course Training OnlineResponsive Web Design Training CourseIntroduction to Bootstrap Training Course
Introduction to Photoshop CC CourseAdobe InDesign CourseAdobe Illustrator Online Course
Mobile Web Design Online CourseHTML5 Online CourseCSS3 Online Course
Introduction to Sass Online CourseWeb Animation with CSS and JavaScript Online CourseSQL Using MySQL Online Web Training
SQL Server Online CoursePHP Online CoursePHP Online Course
JavaScript for Beginners Online Web TrainingJavaScript Level 2 Online CoursejQuery Web Programming Online Course
PHP Online CourseJavaScript for Beginners Online Web TrainingXML Web Programming Online Course