Help & training
User guide, function descriptions, training programme and quick-reference card for working with MacroLens. Search by keyword or pick a topic.
Start here
Start here
Getting started
Signing in, two-factor authentication, language, navigation and installing MacroLens as an app on a Windows 11 PC.
Training · 60 min
Training programme (60 min)
A 60-minute training programme with practical exercises — from signing in to analysis, statistics, a report and Excel.
Function descriptions
Function reference
Every operation and formula-language function with parameters and examples.
Printable card
MacroLens quick-reference card
One-page reference card — search, common operations, formulas, statistics, export and support. Print-ready.
Getting started
- Getting started Signing in, two-factor authentication, language, navigation and installing MacroLens as an app on a Windows 11 PC.
- Searching and filtering How to find time series by keywords and phrases and how to filter by region, source, frequency and category.
- Browsing Browsing the database by category, source, dataset and region.
- Series page and update information The series page — chart, table, metadata, publication (update) information, revisions and downloads.
Working with data
- Analyses The analysis workspace — series list, adding series, operations, formulas, value edits, common frequency and saving.
- Charts Chart types (line, column, bar, scatter), changing the displayed period and appearance, export and printing.
- Tables The table view — displayed period, series order, layout, number of decimals, copying, downloading and printing.
- Saving and library Saved analyses, charts, tables, reports, presentations and user series; folders, sharing and copies.
- Reports and presentations Building reports and presentations from your charts, tables and statistical results, exporting to DOCX, PPTX, XLSX and PDF, present mode.
Calculations & analysis
- Operations on time series All time-series operations (TS 2.11) with examples — frequency conversion, weighted average, lags, changes, indices, trend, cycle, seasonal adjustment, smoothing and more.
- Formula language Formula-language syntax — operators, functions, S() and U(), examples and error messages.
- Function reference Every operation and formula-language function with parameters and examples.
- Statistical analysis Correlation analysis, standard deviation, simple and multiple regression, VAR, PCA, unit root tests and period comparison — how to run them and how to read the results.
Excel
- Excel add-in and Power Query The MacroLens Excel add-in (search, insert, refresh) and Power Query — installation for users and IT administrators, sign-in with your MacroLens account (two-factor code) and Power Query Basic authentication.
Data
- Data sources and update policy The nine official data sources, their dissemination channels and terms of use, the update policy (within 24 hours) and regional coverage.
Reference
- Keyboard shortcuts Keyboard shortcuts and working without a mouse.
- Frequently asked questions Answers to frequently asked questions about signing in, data, analyses, exports and Excel.
- Glossary Glossary of English and Lithuanian terms.
- MacroLens quick-reference card One-page reference card — search, common operations, formulas, statistics, export and support. Print-ready.
Training & support
- Training programme (60 min) A 60-minute training programme with practical exercises — from signing in to analysis, statistics, a report and Excel.
- Support and service levels How to report a problem or ask a question, what happens after a report and the deadlines for fixing disruptions.
Need help?
Found an error, have a question or need additional data? Tell the support team — every report is registered and you can follow its status.