Learning Visual Basic for Microsoft Excel Training Video

Learning Visual Basic for Microsoft Excel Training Video
English | Size: 950.23 MB
Category: Video Training


In this VB for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. Seasoned Microsoft trainer Guy Vaccaro starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within Excel.
[Read more…]

Creating Excel Power Pivot and Power View Dashboards

Creating Excel Power Pivot and Power View Dashboards
English | Size: 1.06 GB
Category: Video Training


All it takes to point your business in the right direction are some strategic insights from your data. In this course, author Ron Davis uses the Power Pivot and Power View plugins to build robust dashboards for analyzing key metrics in Excel—all in just over an hour. First, learn some dashboard design guidelines—such as understanding your audience and identifying necessary metrics—before getting started. Then Ron walks you through importing data, setting up calculated fields and columns, creating key performance indicators (KPIs), and building the PivotTables and PivotCharts for the dashboards. Last, find out how to add charts and eye-catching visuals with Power View, in order to make your dashboards easily understood. [Read more…]

Word 2013 Power Shortcuts

Word 2013 Power Shortcuts
English | Size: 462.98 MB
Category: Video Training


You already know the basics of Word 2013. Ready to take your skills to the next level? Unlock the full capabilities of this powerful word processor with advanced tips, tricks, and shortcuts from author Maria Langer. First, explore five tips you should know regardless of how you use Word, including tips for selecting text and changing the document view. Then dive into shortcuts for managing files, entering and editing text, formatting documents, and publishing. [Read more…]

Word 2013: Templates in Depth

Word 2013: Templates in Depth
English | Size: 235.67 MB
Category: Video Training


If you know how to use templates, you can become much more efficient in Word. In this course, Gini Courter helps you get the most out of templates in Word 2013. She shows how to find, open, and customize the thousands of existing templates, as well as how to transform your own documents into templates you can reuse again and again. Next, explore template styling and ways of locking down certain areas of a document to keep users from editing them. Then discover how to share templates—via email, a network, and SharePoint—and dig into advanced features, including building blocks, content codes, and add-ins. [Read more…]

Data Modeling with Excel Power Pivot

Data Modeling with Excel Power Pivot
English | Size: 463.03 MB
Category: Video Training


Aggregating and analyzing data from different sources is made easy with Excel’s Power Pivot plugin. But before you can glean insights from your data, you’ll need to know how to build an effective data model, or collection of tables. In this course, Ron Davis covers all the steps for data modeling with Excel: adding data sources, setting up relationships between tables, and configuring hierarchies. Additionally, he explores the power of DAX, the language behind the calculated columns and calculated fields that make for powerful PivotTables.
[Read more…]

Excel Data Analysis: Forecasting

Excel Data Analysis: Forecasting
English | Size: 296.48 MB
Category: Video Training


Professor Wayne Winston has taught advanced forecasting techniques to Fortune 500 companies for more than twenty years. In this course, he shows how to use Excel’s data-analysis tools—including charts, formulas, and functions—to create accurate and insightful forecasts. Learn how to display time-series data visually; make sure your forecasts are accurate, by computing for errors and bias; use trendlines to identify trends and outlier data; model growth; account for seasonality; and identify unknown variables, with multiple regression analysis. A series of practice challenges along the way helps you test your skills and compare your work to Wayne’s solutions. [Read more…]

Excel Data-Mining Fundamentals

Excel Data-Mining Fundamentals
English | Size: 402.66 MB
Category: Video 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. [Read more…]

Cleaning Up Your Excel 2013

Cleaning Up Your Excel 2013
English | Size: 528.4 MB
Category: Video Training


Need to get data from a business-management system file, database software, text file, or poorly designed Excel worksheet into optimal shape for Excel 2013? This course can help. Dennis Taylor explores the functions, commands, and techniques in Excel that restructure data, remove unwanted characters, convert data into the desired format, and prepare data for efficient analysis. He’ll cover adjusting row and column placement; transposing data with Replace and Substitute functions, the Text to Columns command, and the new Flash Fill; and formatting and converting text, numbers, and other values.
[Read more…]

Excel 2013: Charts in Depth

Excel 2013: Charts in Depth
English | Size: 745.09 MB
Category: Video Training


Charts allow you to communicate information visually, in a way that’s more impactful than raw data, and they happen to be one of the most powerful and easy-to-use features in Microsoft Excel. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to exploded pies, and decide which type works best for your data. Plus, learn how to fine-tune your chart’s color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources. [Read more…]

Excel 2013 Tips and Tricks

Excel 2013 Tips and Tricks
English | Size: 780.15 MB
Category: Video Training


Increase your Excel productivity with the power user tips and tricks packed into this fast-paced course. Dennis Taylor will show you how to create formulas quickly, split data into columns, apply formatting, build charts, and fast-track routine data-entry chores. Short on time? Make sure to check out the “Top Ten Shortcuts” and “Ten Tiny Tips” chapters for a quick productivity boost. Start now and get an immediate return on your investment, with powerful techniques that will save you hours every week.
[Read more…]