LEARNING FOR LIFE

Get Yourself a Better Life! Free eLearning Download

Excel 2013: Working with Dates and Times

Leave a Comment

Excel 2013: Working with Dates and Times
English | Size: 201.95 MB
Category: Video Training


Most Excel users incorporate dates and times in their spreadsheets, but getting them to show up the way you want can be difficult. Excel expert Dennis Taylor shares his solutions for formatting and calculating dates and times in Excel 2013. This one-hour course explains what’s going on behind the scenes when Excel stores dates and times, gives tips for entering them, and teaches the options for date and time formatting. It also demonstrates the various date and time functions and shows how to calculate with dates and times in a range of scenarios.
[Read more…]

Excel VBA in Depth

Leave a Comment

Up and Running with VBA in Excel
English | Size: 185.07 MB
Category: Video Training


In Excel: VBA in Depth, Excel and VBA expert Curt Frye introduces object-oriented programming and shows how to automate routine tasks and provide custom functionality to enhance Excel performance and efficiency. This course introduces the Visual Basic for Applications programming language, covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel 2007 object model. Programming techniques are demonstrated through real-world examples. Exercise files accompany the course.
[Read more…]

Financial Analysis: Analyzing the Bottom Line with Excel

Leave a Comment

Financial Analysis: Analyzing the Bottom Line with Excel
English | Size: 218.84 MB
Category: Video Training


Learn how to analyze the bottom line (or profitability) of your company and identify areas of under- or overperformance with Excel. Rudolph Rosenberg, author of the Financial Analysis series, shows how to use the data your company generates every day to break down your gross margin and operating expenses. He introduces the tools and techniques you can use in Excel to prepare and analyze that data, including PivotTables and the invaluable SUMIF function. Plus, you’ll learn to identify and analyze sales and marketing spending, staff expenditures, and productivity separately, so you can get a really clear picture of your data from multiple angles.
[Read more…]

Up and Running with Power Pivot and SharePoint 2013

Leave a Comment

Up and Running with Power Pivot and SharePoint 2013
English | Size: 115.24 MB
Category: Video Training


Learn how to combine the power of Excel’s Power Pivot and Power View tools with SharePoint 2013, to view, analyze, and manipulate large amounts of data. Neicole Crepeau guides you through the process of creating workbooks and dashboards to help your organization use big data to answer big questions. She shows how to connect to data sets and how to create relationships between them, plus how to use Power View to visualize the information. Then, moving on to SharePoint, Neicole explains how to create a Business Intelligence Center site and dashboards from your Excel workbooks.
[Read more…]

Up and Running with Excel Cluster Analysis

Leave a Comment

Up and Running with Excel Cluster Analysis
English | Size: 145.05 MB
Category: Video Training


Learn how to use Excel’s built-in data management and computation functions to identify clusters of data points—with little or no VBA! Author Curt Frye shows you how to set up a worksheet for cluster analysis, create formulas that identify the closest focal point (centroid) for each row, and analyze your results in an Excel table or XY scatter chart. Members who don’t mind recording macros or writing VBA code can learn how to automate some parts of the procedure. [Read more…]

Access 2013 Power Tips

Leave a Comment

Access 2013 Power Tips
English | Size: 390.67 MB
Category: Video Training


Your tables are built, your relationships are defined, your queries and reports are ready to run. But is your Access database really ready for users? With these power tips, you can create a better user experience for your database and transform it into a fast, efficient, and even fun place to work. Adam Wilbert will show you how to remove typical Access interface elements (like the Welcome screen) for a better start-up experience, and borrow some tricks from web design to make your database more attractive and interactive. Plus, learn how to clean up a cluttered navigation pane, filter long lists with cascading combo boxes, and build in contextual help and keyboard shortcuts that your power users will thank you for. Adam also shows how to package the database for users who don’t have Microsoft Access installed.
[Read more…]

Word 2013: Mail Merge in Depth

Leave a Comment

Word 2013: Mail Merge in Depth
English | Size: 233.46 MB
Category: Video Training


Take advantage of Word’s Mail Merge feature to save time building customized documents. This course offers tutorials on creating personalized letters, envelopes, labels, and even email messages. Author Gini Courter shows how to connect to data sources in Access, Outlook, and Excel; create new data sources; add attachments to merged email messages; use IF…THEN…ELSE and other rules for advanced mail merges; and troubleshoot Mail Merge issues.
[Read more…]

Learn Excel Formulas & Functions + Make a Pro Excel Template

Leave a Comment

Learn Excel Formulas & Functions + Make a Pro Excel Template
English | Size: 1.23 GB
Category: CBTs


Operators and Precedence of Operators: I will start from zero and if you don’t know about the operators and precedence of operators that Excel uses in its formulas, then it will be tough for you to decode complex Excel formulas. So I have covered them in very details.
How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the Excel formulas using the Insert Function and Function Arguments dialog box.
Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your finance related jobs. So this function is covered in details at the start of the course. [Read more…]

Excel VBA

Leave a Comment

Excel VBA
English | Size: 1.25 GB
Category: Tutorial


1 – Getting started with Range object, running and debugging
2 – Using the Cells object with and without range object, named ranges
3 – Using For and Next with variable, using loops for custom reporting
4 – IF THEN statements within the FOR NEXT loop
[Read more…]

ExcelVbaIsFun – Excel VBA

Leave a Comment

ExcelVbaIsFun – Excel VBA
English | Size: 1.25 GB
Category: Video Training


Auto-Hide Your Worksheet When You Click Away! Excel VBA
Capture Worksheet info To Userform and Save Back to Worksheet
Change MultiPage Tabs to Left, Right, Top or Bottom – Easy
Count and CountA in VBA Excel
CountIF Excel VBA
Custom Ranges and Getting LastRow to Work with Copy and Paste
[Read more…]