Resources · Video

Braintek Video Tutorials

Practical, short how-to videos from our team — a full Excel series (lookups, formulas, pivot tables, dashboards) plus a co-managed IT walkthrough. Use them today, or let us handle it for you.

See the channel on YouTube →

Excel — Lookups & References

Pull the right value from anywhere in your workbook.

VLOOKUP vs XLOOKUP When to use each lookup and why XLOOKUP fixes VLOOKUP’s biggest limits — pull the right value from anywhere in your sheet.

INDEX & MATCH The flexible lookup combo that searches left, right, or any direction — and handles what VLOOKUP can’t.

Changing Images Using VLOOKUP Make a picture change automatically based on a cell value — a slick trick for dynamic dashboards and catalogs.

Changing Images Using Formulas Swap images on the fly with named ranges and formulas to build interactive, image-driven spreadsheets.

Excel — Formulas & Logic

Make your spreadsheet think for you.

Using IF Statements Make Excel decide for you — return different results based on the conditions you set, the foundation of smart sheets.

Using COUNTIF Count only the cells that meet your criteria — fast tallies and quick answers from messy data.

Conditional Formulas Combine IF, AND, and OR to handle real-world logic and multi-condition calculations.

Text Functions Clean, split, and combine text with LEFT, RIGHT, MID, and TRIM to tidy up any data.

Excel — Data Validation & Dropdowns

Keep data clean and consistent at entry.

Data Validation Stop bad data at entry — restrict cells to valid dates, numbers, or lists so your sheet stays clean.

Dropdowns Using Data Validation Build pick-from-a-list dropdowns so everyone enters data the same consistent way.

Picking From a Dropdown How to use and rely on dropdown lists for fast, error-free data entry.

Excel — Tables, Pivots & Data

Organize, summarize, and connect your data.

Working With Tables Turn a range into a real Excel Table — auto-expanding, easy to filter, and the base for clean formulas.

Pivot Tables Summarize thousands of rows into answers in seconds — group, total, and slice data without formulas.

Consolidating Data in Excel Combine data from multiple sheets or sources into one clean, reportable view.

External Data Sources Pull live data into Excel from files, databases, and the web — and refresh it with a click.

Excel — Charts & Dashboards

Turn rows of numbers into something leadership reads.

Create a Sales Column Bar Turn sales numbers into a clean column chart leadership will actually read.

Build a Sales Speedometer Create an eye-catching gauge chart to show progress against a goal at a glance.

Excel — Productivity & Tools

Work faster and audit with confidence.

Sheet Views Create your own filtered view of a shared sheet without disrupting everyone else’s.

Create a Workbook Navigation Button Add buttons that jump between sheets to make big workbooks easy to get around.

Create Form Controls Add checkboxes, sliders, and buttons to make spreadsheets interactive and easy to use.

Formula Auditing Trace precedents and dependents to see where a number comes from and squash formula errors.

Co-Managed IT (7-part series)

How an MSP works alongside your in-house IT team.

What Is a Co-Managed IT Service? How an MSP works alongside your in-house IT team — sharing the load instead of replacing them.

How Co-Managed IT Saves You Money Get enterprise-grade tools and coverage without hiring a full in-house IT department.

Co-Managed IT Helps Cover Extra Work Hand off overflow, projects, and after-hours support so your internal team isn’t buried.

Cybersecurity as a Co-Managed IT Service Layer in MFA, monitoring, and training to strengthen security alongside your team.

Improving Your IT Infrastructure Modernize and standardize your systems with an experienced partner guiding the roadmap.

How To Select the Right Co-Managed IT Partner What to look for — and the red flags to avoid — when choosing a co-managed IT provider.

Sample Co-Managed IT Responsibility Matrix A real example of who owns what, so nothing falls through the cracks between teams.

Quick Tips

Small habits that protect your business.

Wiggle the Mouse A quick trick to keep your screen awake during presentations — and why it’s not the real fix.

Ready for IT that just works?

Book a no-pressure discovery call. We'll review your setup and show you exactly where you stand.

Schedule a Discovery Call 281-367-8253