top of page
Search
MS Excel: Unlocking General and Formula Options Boost Performance, Ensure Data Integrity, and Streamline Your Workflow
Excel’s Options dialog is where you stop fighting your workbook and start shaping Excel to suit the way you work. Two tabs you’ll open many times as a power user or teacher are General (personalisation and defaults) and Formulas (how Excel calculates). Below you’ll find an easy-to-follow walkthrough, practical examples, step-by-step how-tos, VBA snippets you can drop into a
Fakhriddinbek
Oct 410 min read
Power Query: Creating Custom Columns a Comprehensive Guide in Add Column's General Section
Power Query is famous for its pre-built transformations, but its true power is unlocked when you start creating your own custom columns. While the Add Column tab offers a wide array of options for adding columns based on text, numbers, or dates, the General section is where you take control. It allows you to build columns with your own custom logic, providing a level of flexibility that is essential for complex data cleaning and analysis.
Fakhriddinbek
Sep 13 min read
bottom of page