|
Office-365/Excel/Tutorials
Excel: Move cursor with arrow key
|
23.01.2018 144
|
In
Microsoft Excel, when you press the arrow keys, the sheet moves and the input
cursor does not jump from cell to cell,
then
this is due to the key: scrolls on the keyboard
On:
When the roll is on, the Excel sheet shifts
Off:
When scroll
|
|
Office-365/Excel/Tutorials
Excel: Copy cells without empty lines
|
08.01.2018 120
|
How to
copy a block in Microsoft MS Excel and pass only the cells with values without
empty lines and cells?
For
this you mark the area which you want to copy without empty cells
Then take Ribbonbar-> Start-> Filter
|
|
Office-365/Excel/Formulas
Excel: Text Like function
|
08.01.2018 125
|
Task: A
formula that allows you to check a text for the occurrence of a search text or
term
In vba
this is the formula LIKE
Solution:
Formula
= ISNUMBER (FIND
("balance"; B3))
In the
display in E
|
|
Office-365/Excel/Formulas
Excel: Determine a substring from text with Formulas
|
08.01.2018 117
|
Excel: Determine substring from text
If you
want to determine a certain text from a cell from long Excel lists, then you
use several formulas
The
best way to create the result of several steps
If you
want to calculate the number a
|
|
Office-365/Excel/Powerquery
Excel PowerQuery: Rename Columns
|
18.12.2017 156
|
How to rename columns in the MS Excel Powerquery
The Powerquery in Excel contains connections and data
copies of linked databases If you want to customize columns and fields of a
linked table in Excel,
then you can do this in Excel in the PowerQuery
|
|
Office-365/Excel
Dynamically evaluate Access with Excel
|
17.11.2017 179
|
This
article shows how to evaluate MS Access data dynamically in local MS Excel
files
Data
evaluations in MS Access can no longer be evaluated using an integrated Pivot,
PivotTable, PivotChart
The
evaluation via ActiveX charts is also no longer maintained
|
|
Office-365/Excel
Excel: Switching the data connection to another database
|
16.11.2017 219
|
This
example shows how to change the data connection to another database at runtime
in an Excel file
In
Microsoft Excel, data from Access databases can be attached using the Data
Connection Manager
If you set
up a data connection to an MS Access database her
|
|
Office-365/Excel/Code-vba-Makro
Excel, vba: insert image into a cell of cache
|
31.10.2017 221
|
Excel, vba: insert image into a cell of cache
This
command adds a bitmap image to a special cell in Microsoft Excel in Excel
Excel Sheet Paste Destination
'
|
|
Office-365/Excel
Excel Message: Parts of your document may contain personal information
|
30.10.2017 200
|
If I want
to save my Excel file, then always comes between this message:
Caution:
Parts of your document may contain personal information that can not be removed
from the document review
What does
it mean and how do I get it away again
|
|
Office-365/Excel/Formulas
Excel: Barcode by Excel Insert macro code into cells
|
20.10.2017 228
|
This
example contains an Excel file with a macro code, which can be used to
supplement any existing Excel document with an additional barcode of type 39
The
barcode is generated purely by a vba code in the background, whereby always a
small barcode is drawn into
|
|
Office-365/Excel/Formulas
Excel Macro Formulas for calculation
|
20.10.2017 207
|
Example how to calculate complex formulas in Microsoft
Excel
Tutorial
|
|
Office-365/Excel/Formulas
Excel: Enter values from your own function formula
|
20.10.2017 201
|
In MS Excel, you can write your own functions
and computations in the vba macro code, and output them in the Excel sheet by
means of a formula
|
|
Office-365/Excel/VSTO-Addin
Simple list of all Ribbonbar icons with OfficeIconID
|
14.03.2017 636
|
From Office 2016 FluentID wordcontrols xlsx
(search via CTRL + F)
_3DBevelOptionsDialog
_3DBevelPictureTopGallery
_3DDirectionGalleryClassic
_3DEffectColorPickerClassic
_3DEffectColorPickerMoreClassic
_3D
|
|
Office-365/Excel/VSTO-Addin
Office Icons: List of icons for the Ribbonbar
|
14.03.2017 507
|
List of all icons for the Ribbonbar
Office 2016 Fluent UI
Office 2016 Help Files: Office Fluent User Interface Control Identifiers
Office2016FluentUserInterfaceControlIdentifiers
Under
Download directory
When you d
|
|
Office-365/Excel/Templates
Excel: Converting XML to simple text pairs
|
13.03.2017 369
|
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
|
|
Office-365/Excel/Pivot
Excel Pivot: Marking areas and Activate Selection
|
03.03.2017 268
|
Excel Pivot: Marking areas and no more
To mark entire columns or fields in an Excel pivot, move the pointer over an Excel pivot element
This displays a small arrow
If you click on this, the complete Pivote element will be displayed
If this ma
|
|
Office-365/Excel/Formulas
Excel: Merge multiple cells multiline
|
06.02.2017 242
|
Excel: Merge multiple cells multiline
How can you summarize multiple cells in Microsoft Excel as a multi-line text in a formula cell?
I need a summarized in Excel, which summarizes the address data of people and separates the texts with a line break
Solution:
|
|
Office-365/Excel/VSTO-Addin
Excel Addin: create a Ribbonbar via VSTO Addin
|
25.01.2017 1014
|
Excel Addin: create a Ribbonbar via VSTO Addin
How to create a custom Ribbonbar in the menu under Microsoft MS Excel, which performs functions and tasks of Excel
Task: Create a Ribbonbar for Excel
Create project
A custom menu bar or
|
|
Office-365/Excel/VSTO-Addin
Note: Installing the English Office Developer Tools for Visual Studio VSTO
|
25.01.2017 951
|
Note, Log Delay: Installing the English Office Developer Tools for Visual Studio VSTO
Problem:
When you use the German Office Excel and Word 2010, 2013, 2016 applications and accesses through a Visual Studio Addin,
Created by the various CultureInfo states The Inte
|
|
Office-365/Excel/VSTO-Addin
Note: What is Interop and PIA in Microsoft Office
|
25.01.2017 1008
|
Note: What is Interop and PIA in Microsoft Office
Log Record Note: Which files contain the interface code from VSTO Apps to Office applications
The problem:
VSTO applications show the error: HRESULT 0x80028018 InteropServices COMException
Reason
|
|
Office-365/Excel/VSTO-Addin
Excel VSTO Addin: Error HRESULT 0x80028018 InteropServices.COMException: Old format or invalid type library
|
25.01.2017 670
|
Excel VSTO Addin: Error HRESULT 0x80028018 InteropServices COMException: Old format or invalid type library
Problem:
When reading values in MS Excel from a VSTO application, an error occurs: System Reflection TargetInvocationException with the detail message that an old form
|
|
Office-365/Excel/Chart
Excel: 2nd axis, secondary axis
|
21.11.2016 904
|
Excel: 2nd axis, secondary axis
If you want to display multiple lines at the same time on a diagram, with a line in a completely different number range,
It is recommended to activate the secondary axis on the right side of the table
This second Y-axis is only
|
|
Office-365/Excel/Pivot
Excel pivot: join multible tables
|
14.06.2016 1251
|
Excel pivot: join tables
How to create a PivotTable that is composed of several related individual data tables
As a video tutorial:
In this case two pivot tables is displayed
|
|
Office-365/Excel
Excel: Percentage Columns in pivot tables
|
13.06.2016 1256
|
Excel: Percent in pivot tables
If you working with pivot tables and draws a percentage column in the pivot analysis, you will see quickly,
that the values in the total or aggregate fields do not agree!
This is because that, pivot, and Excel, each cell is a pure
|
|
Office-365/Excel
Excel: create pivot table from data
|
13.06.2016 1376
|
Excel: create pivot table from data
How to create a pivot table from a pure datasheet in Excel?
#Excel 2013 2010
Step 1: Create pivot table
Select a cell in the data table
Then click Insert > PivotTable
|
|
Office-365/Excel
Excel: create formula for numbers with leading zeros
|
13.06.2016 1077
|
Excel: leading zeros create formula
Task: Create numbers with leading zero
I need in one Excel column values displayed with leading zeros
Formula:
= TEXT (A5;"0000")
|
|
Office-365/Excel
Excel Pivot: Data from Access with 14 Million Records
|
01.03.2016 1242
|
Pivot: 14 Million Records
This example shows an excel pivot, which is loaded by 14 million records from an access database
For the demo, the base table is quite simple
There is an ID, a long integer number and an string field
As you may see, the
|
|
Office-365/Excel
Excel Fehler: Sie haben versucht eine Datenbank zu öffnen die bereits von Benutzer geöffnet ist
|
05.02.2016 2535
|
Excel, Access
Fehlermeldung:
Microsoft Excel Sie haben versucht, eine Datenbank zu öffnen, die bereits von Benutzer Admin auf Computer Vaio_Raimund geöffnet ist
Versuchen Sie es erneut, wenn die Datenbank verfügbar ist
Betrifft : wenn man mit
|
|
Office-365/Excel/Code-vba-Makro
Excel: Formelfelder per Code kopieren
|
09.12.2015 1624
|
Excel: Formelfelder per Code kopieren
In der folgenden Excel-Datei sollen die Formeln der Zellen im Bereich D:E kopiert werden in die Felder darunter
Die Felder oder Spalten sind per Namensvariable in der grünen Zelle I7 festgelegt und änderbar
|
|
Office-365/Excel/Templates
Excel Word: mit Excel einen Serienbrief in Word erstellen per vba Code
|
09.12.2015 1844
|
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
|
|