Tutorials
Step-by-step guides to help you master Excel and XLNavigator.
36 articles
Browse by Topic
Navigation & Organization
15 postsMaster workbook navigation, sheet management, and file organization.
Formulas & Functions
9 postsLearn Excel formulas from basics to advanced techniques.
Data Import & Export
0 postsConnect Excel to databases, import data, and manage external connections.
VBA & Macros
1 postAutomate Excel with VBA code and macro recording.
Charts & Visualization
1 postCreate compelling charts, graphs, and visual reports.
Recent Articles
Excel for Small Business: Essential Spreadsheets Every Owner Needs
The core Excel spreadsheets every small business needs. Budget templates, cash flow tracking, customer lists, invoice registers, and simple financial statements you can build yourself.
Excel for Education: Gradebooks, Attendance, and Student Tracking
Build educational spreadsheets in Excel. Gradebook templates, attendance tracking, student progress monitoring, and classroom management tools for teachers and administrators.
Excel for Healthcare: Patient Tracking, Scheduling, and Compliance Reporting
Excel solutions for healthcare settings. Patient appointment scheduling, compliance tracking, staffing schedules, and medical practice management spreadsheets.
Excel for Real Estate: Property Analysis, Comparables, and Investment Calculations
Build real estate analysis tools in Excel. Property comparison spreadsheets, rental income projections, mortgage calculations, and investment ROI analysis for agents and investors.
Excel for Inventory Management: Stock Tracking and Reorder Systems
Build inventory tracking systems in Excel. Learn formulas for stock levels, reorder points, turnover calculations, and warehouse management without expensive software.
Excel for Project Management: Gantt Charts, Trackers, and Timelines
Build project management tools in Excel. Create Gantt charts, milestone trackers, resource allocation views, and project dashboards without specialized PM software.
Excel for Marketing: Campaign Tracking, Budgets, and Analytics
Track marketing campaigns, measure ROI, and manage budgets in Excel. Practical templates and formulas for marketing teams who need flexible reporting beyond their tools.
Excel for Sales: Pipeline Tracking, Forecasting, and Reporting
Build sales dashboards and pipeline trackers in Excel. Learn formulas for forecasting, commission calculations, and performance reporting that sales teams actually use.
Excel for HR: Employee Data, Tracking, and Reporting
Build effective HR spreadsheets for employee tracking, attendance, performance reviews, and compliance reporting. Practical templates and formulas for HR professionals.
Excel for Accounting: Essential Skills and Templates
Master the Excel skills every accountant needs. From reconciliations to financial statements, learn the formulas, techniques, and best practices for accounting workflows.
Excel Macros for Beginners: Automate Repetitive Tasks
Macros record your actions and replay them. Here's how to start automating without writing code.
Excel What-If Analysis: Goal Seek, Scenarios, and Data Tables
Excel's What-If tools help you explore possibilities without manually changing values. Here's how to use them.
Showing 12 of 36 articles. Browse subcategories above for more.