This video focuses on external data and digs into the details for retrieving data from other sources. You will learn how to retrieve data from simple text files as well as how to prepare data for use with Excel.
£99.00
VAT calculated on checkout
This video begins by comparing the formula-based reports to PivotTables. It digs into the details between these two report types so that you are comfortable applying them to specific workbooks.
£99.00
VAT calculated on checkout
As popular as the VLOOKUP function is, it has limitations. This video walks through the limitations, suggests how to improve the VLOOKUP function, and discusses how to move beyond VLOOKUP altogether.
£99.00
VAT calculated on checkout
Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check
£79.00This video discusses dynamic headers and their use in automating reporting workbooks. It reviews how to transpose the orientation of the conditional summing function to produce horizontal or crosstab reports.
£99.00
VAT calculated on checkout
This video explains how to use Excel's lookup functions to perform list comparisons, and how to perform multicolumn list comparisons without first combining several columns into a single lookup column.
£99.00
VAT calculated on checkout
This video covers key date and text functions. It also demonstrates how to greatly improve the utility of the conditional summing function by using comparison operators.
£99.00
VAT calculated on checkout
This video opens with conditional summing, which will absolutely improve efficiency in your reporting workbooks. It also explores lookup basics and why lookups are preferable to direct cell references and the details of VLOOKUP.
£99.00
VAT calculated on checkout
This video finishes the PivotTable discussion by examining various ways to present report values, discussing the subtly of properly sorting a recurring-use PivotTable, and covering numerous filtering options, including slicers.
£99.00
VAT calculated on checkout
Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization
£79.00This video covers the five workbook design principles that help you build reliable recurring-use workbooks, as well as workbook and worksheet organisation ideas.
£99.00
VAT calculated on checkout
This video covers one of the most significant enhancements rolled out with Excel 2007, the table feature. It also covers named references and the five most important shortcuts so that you can improve your personal productivity.
£99.00
VAT calculated on checkout