1.0מעין פולג - אקסל למתקדמיםhttps://excel-vba.co.ilMaayanhttps://excel-vba.co.il/author/admin/Excel 2013 Pivot Tables: Including the Data Model - מעין פולג - אקסל למתקדמיםrich600338<blockquote class="wp-embedded-content"><a href="https://excel-vba.co.il/product/excel-2013-pivot-tables-including-data-model/">Excel 2013 Pivot Tables: Including the Data Model</a></blockquote>
<script type='text/javascript'>
<!--//--><![CDATA[//><!--
/**
* WordPress inline HTML embed
*
* @since 4.4.0
* @output wp-includes/js/wp-embed.js
*
* This file cannot have ampersands in it. This is to ensure
* it can be embedded in older versions of WordPress.
* See https://core.trac.wordpress.org/changeset/35708.
*/
(function ( window, document ) {
'use strict';
var supportedBrowser = false,
loaded = false;
if ( document.querySelector ) {
if ( window.addEventListener ) {
supportedBrowser = true;
}
}
/** @namespace wp */
window.wp = window.wp || {};
if ( !! window.wp.receiveEmbedMessage ) {
return;
}
window.wp.receiveEmbedMessage = function( e ) {
var data = e.data;
if ( ! data ) {
return;
}
if ( ! ( data.secret || data.message || data.value ) ) {
return;
}
if ( /[^a-zA-Z0-9]/.test( data.secret ) ) {
return;
}
var iframes = document.querySelectorAll( 'iframe[data-secret="' + data.secret + '"]' ),
blockquotes = document.querySelectorAll( 'blockquote[data-secret="' + data.secret + '"]' ),
i, source, height, sourceURL, targetURL;
for ( i = 0; i < blockquotes.length; i++ ) {
blockquotes[ i ].style.display = 'none';
}
for ( i = 0; i < iframes.length; i++ ) {
source = iframes[ i ];
if ( e.source !== source.contentWindow ) {
continue;
}
source.removeAttribute( 'style' );
/* Resize the iframe on request. */
if ( 'height' === data.message ) {
height = parseInt( data.value, 10 );
if ( height > 1000 ) {
height = 1000;
} else if ( ~~height < 200 ) {
height = 200;
}
source.height = height;
}
/* Link to a specific URL on request. */
if ( 'link' === data.message ) {
sourceURL = document.createElement( 'a' );
targetURL = document.createElement( 'a' );
sourceURL.href = source.getAttribute( 'src' );
targetURL.href = data.value;
/* Only continue if link hostname matches iframe's hostname. */
if ( targetURL.host === sourceURL.host ) {
if ( document.activeElement === source ) {
window.top.location.href = data.value;
}
}
}
}
};
function onLoad() {
if ( loaded ) {
return;
}
loaded = true;
var isIE10 = -1 !== navigator.appVersion.indexOf( 'MSIE 10' ),
isIE11 = !!navigator.userAgent.match( /Trident.*rv:11\./ ),
iframes = document.querySelectorAll( 'iframe.wp-embedded-content' ),
iframeClone, i, source, secret;
for ( i = 0; i < iframes.length; i++ ) {
source = iframes[ i ];
if ( ! source.getAttribute( 'data-secret' ) ) {
/* Add secret to iframe */
secret = Math.random().toString( 36 ).substr( 2, 10 );
source.src += '#?secret=' + secret;
source.setAttribute( 'data-secret', secret );
}
/* Remove security attribute from iframes in IE10 and IE11. */
if ( ( isIE10 || isIE11 ) ) {
iframeClone = source.cloneNode( true );
iframeClone.removeAttribute( 'security' );
source.parentNode.replaceChild( iframeClone, source );
}
}
}
if ( supportedBrowser ) {
window.addEventListener( 'message', window.wp.receiveEmbedMessage, false );
document.addEventListener( 'DOMContentLoaded', onLoad, false );
window.addEventListener( 'load', onLoad, false );
}
})( window, document );
//--><!]]>
</script><iframe sandbox="allow-scripts" security="restricted" src="https://excel-vba.co.il/product/excel-2013-pivot-tables-including-data-model/embed/" width="600" height="338" title="“Excel 2013 Pivot Tables: Including the Data Model” — מעין פולג - אקסל למתקדמים" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe>http://excel-vba.co.il/wp-content/uploads/2016/08/PIV-2.jpg800800A pivot table is a simple, yet powerful technique, that enables Excel's users to transform data overload into meaningful and organized knowledge. With pivot tables you can: ⦾See the data in dozens of different ways with a simple mouse drag ⦾Perform fast calculations with no need for formulas ⦾ Focus on another part of the data each time and get a clear picture ⦾ Show more trends and patterns ⦾ Create dozens of reports and charts to analyze your data While reading the book and using the practice files, you will know to: Create a Pivot Table ⦾ Select data from the current file ⦾ Selec data from another Excel file ⦾ Change the data source ⦾ Create a pivot table based on a dynamic data table Perform Calculations: ⦾ Use sum, average, minimum, maximum and count ⦾ Show Percentage of a column total, row total and Grand total ⦾ Display the running total ⦾ Group numeric and date data ⦾ Use calculated field and calculated item Change The Report Structure ⦾ Switching columns and rows ⦾ Adding columns or rows ⦾ Adding a page break between items Format your Pivot Tables ⦾ Add totals and Subtotals ⦾ Sort o Filter You will also know to ⦾ Add slicers and to manipulate then ⦾ Add a timelines and to manipulate it ⦾ Add charts to your pivot tables ⦾ Use the new and innovative feature: "The Data Model" And, of course, You will learn some cool tips and tricks! The book includes excercises. you can download the files here * הספר אמור להגיע למייל בתוך כעשרים דקות מרגע התשלום. * למען הסר ספק - מדובר בספר דיגיטלי להורדה מיידית * הסיסמה לפתיחת הספר היא המייל שאיתו נרשמתם (יש להקפיד על אותיות גדולות וקטנות) * אם אתם עובדים עם ג'ימייל, ייתכן שהספר יגיע ל'קידומי מכירות' (ואם לא מצאתם אותו שם, צרו קשר)