Online Course: Excel 2016 – Certificate and CEUs #editing #certificate #online, #excel


#

Online Class: Excel 2016

Course Description

Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an address book, grocery lists, tracking expenses, creating invoices and bills, accounting, balance checkbooks and other financial accounts, as well as any other purpose that requires a spreadsheet or table.

This course will cover the many features of Excel 2016 and will teach you how to use them, starting with the simple and working to the most complicated. The good news is that Excel 2016 makes everything easy. By learning how to navigate the program and where to find each feature, operating Excel can become a breeze.

This course will teach you how to:

Create a spreadsheet

Format cells, rows, columns, and entire worksheets so they fit and match your data

Enter data into a spreadsheet

Use formulas and functions for math, accounting, and totaling.

Create formulas and functions

Calculate data

Create charts and diagrams for your data

Create data lists and forms

Create and use pivot tables and pivot charts.

Work with Excel templates

Share and protect your worksheets and workbooks

Use What-If Analysis to determine possible outcomes. For example, sales goals

And much more

This course was designed to teach you skills you’ll need to successfully use Excel 2016. Each lesson contains instructions and illustrations to show you how to use the features, then walks you through step-by-step so you can see how everything is done. You don’t need previous experience with Excel to be able to complete this course. This course will start with basic skills, then move forward to more advanced features and techniques. Although you do not need access to Excel 2016 for this course; it is highly recommended. A free trial of Excel 2016 is available on the Microsoft website.

7/3/2017 11:39:52 AM

Lesson 1: Introduction to MS Excel 2016

Excel can be used for a wide variety of purposes such as creating an address book, grocery lists, tracking expenses, creating invoices and bills, accounting, balance checkbooks and other financial accounts, as well as any other purpose that requires a spreadsheet or table.

  • Lesson 2: Navigating Excel 2016

    In this lesson, we’re going to focus on the major elements of Excel 2016 and take a few minutes to become familiar with their purpose.

  • Lesson 3: Worksheets and Workbooks

    Worksheets are stored in workbooks, and workbooks are the files that you actually save.

  • Lesson 4: Entering Information into MS Excel 2016

    Starting to enter information is as simple as clicking on a cell in the spreadsheet and typing, but there are some things that are helpful to know – and that you can do – before you ever type that first letter or number.

  • Lesson 5: Introduction to Working with Cells, Rows, and Columns

    If you want to move data from its original location and relocate it somewhere else, you must cut the data, then paste it somewhere else. You can cut or copy cells, rows, columns, or entire worksheets.

  • Lesson 6: Formatting Data and Cells

    Taking the time to format a worksheet can take it from the black and white page of data and gridlines to something that looks professional and attractive.

  • Lesson 7: Formatting Rows and Columns

    In Excel 2016, the width of a column is determined by how many characters that can be displayed within a cell.

  • Lesson 8: Editing Cells, Rows, Columns, and Worksheets

    Excel 2016 makes creating – and editing – spreadsheets a lot easier because correcting errors is easy mess free.

  • Lesson 9: Introduction to Formulas and Calculations

    If you use spreadsheets to do accounting for a business, track totals, invoice customers, or anything that requires mathematics, Excel’s ability to calculate formulas is going to save you errors and headaches.

  • Lesson 10: Working with Formulas and Functions

    In Excel, a function is a predesigned formula that does a certain calculation. This can make it easier because you don’t have to construct every formula yourself.

  • Lesson 11: Maintaining Worksheets

    It’s important to learn how to maintain your worksheets to help you keep on top of all the information.

  • Lesson 12: The What-If Analysis

    A what-if analysis lets you explore possibilities by entering possible values into the same equation so you can see the possible outcomes in the cells of your spreadsheet.

  • Lesson 13: Adding Images and Graphics

    You’ve already learned how to format a worksheet and enter information into Excel. Now we’re going to show you how to add elements such as graphics and images.

  • Lesson 14: Charts and Diagrams

    Charts and diagrams are tools you can use to visually represent the data in a worksheet.

  • Lesson 15: Creating Data Lists

    A data list or a database table are types of worksheets that aren’t used to calculate values, but to store information, such as names and addresses of clients or perhaps a library of books.

  • Lesson 16: Managing Data

    A form is simply a dialog box that lets you display or enter information one record (or row) at a time. It can also make the information more visually appealing and easier to understand.

  • Lesson 17: Pivot Tables and Pivot Charts

    A pivot table sounds more difficult and confusing than it really is. Most people say they don’t like pivot tables, or they don’t understand them. In truth, they’re not that difficult at all.

  • Lesson 18: Printing Worksheets and Workbooks

    Headers appear at the top of a worksheet. Footers appear at the bottom. Both can contain page numbers, and headers often contain the title of the worksheet and perhaps the date.

  • Lesson 19: Templates

    Templates are worksheets that are already designed for you.

  • Lesson 20: Protecting, Saving, and Sharing Workbooks

    Add protection to worksheets so that they can’t be edited by other people. You can lock cells or an entire worksheet.

  • Additional Course Information

    • Document Your Lifelong Learning Achievements
    • Earn an Official Certificate Documenting Course Hours and CEUs
    • Verify Your Certificate with a Unique Serial Number Online
    • View and Share Your Certificate Online or Download/Print as PDF
    • Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media

    Course Title: Excel 2016

    Course Number: 8900368

    Languages: English – United States, Canada and other English speaking countries

    Course Type: Computer Skill

    CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).

    Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned.

    Assessment Method: Lesson assignments and review exams

    Instructor: UniversalClass Staff Instructor

    Duration: Continuous: Enroll anytime!


    Free Office software #free #office #software, #business #program, #office #suite, #office #program,


    #

    Personal Information Manager, Database and Word Processor. Download TreePad and enjoy better access, organization and control over all your data, notes, bills, projects, clients, addresses, letters, speeches, research, collections, classroom notes, Web pages, links, bibliographic listings, and whatever else your creativity enables you to entrust TreePad with, for good organization, easy access, and safe storage.
    Despite all its features and power, TreePad is as easy to use as the Windows explorer and will fit (including data) on one floppy!
    Freeware, Shareware, Linux and Windows versions are available on www.treepad.com .
    Created by Freebyte.

    Fully customizable addressbook program for Windows XP, Vista, 2000, NT, 95, 98, ME. Freeware and shareware versions are available. Custom Addressbook is an easy to use, small, and extremely flexible Address Management program. Another advantage of its small size, is that the program and its database file can run directly from an external disk, such as a USB stick, floppy, etc. Some of the additional features: password protection, minimize to tray, data encryption, data compression, import, search, backup, non-western fonts, etc.
    For more information, please see here. Created by Freebyte.

    Free online clocks, free clock programs which you can install, clock screensavers, clock widgets for your Website or blog, alarms and timers, time-related utilities, free project and time-scheduling software.

    Free general purpose calculators, calculator collections, scientific/technical calculators, currency conversion and exchange rates.

    Free personal finance software, free accounting programs, free invoicing software and free accounting scripts.

    Online Business Services
    Free Financial Software

    E-commerce services, virtual cash systems, payment processing services, check printing, business-to-business portals, online stock trading, currency converters, free accounting software, etc.

    Free Software
    created by Freebyte

    Free Personal Information Managers, free File and Disk Utilities, free Address Books, free eBook Software and more. All created by Freebyte.com.

    Free ebooks, free eBook authoring tools, free photo albums.

    Free online dictionaries for a multitude of languages, free specialized dictionaries (medicine, business, sports, computing, construction. ), free thesauri, free online spellcheckers, language tools, language links, and more.

    Online courses, education for kids, online university education, educational resources.

    Work from home, start your own business, make money from your Website, join affiliate programs, get paid to take online surveys, get paid by reading email, get paid by surfing the Web, money making tutorials, earn revenue by placing ads on your Website, advertisement programs, get a fee to refer customers, receive commission for offering custom builds, etc.

    Free programs to surf the Web, free email software, email virus protection, free newsgroup programs, free Internet chat, telephony and messaging applications, free telnet software, free firewalls, etc.

    Free screensavers, cursors, ringtones and desktop themes. Free 3D screensavers, nature, funny and artistic screensavers, screensaver construction packages which don’t require any programming, and more.

    A large listing of services that provide free but also non-free email addresses. Web based email, email forwarding, pop email, etc. Also: add email services to your domain.

    Free images, icons,
    clipart, backgrounds,
    photos

    Download images and clipart for free, royalty-free stock photographs, thousands of free fonts, free icons, free GIFs, animated GIFs, free backgrounds, wallpapers, etc.

    Free images, bars, arrows, flags, animated gifs and signs for your Web page.

    Freebyte Gallery:
    Background Images

    Free background images for your Web pages: stone, marble, metal, decoration, sky backgrounds, timber images, psychedelic, office, trees and plants, space and stars.

    Free Paint Programs, Free Image Viewers, Free Photo Albums, Free graphics converters, 2-D Animation Software, 3-D / Animation software and more!

    Free online encyclopedias, maps, satellite images, electronics, computing, physics, science, etc.

    The latest News Headlines; a large collection of news sites: English (USA/UK), German, Spanish, French, Italian, Dutch, Russian, Chinese, Brazilian, Arabic, Scandinavian, weather, sports, science, showbizz, economy, Internet, computer, etc.