okokok/home/dulichv1/informaticshandbook.comokokok Manual Document | Informatics Handbook

Category Archives: Manual document

Alternative to Merged Cells (Quick Tip)

Typically, many users are drawn to the Merged Cells feature in Excel, despite it having some significant disadvantages (especially related to copy/paste of ranges). Frequently, Merged Cells are used in areas to group cells together visually, which can be done differently without causing the issues that merging does. You can use an option within formatting […]

Quick Excel Tip – Grouping Rows / Columns

As I mentioned in reply to haeso’s comment on the first video, there is method of joining rows or columns together called ‘grouping’.  It can be very useful when you want to have different ways of displaying data, or be able to collapse certain areas (underlying details, for example). Here’s a screenshot explaining how you […]

Guest Excel Lesson: Introduction to Tables

User VertexVortex has been helping users out on r/Excel for quite a while.  After reaching out to him on Reddit, he agreed to help out by creating a lesson of his own specifically for this site.  Here’s his guest lesson on Structured Tables.  Hope you find it useful!! The following is original content provided to Excel Exposure by VertexVortex: […]

Introduction to Power Pivot

Introduction to Power Pivot Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!! Power Pivot is an Excel add-in which can used to perform powerful data analysis and create sophisticated data models. It can handle large volumes of data (millions […]

VBA Walkthrough #2: Message Encoder & Decoder

This VBA macro is hopefully a bit more interesting than the last, and shows how I created a message encryptor/decryptor in Excel using VBA/macros. The lesson covers these specific areas of VBA usage: – For…Next loop (including nested loops) – If…ElseIf…Then Statement – Excel functions: CHAR() / LEN() / VLOOKUP() – VBA functions: Mod / […]