Online
- Duration / Course length: Upto 4 Hours Start now
- Course delivery: This course is delivered in video format
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 Ultima actualização em 11 July, 2018
