Basics of Function calculations 

• What’s a function? Create and use Excel functions. 
• What is DAX? Calculations in a Table-object. 

Manage and analyze large data packages

• How do I sort the data in a table in the order I want? Sort and arrange a table 
• How do I show only the part of my table that I want? Use the filter feature. 
• How do I display the table header bar when browsing a table? Pin a title bar or rows. 
• How do I print a large table? Automatically fit a table to a specific number of pages, and table page layouts, such as margins and orientation. 
• What does Format as a Table mean? The most important features of the tool Format as a table. 

Visual and clear table 

• How do I visualize content as a chart? Visualize data using column, pie, and line charts. 
• How do I automatically separate the essential amounts from the mass? Apply conditional formatting. 
• Can I view changes in values with trendlines? Take advantage of Sparklines 

Keywords 

Excel, Basics, Spreadsheet, Beginners, Reference, Cell Reference, Functions, Calculation, Table, Chart, Print, Graphics