Your One-Day Quest

I. Tame the Workbook

Before you can work faster, your workbook needs to make sense.

Learn how to move confidently around Excel, work with multiple worksheets, manage rows and columns, keep important information visible, and organize a workbook so you spend less time hunting for things.

You will practice how to:

• Move around large worksheets without endless scrolling.
• Keep headings visible while reviewing long datasets.
• Work more efficiently across multiple worksheets.
• Insert, delete, resize, hide, and reveal worksheet elements appropriately.
• Organize workbook tabs so information is easier to find.
• Use viewing options that make large spreadsheets easier to manage.

II. Enter Once, Work Smarter

Not everything needs to be typed one cell at a time.

Discover faster ways to enter, repeat, copy, move, and extend information while avoiding unnecessary manual work.

You will practice how to:

• Quickly continue common sequences such as dates, months, and numbers.
• Copy information without unintentionally copying everything along with it.
• Reuse existing content without repeatedly retyping it.
• Rearrange information efficiently.
• Correct multiple occurrences of the same value at once.
• Reduce repetitive clicking and typing through practical shortcuts.

III. Turn Lists into Working Data

A spreadsheet becomes much easier to manage when Excel understands that your list belongs together.

Learn how to structure everyday records such as employee lists, inventory logs, customer databases, expense trackers, and transaction records so they remain usable as they grow.

You will practice how to:

• Turn an ordinary range into a structured, expandable dataset.
• Keep headings and formatting consistent as new records are added.
• Organize columns so information is easier to work with later.
• Recognize spreadsheet layouts that look attractive but make data difficult to use.
• Build cleaner datasets that are ready for future analysis.

IV. Stop Searching Row by Row

You should not have to scroll through 2,000 records just to find one employee, transaction, or product.

Learn how to quickly narrow down information and bring the records you need into view.

You will practice how to:

• Arrange lists alphabetically, numerically, or according to multiple conditions.
• Show only records that meet specific criteria.
• Quickly find particular words, values, or entries.
• Replace repeated information across a worksheet safely.
• Identify the highest, lowest, earliest, latest, or otherwise relevant records from a list.
• Work with large datasets without losing your place.

V. Make Numbers Say What They Mean

0.15, 15%, and ₱0.15 contain the same underlying number but communicate very different things.

Learn how to present numbers, dates, percentages, currencies, and text appropriately without changing the underlying information.

You will practice how to:

• Display monetary values clearly and consistently.
• Present percentages correctly.
• Standardize the appearance of dates.
• Control decimal places without manually changing values.
• Make long numbers and codes display appropriately.
• Use alignment, borders, emphasis, and spacing without turning the worksheet into a rainbow.

The goal is not decoration. It is clarity.

VI. Let Excel Handle the Arithmetic

A spreadsheet should calculate. A calculator beside your keyboard should not be doing all the work.

Build simple everyday calculations that update when your data changes.

You will practice how to:

• Add, subtract, multiply, and divide values directly in Excel.
• Calculate totals from lists of numbers.
• Create basic calculations that can be copied across multiple records.
• Understand why some copied calculations behave differently than expected.
• Recognize and correct common mistakes in simple calculations.

This module establishes the foundation needed for more sophisticated formulas without turning the day into a formula-intensive course.

VII. Build a Workbook Others Can Actually Use

A workbook is rarely useful if only its creator understands it.

Bring together the day's techniques to create worksheets that are easier to read, navigate, update, and hand over to someone else.

You will practice how to:

• Create clear headings and logical sections.
• Make worksheets easier to scan.
• Keep related information together.
• Avoid unnecessary formatting and clutter.
• Prepare spreadsheets that another person can understand without a lengthy explanation.

VIII. From Screen to Page

Everything looks perfect until you click Print.

Learn how to prepare worksheets for reports, meetings, submissions, and physical copies without fighting with mysterious extra pages.

You will practice how to:

• Control which part of a worksheet is printed.
• Fit information appropriately onto pages.
• Repeat headings across multiple printed pages.
• Adjust orientation, margins, and scaling.
• Add useful page information where appropriate.
• Preview your output before wasting paper and ink.

Your Final Challenge

Build an Everyday Business Workbook

At the end of the course, you will apply the day's skills to organize and prepare a practical business workbook.

Starting from an ordinary worksheet, you will transform it into something that is easier to:

navigate → update → search → filter → calculate → read → print

The challenge brings together the techniques learned throughout the day and gives you a workbook you can use as a model for improving your own files at work.

Who Should Attend?

This SIGIL is designed for anyone who uses Microsoft Excel for everyday work, including:

• Office and administrative professionals
• HR, Finance, Sales, Operations, and support teams
• Supervisors and managers
• Entrepreneurs and business owners
• Freelancers and independent professionals
• Students and early-career professionals preparing for spreadsheet-heavy roles
• Anyone who has learned Excel informally and wants to fill in the gaps

You do not need to be an Excel expert.

In fact, this course is particularly useful for people who have been using Excel for years but suspect there are much easier ways to do the things they already do.

Prerequisites

None.

Participants should be comfortable using a computer, keyboard, and mouse, but no previous formal Excel training is required.

Software Requirement

Training activities are designed for Microsoft Excel for Microsoft 365 on Windows.

Participants using other desktop versions of Microsoft Excel may still attend, but certain features, commands, or interfaces may differ or may not be available.

A Windows laptop with Microsoft Excel installed is recommended for the best training experience.

Your SIGIL Passport

Every adventurer needs a record of the journey.

Each participant receives a SIGIL Passport, a practical learning companion containing useful spreadsheet references such as keyboard shortcuts, terminology, quick guides, and other resources you can return to after training.

As you explore more courses in the SIGIL series, your passport grows with your journey, marking the spreadsheet disciplines you have mastered along the way.

What’s Included

Your ₱3,999 registration includes:

• One-day face-to-face training, 9:00 AM–5:00 PM
• Hands-on training files and exercises
• Your SIGIL Passport and learning references
• Printed Certificate of Completion
• Lunch and snacks
• Unlimited brewed coffee
• Quest Keepsakes
  A few Spreadsheet Magic mementos from your training journey, including your own wand and other keepsakes.
• One month of post-training chat consultation

Registration Fee: ₱3,999 per participant, inclusive of applicable taxes.

Payment may be made via bank transfer or credit card.

Your seat is confirmed upon payment.

SIGIL is primarily offered on a prepaid basis. Approved alternative billing arrangements may be considered for government agencies and organizations with established procurement requirements.

Gather Your Guild: 5+1

Some quests are better with companions.

Register and pay for five participants in the same SIGIL session and bring a sixth participant at no additional cost.

The 5+1 offer applies to prepaid public registrations only. Registrations under approved institutional billing, purchase order, promissory note, or post-training payment arrangements are not eligible.

Part of the SIGIL Series

SIGIL: Spreadsheet Intensive Guided Instruction Lab is a collection of focused, one-day training programs designed to develop practical spreadsheet capability one discipline at a time.

Each SIGIL stands on its own. You do not need to complete the series in sequence, and previous SIGIL attendance is not required if you already have the recommended skills.

Taken together, however, the courses create a broader journey toward spreadsheet mastery:

Excel for Everyday Business

• Formulas & Functions for Business
• Mistake-Proof Your Spreadsheets
• Data Cleaning & Preparation
• PivotTables for Business Analysis
• Excel Dashboards
• Excel Macros & Automation

Begin with the skill you need. Continue the quest when you're ready.

About SIGIL

One SIGIL. One focused skill. A larger journey.

SIGIL: Spreadsheet Intensive Guided Instruction Lab is Spreadsheet Magic’s series of focused, one-day learning experiences built around practical spreadsheet skills you can use at work.

Each SIGIL explores a distinct area of Excel, from everyday productivity and formulas to data preparation, analysis, dashboards, and automation. Every course is designed to stand on its own, so you can begin wherever your current needs take you.

Complete more SIGILs as your journey continues, build a broader set of spreadsheet capabilities, and mark each achievement in your SIGIL Passport.

Choose the skill you need today. Continue your quest toward digital mastery.