All seven Shortcut Press guides in one purchase. Each guide is complete on its own, with its PDF guide, practice files and worked solutions, so you can work through them in any order.
What the library includes
The library contains all seven guides. Each one is the same complete guide sold on its own page; follow the links for each guide's full contents, level and preview pages.
Spreadsheet Formulas & Functions
Cell references, lookups, logical, text and date functions, and error handling, for Excel and Google Sheets. Beginner to intermediate level. Uses Microsoft Excel or Google Sheets.
Data Analysis with Pivot Tables & Charts
Cleaning data, building pivot tables, summarizing and filtering, and choosing and formatting charts. Intermediate level. Uses Microsoft Excel or Google Sheets.
Professional Document Formatting
Styles, headings, automatic tables of contents, page layout, and reusable templates in Word and Google Docs. Beginner level. Uses Microsoft Word or Google Docs.
3D Modeling Fundamentals in Blender
Navigating the interface, modeling with basic shapes, modifiers, materials, lighting, and rendering a scene. Beginner level. Uses Blender.
Video Editing in DaVinci Resolve
Organizing footage, cutting on the timeline, transitions, titles, color correction, audio cleanup, and exporting. Beginner to intermediate level. Uses DaVinci Resolve.
Interface Design in Figma
Frames, auto layout, components, styles, and prototyping a simple app screen flow. Beginner to intermediate level. Uses Figma.
Vector Illustration in Inkscape
Shapes, paths, the pen tool, text, and exporting for print and web. Beginner level. Uses Inkscape.
Inside the guide
Every chapter follows the same pattern: the skill is explained, broken into steps, practiced in an exercise, and checked against a worked solution. These illustrations show the three kinds of page you will find in the PDF.
Illustrations represent the layout of guide pages. They are not reproductions of any software's interface.
What's in the .zip
Your .zip download
- Spreadsheet Formulas & FunctionsPDF guide and practice spreadsheets
- Data Analysis with Pivot Tables & ChartsPDF guide and practice datasets
- Professional Document FormattingPDF guide and practice documents
- 3D Modeling Fundamentals in BlenderPDF guide and starter project files
- Video Editing in DaVinci ResolvePDF guide and practice footage
- Interface Design in FigmaPDF guide and starter files
- Vector Illustration in InkscapePDF guide and practice files
One folder per guide. Each PDF explains every skill step by step with annotated illustrations, followed by practice exercises with worked solutions. No software is included.
Software required
Each guide uses its own program. None of the software is included with the library; you need your own copy or access to each program you want to work with, obtained separately from its maker. You only need the programs for the guides you choose to work through.
- Spreadsheet Formulas & Functions: Microsoft Excel or Google Sheets
- Data Analysis with Pivot Tables & Charts: Microsoft Excel or Google Sheets
- Professional Document Formatting: Microsoft Word or Google Docs
- 3D Modeling Fundamentals in Blender: Blender
- Video Editing in DaVinci Resolve: DaVinci Resolve
- Interface Design in Figma: Figma
- Vector Illustration in Inkscape: Inkscape
About software updates. Software makers update their programs, so menus and button locations can change between versions. When an update changes the steps in any of the seven guides, that guide is revised, and updated files are free to anyone who bought the library.
How the guide works
This is a self-study guide. You read each step, carry it out in your own copy of the software, then do the exercises and compare your work with the worked solutions. There is no video, no live instruction, no tutoring, and no feedback on your work. Everything you get is in the .zip.
Is the library a good fit?
Who it's for
- You work with several of these programs, or plan to.
- You want every guide's practice files and reference pages in one place.
- You like to work through written guides at your own pace, in any order.
Who it isn't for
- You only need one or two programs. The individual guides may suit you better.
- You want to use the guides with a class or team. That needs a separate group license; see the FAQ.
- You want video lessons, live help, or someone to review your work.