Microsoft Excel 2013 Intermediate

Course details

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 Same Match

Utilizing HLOOKUP

  Chapter 2 . Data Linking
Linking to other Spreadsheets and keepig 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
Outline

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
Edate

Eomonth

Workday

Days

Networkdays

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 Updated on 11 July, 2018