10.30 Archives - How Engineering Works

10.30

1. How can formulas be used to calculate progress or completion percentages?
2. What are basic formulas you can use in Notion (e.g., addition, subtraction)?
3. How do formulas work in Notion databases?
4. How can you sort a database by date, name, or number?
5. How can multiple filters be combined using AND/OR logic?
6. How do you apply filters to show only certain entries?
7. How can filtered views improve productivity in a database?
8. How do you create a linked database on another page?
9. What is the difference between a linked database and a full database?
10. Give an example of using a rollup to calculate total tasks completed.
11. How can rollup properties summarize information from related databases?
12. How do relations connect two different databases?
13. What is a relation property in Notion databases?
14. How can you use text, number, and date properties effectively?
15. What types of properties exist in Notion databases?
16. How do you add a new property to a database?
17. What are properties in a Notion database, and why are they important?
18. How do you create a new database in Notion?
19. What are the main types of Notion databases (table, board, list, calendar, gallery)?
20. What is a database in Notion, and how is it different from a regular page?
21. How can databases be linked to create a project tracker?
22. How do you customize task or project templates for repeated use?
23. How can templates improve productivity systems in Notion?
24. How do you create recurring tasks or reminders in a content calendar?
25. How can you track publishing dates and status of content?
26. How can a content calendar be set up in Notion?
27. How can you visualize habits using progress bars or checkboxes?
28. How do you track daily, weekly, or monthly habits in Notion?
29. How can habit trackers be created in Notion?
30. What is the purpose of a weekly review for productivity?
31. How do you create a weekly review system in Notion?
32. How can Kanban/board views help visualize task progress?
33. How can tasks be filtered by priority or status?
34. How can due dates and reminders be set for tasks in Notion?
35. How can you organize tasks by projects in Notion?
36. What is GTD (Getting Things Done), and how can it be implemented in Notion?
37. How can task managers be built using Notion databases?
38. What elements should be included in a productivity dashboard?
39. How do you create a personal dashboard in Notion?
40. What is a personal dashboard in Notion, and why is it useful?
41. How do sorts work in Notion to organize data?
42. How do filters work in Notion views?
43. How can a calendar view be used to track tasks or events?
44. What is the difference between a table view and a board view?
45. How do you create different views (table, board, calendar) in Notion?
46. How can you use multi-select or tags as properties?
47. What types of properties exist in Notion (e.g., text, number, date)?
48. How do you add a property to a database?
49. What are properties in a Notion database?
50. How can you create a custom template in Notion?
51. How do you use a pre-built template in Notion?
52. What are templates in Notion, and how can they save time?
53. How can you format text using blocks in Notion?
54. What types of blocks are available in Notion?
55. How do you add, move, or delete blocks in a page?
56. What are blocks in Notion, and why are they important?
57. How do you create a new database in Notion?
58. How do you create a new page in Notion?
59. What is the difference between a page and a database in Notion?
60. What is Notion and what are its primary uses?
61. What is the use of color codes in an attendance tracker?
62. How can formulas calculate total days present and absent automatically?
63. How do you mark present, absent, and leave status in an attendance tracker?
64. How can an attendance tracker be created in Excel?
65. How can conditional formatting highlight overdue invoices?
66. How can formulas calculate outstanding payments in an invoice tracker?
67. What are key fields in an invoice tracker template?
68. How can pivot tables be used to summarize sales data in a tracker?
69. How do you calculate total sales per month using formulas in a sales tracker?
70. How can an Excel sales tracker help businesses monitor performance?
71. How can charts be added to an expense tracker for visualization?
72. How do you calculate total expenses automatically in a tracker?
73. How can categories be added to an expense tracker for better organization?
74. What are the advantages of using an expense tracker template?
75. How can conditional formatting help highlight overspending in a budget tracker?
76. How can formulas like SUM and AVERAGE be used in a budget template?
77. How do you track monthly income and expenses using an Excel budget template?
78. What are the key elements of a budget template?
79. How can Excel templates save time in everyday tasks?
80. What is an Excel template and how is it different from a regular workbook?
81. How do you handle duplicate entries or incorrect data in a pivot table?
82. How can you display data as percentages of row, column, or grand total?
83. How do you hide or show subtotals and grand totals in pivot tables?
84. How can you prevent pivot tables from showing blank or zero values?
85. What is the difference between refreshing a single pivot table and all pivot tables in a workbook?
86. How can you refresh a pivot table after updating source data?
87. How do timelines work in pivot tables?
88. What are slicers, and how do they improve pivot table interactivity?
89. How can you filter pivot table data using labels or values?
90. How can you sort data within a pivot table?
91. How can calculated items differ from calculated fields?
92. How do you create a calculated field in a pivot table?
93. What is a calculated field in a pivot table?
94. How do you group dates in a pivot table (by month, quarter, year)?
95. How do you group numeric data in a pivot table?
96. How can you change the summary function (SUM, COUNT, AVERAGE) in a pivot table?
97. How do you add fields to the Rows, Columns, Values, and Filters areas?
98. What is the difference between a pivot table and a regular table?
99. How do you create a pivot table from a dataset?
100. What is a pivot table in Excel, and why is it used?

1 2 Next