Table Memo vs Master VLOOKUP and Spreadsheet

Table Memo is simple memo app of spreadsheet form. Each memo has a header of several columns, and has rows of memo. You can add/delete columns, edit each item name, add/delete/copy/move rows of memo. Created/edited memo can be sent by mail as CSV (with values encapsulated in double quotes) formatted data (UTF-8 encoding). You can also use Table Memo app as simple CSV (with values encapsulated in double quotes) viewer(use iOS mail app). How to use: 1. Create Memo At memo list view (first view of this app), tap add('+') button, and input the memo title. By tapping Edit button, you can edit memo name, delete memo, and reorder list. 2. Edit Memo data Select the created memo, and open memo table view. Tap each cell you want edit, and edit the data. If color mode is on, text and cell color also can be changed. To add new row, tap add('+') button. To copy or delete row, tap the row number of left side and select operation. By double tapping a cell, the entire contents of the cell is displayed, so you can check and copy the contents. At the bottom of memo table view, there are four buttons, 1) trash button, 2) action button, 3) table settings button, 4) reorder button, from left to right. 1) trash button You can delete current opened memo. 2) action button Current opened memo can be duplicated, or can be sent by mail as CSV formatted data. 3) table setting button Table settings view will open (see below). 4) reorder button By tapping this button (the reorder button changes to the edit button), memo table becomes the reorder mode, and you can reorder rows by dragging each row. To back to edit mode, tap the edit button. 3. Table Settings 1) Use Color switch If set ON, text and cell color becomes changeable. [[CAUTION]] If set OFF after using color, all color data will clear. 2) MEMO TITLE section Select memo title and edit the title. 3) Left Inset setting You can adjust the space on the left side of the cell. 4) Font Size setting You can change the font size of the table. 5) Columns section To add new column, tap add('+') button. To delete column or reorder columns, tap Edit button. By selecting each ITEM of columns, column edit view will open (see below). 4. Column edit 1) ITEM name section You can edit item name. 2) Column width section You can change column width by slider. By tapping the adjust button, the column width will be set to the width of existing data. *You can also open this view by long press of header item at memo table view. 5. Settings Tapping settings button at memo list view, SETTINGS view will open. You can change settings below: 1) THEME of this app 2) settings of CSV export/import - encoding of CSV data - export header - import 1st row as header 3) default column name and default number of columns.

-Make Learning Spreadsheet Functions Easy with App This app is designed to support beginners and new professionals in mastering functions in spreadsheet software like Excel. While it focuses on mastering the VLOOKUP function, it also supports SUM, HLOOKUP, INDEX, and MATCH functions. -Purpose of the App This app is designed to help users learn spreadsheet functions efficiently with an easy-to-understand button layout. Instead of typing each character using a keyboard, users can create functions by combining blocks of formulas through button taps, making it simple for anyone to create functions. -Features of the App Ease of Use: Users can create functions by simply pressing buttons within the app. Instead of using a keyboard, functions are broken down into blocks that can be entered with buttons, making it easy for beginners to know where to start. Practical Learning: Users can practice functions with sample data, allowing them to experience functions immediately after downloading the app on their smartphones. Supported Functions: The app currently supports VLOOKUP, SUM, HLOOKUP, INDEX, and MATCH functions, covering the essential functions needed by beginners in spreadsheet software. This ensures that users can handle everything from basic data operations to advanced analysis. Efficient Learning: The app provides clear explanations of how to use VLOOKUP, enabling beginners to grasp the basics of functions quickly. By actually using the functions, users can learn effectively while experiencing their benefits. -Use Cases for the App New Professionals: Efficiently learn spreadsheet functions, a vital skill in the business world. PC Beginners: With an easy-to-understand interface and operation method, even those new to spreadsheet functions can learn without stress. Skill Enhancement: Easily review the basic operations of functions on your smartphone. With this app, learning spreadsheet and Excel functions is simple and enjoyable. Download now and elevate your business skills to the next level!