Microsoft Excel 2013 Intermediate

Using formulas in-depth, working with data table charts, creating pivot tables, looking at logical functions, optimizing your data, using data linking, presenting and reporting, filtering data in your worksheet and protection techniques.

Chapter 1

Getting to know more about Formulas

• How to Create Random Numbers in Excel
• How to Round your Values in Excel
• Data Summary in Status Bar
• How to exit a cell without saving the changes
• How to Calculate Running Totals
• Looking at Whole Units and Remainders
• Looking at FORMULATEXT
• Working with Conditional Maths
• Monitoring the Value of a Cell
• How to add Comments to your Formula
• Doing an Audit on our Formulas (Free Preview)
• Using VLOOKUP to get Not Exact Match
• Using VLOOKUP to get the Same Match
• Utilizing HLOOKUP

Chapter 2

Data Linking

Linking to other Spreadsheets and keeping the links Updated

Chapter 3

More about Charts

• Working With An Embedded Chart (Free Preview)
• Printing An Embedded Chart
• Creating A Chart Sheet
• Build and Use a Chart Template
• Create a Sparkline
• Adding A Text Box To A Chart
• Drawing Shapes In A Chart

Chapter 4

The What-if Analysis

• How to use Scenario (Free Preview)
• Viewing and removing Scenario's
• Checking Summary of changes
• A look at Editing And Deleting Scenario's
• Using Goal Seek
• Creating a One-Variable Table
• Creating a Two-Variable Data Table

Chapter 5

Keeping your Work Secure Locally and Shared

• Locking and unlocking cells
• How to protect the data in your workbook (Free Preview)
• Giving your workbook a password for added protection
• A look at how to Share your workbook
• Merge Workbooks

Chapter 6

Looking at Pivot Tables

• How to Creating a Pivot Table
• Changing how our Pivot Tables looks
• Getting extra calculations from your pivot table
• Refreshing and Formatting a PivotTable

Chapter 7

Presenting and Reporting

• Adding Formating to your cells
• How to Custom Number Formats
• Working with Conditional Formats with Built-in Rules
• Working with Conditional Formats with Custom Rules
• Building Pie Charts

Chapter 8

Optimizing Data

• Naming Ranges
• A look at Excel Tables
• How to recording Macros (Free Preview)

Chapter 9

Date and Time Functions

• Edit
• Eomonth
• Workday
• Days
• Network days
• Yearfrac

Chapter 10

Filtering Data

• Applying And Using A Filter
• Multiple Value Filters
• Using Wildcards

Chapter 11

Logical Functions

• Using IF To Display Text
• Using IF To Calculate Values
• Using AND
• Using NOT
• Using OR

Chapter 12.

Formating, Validating and Updating

• Data Validating
• Adding Cell Style
• Creating Drop-Down Lists
• Data date Validation
• Circling Invalid Data

Chapter 13

Learn from complete sample exercise (Projects)

• Receipt
• Household Budget
• Fiscal QTR
• Financial