Excel 2016 from Scratch Tutorials
Overview
An Excel series by Peter Kalmstrom
The
kalmstrom.com Excel 2016 from Scratch series includes 66 Tips articles
with demos that are an extra bonus to
the book Excel 2016 from Scratch, which is available both as paperback
and as e-book.
Many of the articles are in the form of exercises. Each of these articles
has a downloadable Excel file to work with and a demo that shows the solution
to the task. All "Exercise" articles has such a downloadable Excel file that
you can practice on.
All demos are recorded by Peter Kalmström, CEO and Systems Designer of kalmstrom.com
Business Solutions.
Peter uses Excel 2016, but the series is suitable for earlier versions of
Excel too.
Excel 2016 from Scratch covers a wide range of Excel features. Peter
starts with very basic information and proceeds through the series towards
more advanced tips and tricks.
You can follow the series by using the back and forward arrows at the bottom
of each page, or you can browse among the articles from the table of contents
below.
Bold text in an article content list shows what is new in the demo
that is described. Features that are not bolded have been shown in earlier
demos in the series as well.
The combination of book and Tips articles will of course give a more structured
learning and a deeper understanding of how Excel works, but if you just want
to check some features you are welcome to browser among the articles here.
Otherwise we recommend you to also
get the book.
|
Excel 2016 from Scratch tutorials
- Terms, navigation and other basics you need
to know if you have never used Excel before
- Copy
- Format cells
- Formulas
Use Excel formulas that calculate cell values
-
Introduction
to formulas
-
The benefits of using formulas
-
Calculate
house costs with formulas A
-
Calculate
house costs with formulas B
-
Calculate
house costs with formulas C
-
Calculate sums A – Exercise
- c
Calculate sums B – Exercise
-
Calculate sums C – Exercise
-
Calculate sums D – Exercise
-
Calculate
house costs with formulas D
-
Relative Cell References – Exercise
-
Multiply cell values – Exercise
-
Percentage and sums – Exercise
-
Maximum, minimum and average values – Exercise
-
Calculate Sum, Total, Max and Min – Exercise
-
Sum, Average, Max and Min – Exercise
-
Formulas – repetition – Exercise
-
Sums, Max, Average, Median – Exercise
-
Time Differences Max, Min and Median – Exercise
-
Bind Datasheets A – Exercise
-
Bind Datasheets B– Exercise
-
Absolute Reference – Exercise
-
Lock cells – Exercise
-
Unlocked input cells – Exercise
-
The Logical IF Function – Exercise
-
Vertical Lookup A – Exercise
-
Vertical Lookup B – Exercise
-
Vertical Lookup C, Fuction Guide
-
Vertical Lookup D, Search – Exercise
-
Custom Number Formats A
-
Custom Number Formats B – Exercise
-
Modify Numbers – the TRUNC and ROUND functions – Exercise
-
What-If-Analysis A – Scenario Manager, Goal Seek, Data Table
-
What-If-Analysis B – Exercise, Scenario Manager
-
What-If-Analysis C – Exercise, Scenario Manager, Goal Seek
- Visualization, charts
-
Quick Analysis – Exercise
-
Visualization A – Exercise
-
Visualization B – Exercise
-
Visualization C – Exercise
-
Visualization D – Exercise
-
Visualization E – Exercise
-
Visualization F – Exercise, Repetition
-
Visualization G – Exercise, Charts and Sparklines
-
Visualization H – Exercise, Table, Subtotal, Slicer
-
Visualization I – Exercise, Pivot Table, Grouped View
-
Visualization J – Exercise, Pivot Table and Graph, Slicer
-
Visualization K – Exercise, Pivot Table and Graph, Databars, Slicer
-
Visualization L – Exercise, Slicers, Pivot Table and Chart
-
Visualization M – Exercise, Pivot Table and Chart, Conditional formatting
-
Visualization N – Exercise, Pivot Data Validation, Pivot Table and
Chart
-
Visualization O – Exercise, Pivot Table and Chart, Percentage
-
Timeline
-
Power View
- Miscellaneous
|
|

|
|