Microsoft Access Data Types Explained
Every Microsoft Access data type explained with examples: Short Text, Long Text, Number, Date/Time, Currency, AutoNumber, Yes/No, Hyperlink, Attachment, Lookup and Calculated.
How to Import Excel Data into Microsoft Access
Import data from an Excel worksheet into a Microsoft Access table: use column headings, set data types, skip columns, choose a primary key and sort the result.
Create an Excel Sales Dashboard With Claude (One Prompt)
With one detailed prompt, Claude can build a complete sales dashboard inside Excel: a helper column, five PivotTables, five formatted charts and a slicer, laid out on one screen. Here is the exact prompt I used, the sample data to try it on, and why the prompt is written the way it is. ToolClaude in … Read more
Excel Template With Alerts for Expiry and Renewal Dates
This Excel template works out when each policy, subscription or document expires, counts the days left and flags anything Expired or Expiring Soon in colour. Because it uses TODAY, the alerts update every time you open the file. FunctionsEDATE, TODAY and IF AlertsConditional formatting: red for expired, yellow for due within 7 days Works inExcel … Read more
How to Create a PowerPoint Presentation With ChatGPT
ChatGPT can write the VBA code that builds a presentation for you. Paste the code into PowerPoint, run it, and the slides appear in seconds. Designer then adds the layouts. You needChatGPT and PowerPoint for Windows MethodVBA macro written by ChatGPT DesignerMicrosoft 365 only Video Step 1: Ask ChatGPT for the code Open ChatGPT and … Read more
How to Create a Data Entry Form in Microsoft Access
Create a data entry form in Microsoft Access step by step: design the table, choose data types, add a drop-down list, build the form with the Form Wizard and add New, Save and Delete buttons.
How to Create an Automated Data Entry Form in Excel
This Excel form collects new employee details on one sheet and, when you click Submit, saves them as a new row on a database sheet and clears the form. The Submit button runs a macro you record, so there’s no code to write. Built withData Validation, option buttons, IF and a recorded macro Saved asExcel … Read more
How to Create a Simple Dashboard Report in Excel
A one-page sales dashboard in Excel needs only three things: PivotTables to summarise the data, PivotCharts to show it, and a slicer connected to every chart, so one click on a month updates the whole page. Built withPivotTables, PivotCharts and a slicer ChartsLine, column, bar and pie Works inExcel 2013 and later, Microsoft 365 TimeAbout … Read more
How to Send WhatsApp Messages From Excel
Excel can write a personalised WhatsApp message for everyone on a list and turn it into a link. Click the link and WhatsApp opens with the number and message filled in, ready to send, even if the number isn’t saved in your phone. Functions& (join text), TEXT and HYPERLINK OpensWhatsApp Web in your default browser … Read more
How to Track Income and Expenses in Excel (Monthly Template)
A simple Excel sheet can track your income, expenses and savings month by month. You type the figures; SUM totals each section and one subtraction gives your savings, all updating as you go. FunctionsSUM and a subtraction LayoutMonths across, income and expense items down Works inAny version of Excel, and Google Sheets Video Step 1: … Read more