The Excel you need in a complex industry.
From formulas to PivotTables, from simple filters to advanced ones: 63 free articles with downloadable workbooks, built on the cases that pricing, market access, commercial and finance teams meet every day.
Pick a topic
Functions
Formulas from first steps to LET and LAMBDA.
19 articlesWorkbook Design
Tables, names, validation, controls and protection.
9 articlesData Management
Import, clean and prepare data, up to Power Query.
9 articlesPivotTables
Summarize thousands of rows in a few clicks.
7 articlesFormatting, Charts & Print
Conditional formatting, charts, dashboards and print setup.
9 articlesWhat-If Analysis
Goal Seek, scenarios and data tables.
2 articlesVBA & Automation
Record, read and write macros.
8 articlesAbout Excel
The 1900 leap year, genes renamed to escape date conversion, and other stories from the history of a program we all use.
The books
Excel for Pharma, a professional book for planning, forecasting and decision support.