Online Course: Excel 2016 – Certificate and CEUs #editing #certificate #online, #excel #2016 #microsoft #spreadsheet #program #comes #packaged #office #family #software #products #programs #can #wide #variety #purposes #creating #address #book #grocery #l #education #online #distance #learning #expert #instruction #class #make #money #teaching #course #guide #help #tutor #knowledge


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!

    CSVDE – Examples bulk import user accounts into Active Directory #csvde, #csvde #import, #bulk #import, #ldap, #ldap #field, #active #directory, #spreadsheet, #users

    CSVDE Import

    Introduction to CSVDE -i Bulk Import

    The purpose of this page is to show you how to bulk import user accounts into Active Directory using CSVDE. Here are scenarios where CSVDE will save you repetitive work:

    • To create hundreds of new users in a Windows Server 2003 or 2000 domain.
    • To import thousands of NT 4.0 users into a brand new Active Directory domain.
    • To migrate directory services from Exchange 5.5 into Active Directory.

    Topics for CSVDE Import

    1) Practice with CSVDE Export. Remember that seven minutes of planning will save you an hour or rework. It may seem eccentric to start with an export when all you want to do is import, but trust me always start with CSVDE export. Here is my reasoning: gain experience of CSVDE switches in conditions where you can do no harm to Active Directory.

    When you use CSVDE -i filename to import user accounts, you make changes that will be difficult to reverse. In export mode, you can do no harm to Active Directory, also starting with CSVDE -f filename.csv will help build up your understanding of the switches, or what Microsoft call the parameters.

    2) Learn the precise spelling of LDAP fields, for example sAMAccountName is correct, sAMAaccountNames has two mistakes and would cause the import to fail. (This LDAP name is singular, and the double Aa is incorrect.)

    3) Create a good .CSV file and learn as much as you can about the LDAP fields in the first row. When you export a user, you get a spreadsheet full of a LDAP attributes, for example, sn, phone, email and many more besides. My advice is to investigate which of the LDAP fields in the first row are compulsory, which are optional, which have strange numeric data, and which you can safely ignore when you switch CSVDE to import mode.

    My theme is getting you started. Imagine the scenario: your manager wants 500 users added to his Windows 2003 domain. Fortunately, human resources have all the new joiners in a spreadsheet called Newport.csv. So, let us begin with a simple spreadsheet with only 3 LDAP columns: objectClass, sAMAccountName and DN.

    A) objectClass – User. Simple and easy we want to create a user and not a computer and not an OU.

    B) sAMAccountName – This is the logon name, maximum of 11 characters. What the user should put in the Ctrl, Alt Delete logon box. Keep this name simple for now. Remember we just want to get the prototype import working and then we can add more LDAP fields.

    C) DN – Distinguished name, for example, CN= Firstname Surname,OU=Newport,dc=domain,dc=com

    DN is the hardest LDAP field to create. Let us break it down into 3 elements.

    1) User name – CN= Firstname Surname. If it were me, the value would be CN=Guy Thomas. In this context think of CN= as meaning common name, or just plain name.

    2) Organizational name – OU=Newport. All you have to worry about is have you created an OU called Newport in your domain? If not, then either create one, or change this value to OU=YourOU.

    3) Domain name – dc=domain, dc=com. Is your domain called something like or is it plain mydom (no .com. net or It is essential to find out what your domain is called, and only you know the answer.

    What would you say the Domain name is for this screen shot? cp,, cp.local? The answer is

    So of this were your domain the third DN element would be, dc=cp,dc=com. Incidentally, dc stands for domain context not domain controller.

    Guy Recommends: SolarWinds’ Free Bulk Import Tool

    Import users from a spreadsheet. Just provide a list of the users with their fields in the top row, and save as .csv file. Then launch this FREE utility and match your fields with AD’s attributes, click and import the users.

    Optionally, you can provide the name of the OU where the new accounts will be born. Download your FREE bulk import tool.

    1) Copy my example below and paste into an Excel spreadsheet at precisely cell A1.

    user,Petergr, CN=Peter Graham,OU=Newport,DC=cp,dc=com
    user,Janiebo, CN=Janie Bourne,OU=Newport,DC=cp,dc=com
    user,Edgardu, CN=Edgar Dunn,OU=Newport,DC=cp,dc=com
    user,Belindaha, CN=Belinda Hart,OU=Newport,DC=cp,dc=com
    user,Mayja, CN=May Jamieson,OU=Newport,DC=cp,dc=com
    user,Leroyot, CN=Leroy Ota,OU=Newport,DC=cp,dc=com

    2) In Excel, select the Data Menu and then Text to Columns. Naturally, choose the comma delimiter. Save the file as .csv for example, Newort.csv

    3) Make sure that the 3 LDAP fields are in the first row. (ObjectClass, sAMAccountName, and DN.)

    4) Once you have opened the file in Excel, it is easier to manipulate the values. For example, you may wish to find and replace dc=cp, dc=com with the name of your domain as we discussed earlier.

    5) When you have finished preparing the spreadsheet to your liking, then Save As and make sure you select Save as t ype CSV (Comma delimiter). Since the next step is the command prompt, save the file into an easily accessible folder. E.g. C:\csv.

    After all the hard work in preparing the spreadsheet, we are now ready for the import. Open the CMD prompt, navigate to the folder where you saved your .csv file.

    Type this command: CSVDE -i -f Newport.csv

    To check your new users, launch Active Directory Users and Computers and examine the Newport Organizational Unit. After each import, right-click the OU and select Refresh from the short cut menu. Simply pressing F5 is not good enough.

    Next step – Try an advanced import. More fields, more spreadsheet functions.

    Recommended: Solarwinds’ Permissions Analyzer – Free Active Directory Tool

    I like the Permissions Analyzer because it enables me to see WHO has permissions to do WHAT at a glance. When you launch this tool it analyzes a users effective NTFS permissions for a specific file or folder, and takes into account network share access, then displays the results in a nifty desktop dashboard!

    Think of all the frustration that this free SolarWinds utility saves when you are troubleshooting authorization problems for user’s access to a resource. Give this permissions monitor a try – it’s free!

    CSVDE is unable to add passwords.

    Your solution is to change the domain policy to allow blank passwords. You can revert to the previous security setting once you successfully import the accounts. Also see this VBScript.

    4) The key disadvantage of CSVDE is that you cannot set passwords with this program. So, use a separate VBScript to set the passwords and enable accounts. Sadly once created, you cannot you alter the accounts in anyway with CSVDE. See here for a VBScript to reset passwords.

    The point is use the right tool for the right job. For a quick import of hundreds of user accounts, you cannot beat CSVDE. However if you need to alter accounts or add passwords then turn to VBScript. Both CSVDE and VBScript ‘feed’ off spreadsheets, to me, this is their killer advantage over LDIFDE. I find that it is so useful to have all the accounts and their values set out in my Excel spreadsheet.

    • Check that you understand the: DC=domain, DC=COM (LDAP attributes).
    • If your ADSI Edit says: DC=mydom, then change, dc=cp,dc=com to dc=mydom.
    • Check you created an OU called Newport.
    • Check out the Error Messages .
    • Experiment with different syntax. Try a different output filename.
    • Open and close the CMD command prompt.

    CSVDE is an ideal program to bulk import users into Active Directory. The executable is built-in to Windows Server 2003 and 2008. The key advantage of CSVDE is the way than it interacts with spreadsheets to import or export LDAP data.

    See Also

    Car Lease Spreadsheet #ifa #auto #insurance

    #auto lease calculator

    Car Lease Spreadsheet

    When shopping for a new car, consumers have a number of choices. One of those options includes leasing a car. In this article, we re going to provide a car lease spreadsheet, which is an Excel workbook that can be used to calculate monthly car lease payments.

    The remainder of this article will be dedicated to providing detailed instructions. This will reduce any confusion over the use of the spreadsheet. We ll also explain some of the terminology that might be encountered when evaluating a car lease. Finally, as appropriate, we ve included some examples, or suggested values, to use in the spreadsheet.

    Car Lease Spreadsheet Instructions

    The spreadsheet can be downloaded by clicking on the following link: Car Lease Calculator. Once the spreadsheet has been opened in Excel (it should also work in LibreOffice or OpenOffice Calc), users will notice the tool already contains example information. All users need to do is overwrite the example values with the car lease information they re evaluating.

    When a cell value is blue, this indicates the need for an input. The remaining cells are used for spreadsheet calculations or explanations.

    Gross Capitalized Cost

    The first value that is going to be calculated is the gross capitalized cost of the vehicle. The important inputs include:

    • MSRP. this is the Manufacturers Suggested Retail Price or sticker price of the car. This value can be found on the vehicle manufacturer s website if unknown.
    • Base Cap Cost. the base capitalized cost is the negotiated price the user would be willing to pay for the car. This value is usually less than the MSRP, unless the car is experiencing extremely high demand and low supply.
    • Additional Lease Costs. dealer acquisition fees are nearly always included in a contract. Other items, such as extended warranties . might also be purchased as part of the deal. For example, someone might want to purchase an extended warranty for a 48 month lease on a car when the manufacturer is offering a standard 36 month warranty.

    Capitalized Cost Reductions

    The next step in calculating the lease payment is to figure out how much capital, or money, the user is willing (or required) to pay upfront. This is known as the capitalized cost reduction. The larger the upfront payment, the lower is the monthly lease payment. Generally, there are two ways to reduce capital:

    • Down Payments. this is cash, usually in the form of a bank check, which a lessee is willing to put down on the car. Many leases will specify a minimum down payment .
    • Trade-In Allowance. if a car is owned, and it s traded in as part of the lease, then take that allowance on this line in the calculator.

    Lease Terms and Taxes

    In this section, users are going to provide some of the lease terms they ve been offered by the dealership or perhaps have seen in an advertisement.

    • Residual Value. in case the residual value of a car isn t known, we ve provided a calculation based on the lease term or length. If the actual residual value is known, just overwrite the calculated value.
    • Money Factor. this is the equivalent of an APR on a loan. In fact, multiplying the money factor by 24 reveals the effective interest rate on the lease. Likewise, if the interest rate is divided by 24, this reveals the money factor.
    • Lease Term. this is the length of the lease, stated in months.
    • Sales Tax. this is the rate of sales tax charged in the user s state.

    Calculation of Lease Cost

    This section of the spreadsheet computes the total of all out-of-pocket payments associated with the lease. This is the total amount of money that needs to be provided as part of the agreement.

    • Depreciation. this is the loss in value of the car over the term of the agreement. For a car lease, depreciation is simply the net capitalized cost minus the car s residual value.
    • Finance or Rent Charge. this is the rent charged on the car over the life of the lease. This considers the car s value, the money factor, and the term of the lease.
    • Sales Tax on Lease. if the state collects a sales tax, payment is required on car leases too.
    • Total Lease Payment. this is all of the money that will be paid as part of the lease. The value includes sales tax, rent charges, depreciation, trade-ins, and down payments.

    Monthly Car Lease Payments

    This is the part most users are interested in: An estimate of the monthly car lease payments. This output isn t going to be reviewed line-by-line because the concepts have already been explained. This section converts the lease costs into monthly payments by dividing those values by the term of the lease.

    It s easy enough to print out a copy of these instructions, and refer to them when using the car lease spreadsheet. The tool can be very useful when playing what if scenarios, to see how changing an assumption affects the monthly payments. Keep in mind this tool is not intended to replace the calculators used by dealerships. The intention here is to provide consumers with quality information, so they are better prepared when they negotiate with leasing companies or dealerships.

    Online Car Lease Calculators

    If an online car lease calculator is preferable, we can help there too. In fact, we have a complete line of car loan and lease calculators that users can access for free. Included in that offering is an online car lease calculator. which follows the same format as the above spreadsheet. All of our online tools come complete with instructions too.

    About the Author – Car Lease Spreadsheet – Copyright 2005 – 2015 (Last Reviewed on October 2, 2015)