Microsoft Excel (Three Courses in One)

Microsoft Excel Essential Training
In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course. Topics include:
Copying and pasting techniques
Working with formulas and functions
Dealing with formula errors
Creating lookup tables
Naming cell ranges
Formatting data and worksheets
Finding and replacing data
Creating SmartArt diagrams
Creating charts and PivotTables
Recording macros
Sharing workbooks


Macros in Depth
In Excel 2010: Macros in Depth, author Dennis Taylor explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros. This course also covers advanced topics such as making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions that can't be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario. Exercise files are included with the course. Topics include:

Understanding what a macro does
Recording and adding functionality to a macro
Running macros
Creating non-recordable VBA code
Testing a macro in Step mode
Joining two macros
Using loop structures
Streamlining macros
Creating a Personal Macro Workbook


Managing Multiple Worksheets and Workbooks

Sometimes multiple worksheets or workbooks are the only solution to storing large amounts of data. But how do you analyze data that's spread out that way? In this course, author Dennis Taylor shows you how to move, copy, and analyze large amounts of data stored in multiple worksheets and workbooks in Excel 2013. Learn how to insert, delete, move, and copy data from multiple sheets; hide and un-hide sheets; and make global changes. Plus, discover how to create simple formulas that connect different worksheets, make super-efficient 3D formulas to calculate summary totals from multiple worksheets, and use PivotTables to summarize data from multiple workbooks.
Topics include:

Navigating across worksheets and workbooks
Displaying multiple worksheets or workbooks simultaneously
Inserting, deleting, moving, and copying sheets
Changing sheet names and tab colors
Showing and hiding worksheets
Creating linkage formulas among workbooks
Locating and managing links

Making Investment Decisions

Making investment decisions is something we do every single day, sometimes without even realizing it. When we think about investing, we think about "big money" and long-term commitments. But at the core of it, investing is nothing more than spending money and expecting a good return on it.
This course teaches the net present value (NPV) methodology, an investment evaluation formula used by countless publicly traded companies and financial analysts, in a way that makes it accessible and applicable to you—no finance background required. Rudolph Rosenberg explains what investments are, how they are measured, and what makes a good investment. Then he explores the NPV formula in depth, showing you how to evaluate your cash flows, choose a rate of return, and assess the risk of a particular investment. This all culminates in a look at how the principles of investment apply to three real-life scenarios that any individual or company might encounter. Topics include:

What is an investment?
Understanding ROI
What makes a good investment?
Using the NPV formula
Assessing risk
Applying NPV to real-life situations

How To DIY Video Collection of Tutorials

These “HOW TO” videos are very useful. DIY CD Tutorial range is the essential step by step, easy to follow visual aid for any DIY enthusiast. Each DVD reveals handy tips from the trade and gives professional instruction on how to carry out home improvements, repairs and maintenance. Complete list on next page.

6 Video Courses:
Carpentry
Hanging doors, fitting floor boards, skirting boards, fitting bath panels, general tool practice, carpentry techniques.

Tiling
Bathroom/Kitchen tiling, measuring up, preparation, application techniques, grouting, sealing.

Plumbing
Fitting & replacing taps, plumbing in washing/dishwasher machine, pipe bending & soldering, replacing tap washers, cleaning sink traps, general plumbing tips.

Painting and Decorating
Painting methods, wallpapering, striping old paintwork, staining woodwork, removing radiators, painting ceilings.

Home Security

Fitting door locks, securing windows, security bolts, security lighting, fitting door chains, general security tips.


Year Round Home Maintenance>

Re-grouting & sealing, replacing roof tiles, cleaning gutters & gully’s, radiator valve repairs, re-pointing, door & window maintenance, loft & pipe lagging, general maintenance tips.

eBay for Sellers Essential Training

In eBay for Sellers Essential Training, Christopher Spencer shows how to understand the selling process on eBay, including community rules and best practices, resources and support, and creating compelling listings. The course explores how to review active and completed listings, establish the value of merchandise, and list products. The course also covers using advanced search techniques, managing payments, and setting up an eBay Store.

Topics include:
Creating eBay and PayPal accounts
Building an About Me page
Performing advanced searches
Reviewing the competition
Understanding listing fees
Writing effective titles and descriptions
Exploring best practices for product photography
Understanding warranties and guarantees
Creating listings
Connecting eBay with social media
Handling offers
Packing and shipping merchandise
Leaving feedback
Tracking sales

Financial Literacy: Reading Financial Reports

A wealth of information is available to you if you know how to read financial documents. Being able to glean information from an income statement, a cash flow statement, or a balance sheet can give you an edge in understanding not only your own business but also your competition. In this course, Rudolph Rosenberg, a finance expert, takes you through the steps of making sense of what is contained in financial reports and how to read them. You'll also learn how they fit together to give you a view of a company's situation.

Topics include:
What is a financial statement?
Reading the balance sheet
Understanding depreciation, liabilities, and equity
Reading the income statement
Understanding revenue, costs, profitability, and net income
How cash flow works
Analyzing financial documents with context

The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.

Finance Fundamentals

At its core, finance is about deciding what to buy, getting the money you need to buy it, and efficiently managing your resources after making the purchase. In this course, Brigham Young University business professors Jim and Kay Stice provide a comprehensive overview of finance, and touch on everything from reading a balance sheet to understanding derivatives and securities. They tackle questions such as "What is the difference between short-term financial management and long-term financing?" and "What is the difference between a traditional bank, an investment bank, and an investment fund?" Along the way, you'll get a look at financial reports from companies such as Walmart and Toys "R" Us, and even analyze the data that go into personal financial decisions, such as deciding whether to buy a car and ensuring long-term financial success.


Topics include:
Understanding financial statements
Managing finances in the short term
Analyzing risk and return
Obtaining short-term and long-term financing
Understanding the stock and bond markets
Comparing the Facebook and Microsoft IPOs
Working with financial institutions
Using capital budgeting
Creating simple personal saving and investment plans

Basics of Household Wiring

Owning this DVD will give you the opportunity to watch wiring procedures over and over again until you ve mastered them. We provide diagrams and show you how electricity flows through your newly wired situation. The Basics of Household Wiring will jump start your confidence and teach you the professional secrets to this challenging field of home improvement.

Accounting Fundamentals Training

Learn about external financial statements, internal managerial accounting reports, income tax systems and how they interact in business decision-making. Brothers and professors of accounting at Brigham Young University Jim and Kay Stice review the accounting equation, the three primary financial statements, how to use accounting to aid decision making, and how income taxes figure into business and personal decisions. They use real-world example data from Walmart and other business so you can see how numbers drive everything from wages and product costs to home budgets. Topics include: What is accounting? Working with balance sheets and income statements Determining the costs of products Performing break-even analysis Determining average and marginal tax rates Understanding tax deductions and credits

Excel Data-Mining Fundamentals Training

You don't need to be a statistician to explore your own data. Learn how to use the software you already have, Excel, to perform basic data mining and analysis. Ron introduces core data-mining concepts like CRISP-DM (Cross Industry Standard Process for Data Mining), and then dives into the algorithms Microsoft offers for data mining right out of the box. Then learn about the data-mining structures and models in Excel SQL Server Analysis Services, and the new add-ins that make data mining in Excel both exceedingly powerful and incredibly easy. Topics include: -Solving business problems with data mining -Exploring Excel's data-mining algorithms -Data mining with Excel SQL Server Analysis Services -Using the Data Preparation tab -Detecting categories -Using the Prediction Calculator