Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#
Excel: Calculate total statistical frequency number of texts Office-365/Excel/Templates/Calculations
Excel: Calculate total statistical frequency number of texts
07.01.2020 101
How can I determine the total number as the frequency of a value in Excel? How often does a value occur? Exceltrick: with the Shift+Ctrl+Enter key, a matrix function is entered in the formula entry as curly braces

Excel Formula: Calculation Performance of a Resistance at a Voltage Office-365/Excel/Templates/Calculations
Excel Formula: Calculation Performance of a Resistance at a Voltage
06.01.2020 98
Electric formulas Excel file as a download as a file Green fields are input fields

Excel: Timesheet Calendar as Download Template Office-365/Excel/Templates/TimeSheet
Excel: Timesheet Calendar as Download Template
11.12.2019 117
Excel: Timesheet Calendar Write Calendar write-off template in projects As an Excel template If you have any questions or suggestions about vba: raimund popp@comline-se de The file is a simple template on how to perform the month

Excel : Encoding values with HASH functions SHA256 Office-365/Excel/Templates
Excel : Encoding values with HASH functions SHA256
04.12.2019 403
Applies to Microsoft Excel, Access Word Outlook PowerPoint, Secure Encryption The following file encodes text with the SHA256 hash into encrypted values To do this, the appended code is inserted into vba macro You can use the Excel function to =get

Excel : Anonymizing and pseudonymizing numbers Office-365/Excel/Templates
Excel : Anonymizing and pseudonymizing numbers
04.12.2019 111
With a simple vba function Download with Excel File as an example The following Excel file anonymizes data based on a unique random number Anonymization: Anonymization changes sensitive critical data to another non-easily derived new replacemen

Series email with optional file attachment Office-365/Excel/Templates/Emails
Series email with optional file attachment
27.01.2019 1789
corrected file version: 20190515 with optional attachements Series email with optional file attachment

E-mails automatically with Excel vSend based on a data list Office-365/Excel/Templates/Emails
E-mails automatically with Excel vSend based on a data list
26.01.2019 2001
E-mails automatically with Excel vSend based on a data list The following email file sends emails to a data list, which they simply have to insert into the prepared data sheet as values The email text is a template in the sheet: _ Text and here columns can be personal

Excel template: Calculation of all-inclusive hourly rates for freelancers. Office-365/Excel/Templates/Calculations
Excel template: Calculation of all-inclusive hourly rates for freelancers.
17.10.2018 548
Excel template: Calculation of all-inclusive hourly rates for freelancers For freelancers, the question is always: what is the all-inclusive hourly rate in city x or y? You just have to know how high the home office hourly rate is With a HomeOffice remote hourly

Calculation Hourly Rates Externally to HomeOffice Office-365/Excel/Templates/Calculations
Calculation Hourly Rates Externally to HomeOffice
17.10.2018 514
Calculation Hourly Rates Externally to HomeOffice Task: How much does the all-in hourly rate at the customer site and this the hourly rate to the home office Solution: Calculate the cost of vehi

Send serial emails with Excel #39 Office-365/Excel/Templates/Emails
Send serial emails with Excel #39
09.10.2018 6124
new file-version 20190515 with optimized optional attachement Send serial emails with Excel Description: With the following Excel file you can send emails as serial emails The file is for small circulars or manageable quantities up to 1000 emails per

Automatically create form letters from Excel with filter Office-365/Excel/Templates/Mail-Merge
Automatically create form letters from Excel with filter
02.10.2018 1182
Automatically create form letters from Excel with filter This example shows how to create form letters in Word with little effort from Excel The raw address data are stored in Excel The data is filtered via a small Pivot and key then the filtered form letters are created

Send emails from Excel with Outlook Office-365/Excel/Templates/Emails
Send emails from Excel with Outlook
14.03.2018 9526
This application shows how to send emails via Outlook automatically with Excel Example: The Excel file has a list of emails where you can set an X to the email addresses to which an automated email is to be sent out of Excel The sent emails are

Excel: Converting XML to simple text pairs Office-365/Excel/Templates
Excel: Converting XML to simple text pairs
13.03.2017 1720
Excel: Converting XML to simple text pairs Task: Convert structured XML lines to simple text with value pairs In XML, you often find a collection of values ​​on the smallest node level However, nesting with XML is difficult to read

Excel Word: mit Excel einen Serienbrief in Word erstellen per vba Code Office-365/Excel/Templates
Excel Word: mit Excel einen Serienbrief in Word erstellen per vba Code
09.12.2015 2903
Excel Word: mit Excel einen Serienbrief in Word erstellen per vba Code Aufgabe: in Excel soll per Taste automatisch ein Serienbrief mit den vorhandenen Adressen erstellt werden Es liegt ein Word-Dokument im gleichen Verzeichnis wie die Excel-Datei

Excel Vorlage: Link-Sammlung vom Browser in Excel Liste Tabelle umwandeln 02 Office-365/Excel/Templates
Excel Vorlage: Link-Sammlung vom Browser in Excel Liste Tabelle umwandeln 02
27.11.2015 3108
Excel Vorlage: Link-Sammlung vom Browser in Excel Liste Tabelle umwandeln Die Excel Vorlage wandelt Links, die Sie unter dem Google Chrome Browser zusammengestellt und kopiert haben, in eine komfortable Excel Liste oder formatierte Tabelle um Die Tabelle können Sie in jedem

Excel Vorlage: Liste mit Links aus Chrome umwandeln in Excel-Liste mit aktiven Links Office-365/Excel/Templates
Excel Vorlage: Liste mit Links aus Chrome umwandeln in Excel-Liste mit aktiven Links
26.11.2015 2960
Excel: Liste mit Chrome Links-URL Adressen umwandeln Excel-Liste mit aktiven Links In diesem Beitrag zeige ich, wie man eine Liste an Webseiten Links, die man unter Google Chrome zusammengestellt hat, in Excel importiert und dann in eine formatierte Liste oder Tabelle umwandelt, die man

Umwandeln aller Verweise auf eine externe Arbeitsmappe durch lokale Werte Office-365/Excel/Templates
Umwandeln aller Verweise auf eine externe Arbeitsmappe durch lokale Werte
29.04.2015 2642
Wenn man in Excel Daten aus einem anderen Excel Dokument verknüpft, dann hat man oft ungewollt Verbindungen zu Daten auf externen Verweisen, die man doch nur als Werte haben wollte Zudem kommt beim Öffnen der Excel Datei meist die Meldung, ob man die externen Daten aktualisieren m&

Stundenplan als Excel Vorlage Office-365/Excel/Templates
Stundenplan als Excel Vorlage
25.02.2015 4334
Stundenplan als Excel Vorlage Hier muß man nur die Stunden eintragen Die Farben habe ich über bedingte Formatierung automatisch eingebaut Im Download rechts ist eine Stundenplan Vorlage für das Gymnasium Am Beispiel des MPG Max Planck Gymnasium

Mobile

.

Contact for Jobs, Project Requests: raimund.popp@microsoft-programmierer.de