Username:  
Password:  

Special Topic:

Interesting Tips and Tricks relevant to important Program Functions and useful for daily tasks, are delivered to you every 14 days with our Newsletter.

Our current Special Topic:

Selecting cell content with Excel

If you want to customize various things after creating an Excel spreadsheet, such as the font size of the text or the alignment of numbers, the corresponding cells must be marked in advance. Depending on the size and complexity of the table, this could take a long time. However, using the go-to function in Excel makes it much easier to mark. In this Special Topic we show you how to work with this function.

Published on: 25.07.2017
To acces the videos for this Special Topic you must have subscribed to Excel !


Excel 2016

Selecting Cell Content:  
This video will show you how to select cells with specific content such as text or formulas by using the go-to function. (3 Min.)



Excel 2013

Selecting Cell Content:  
This video will show you how to select cells with specific content such as text or formulas by using the go-to function. (3 Min.)

back to top


Excel 2010

Selecting Cell Content:  
This video will show you how to select cells with specific content such as text or formulas by using the go-to function. (3 Min.)

back to top


Excel 2007

Selecting Cell Content:  
This video will show you how to select cells with specific content such as text or formulas by using the go-to function. (3 Min.)

nach oben


Special Topics Archive:

Have you missed a Special Topic? Never mind, here you will find a complete list of all the Topics published to-date. Klick here on the required title to call-up the Special Topic.

11.07.2017: Plan websites with Visio

27.06.2017: Translate texts with Word

30.05.2017: Assigning and Accepting Tasks with Outlook

16.05.2017: Use jump lists in Windows

02.05.2017: Record screen content with PowerPoint

18.04.2017: Printing in Excel

04.04.2017: Find available times for meetings with Lotus Notes

21.03.2017: Use Watermarks in Word

07.03.2017: Send Cloud documents as an attachment in Outlook

07.02.2017: Novelties Visio 2016

back to top
24.01.2017: New features Project 2016

10.01.2017: New features Access 2016

13.12.2016: Use spelling check in Word

29.11.2016: Creating and Adjusting Organization Charts in PowerPoint

15.11.2016: Calculating across various files

01.11.2016: Adjusting the Reading Pane in Outlook

18.10.2016: Working with columns in Word

04.10.2016: Creating Hyperlinks on PowerPoint slides

20.09.2016: Working with Workspaces in Excel

06.09.2016: Message Options in Outlook

back to top
23.08.2016: Creating a Table of Figures in Word

09.08.2016: Match the tab order in Microsoft Access

26.07.2016: Aligning objects in PowerPoint

12.07.2016: Visualizing Trends in Excel Workbooks

28.06.2016: Creating Signatures in Outlook

14.06.2016: Using non-breaking space and hyphens in Word

31.05.2016: Creating Queries in Access

17.05.2016: Using the AutoFill feature in Excel

03.05.2016: Novelties PowerPoint 2016

19.04.2016: Novelties Outlook 2016

back to top
05.04.2016: Protecting Word Documents

08.03.2016: Create Shortcuts in Outlook

23.02.2016: Novelties in Word 2016

09.02.2016: Using several slide masters in PowerPoint

26.01.2016: Novelties in Excel 2016

12.01.2016: Using tabstops with leaders

15.12.2015: The Out of Office Assistant in Outlook

01.12.2015: Calculating roots and exponents in Excel

17.11.2015: Nominating a replacement

03.11.2015: Tracking Changes in Word

back to top
20.10.2015: Headers and Footers in Power Point

06.10.2015: Precision and displaying figures in Access

22.09.2015: Conditional Formatting in Excel

25.08.2015: Working with Tables of Contents in Word

11.08.2015: PowerPoint slides display and hide

28.07.2015: Relative and Absolute Addressing in Excel

30.06.2015: Using Favorite Links in Windows

02.06.2015: Mail Merge in Word

19.05.2015: Aggregate functions in Access

05.05.2015: Forward multiple emails simultaneously

back to top
21.04.2015: Open files in Windows 8

07.04.2015: Using Comments in Excel

24.03.2015: Use Hyperlinks in Word documents

10.03.2015: Record notes on Handouts in PowerPoint

24.02.2015: Validity Check in Access

10.02.2015: Record Birthdays with Outlook

27.01.2015: Efficient Calculation with the Matrix Operation in Excel

13.01.2015: Working with Sections in Word

16.12.2014: Organizing the Start Screen of Windows 8

02.12.2014: Create reports in Access

back to top
18.11.2014: Pausing PowerPoint presentations

04.11.2014: Create contact groups in Outlook

21.10.2014: The expression builder in Access

07.10.2014: Grouping worksheets in Excel

23.09.2014: Setting and adjusting the line spacing in Word documents

09.09.2014: PC Security - Secure behavior in the Internet

26.08.2014: Connect objects in PowerPoint

12.08.2014: PC Security - MBSA Security Check

29.07.2014: Manage your appointments in Outlook

15.07.2014: PC Security - Correct computer protection

back to top
01.07.2014: Find and replace values in Excel

17.06.2014: PC Security - Dangers in the Internet

03.06.2014: Use Bookmarks in Word

20.05.2014: Find duplicates in Access databases

06.05.2014: Create PowerPoint Presentations successfully

22.04.2014: Using categories in Outlook

08.04.2014: Using the command VLOOKUP in Excel

25.03.2014: Working with Tabs in Word

11.03.2014: Clearing Resource Conflicts in MS Project

25.02.2014: Create tasks in Outlook

back to top
11.02.2014: Show Object Dependencies in Access

28.01.2014: Create animations in Power Point

14.01.2014: Select elements in Windows more efficiently

10.12.2013: Working with the Subtotal function in Excel

26.11.2013: Find elements quickly - The Search Function in Word

12.11.2013: Creating Email Templates in Outlook

15.10.2013: Grouping objects in PowerPoint

01.10.2013: Easy navigation with Hyperlinks in Excel

17.09.2013: Working with headers and footers in Word

03.09.2013: Customizing the Startmenu in Windows

back to top
20.08.2013: PivotCharts in Access

06.08.2013: Creating and adjusting views in Outlook

23.07.2013: Avoid incorrect entries Validating data in Excel

09.07.2013: Using Slide Masters in PowerPoint

25.06.2013: Creating a calendar with Visio

11.06.2013: Planning meetings in Outlook

28.05.2013: Field Functions in Word

14.05.2013: Calculating the resource Material in Project

30.04.2013: Filter and Sort Data in Excel

16.04.2013: Create custom shapes in PowerPoint

back to top
19.03.2013: Customize Outlook by using the Outlook options

05.03.2013: Working with Team Rooms in Lotus Notes

19.02.2013: Creating Folding and Hole Punch Lines in Word

05.02.2013: Detect, delete and hide duplicates in Access

22.01.2013: Create and use range names in Excel

08.01.2013: Test the timing of your PowerPoint presentation in advance

11.12.2012: Conditional formatting in Outlook

27.11.2012: Protect your documents with passwords

13.11.2012: Customize your Windows user interface

30.10.2012: Create and Compare Scenarios in Excel

back to top
16.10.2012: Planning meetings in Lotus Notes

02.10.2012: Creating Network Diagrams in Visio

18.09.2012: Creating and Adjusting Organization Charts in PowerPoint

04.09.2012: Your virtual mail manager - Using Rules in Outlook

21.08.2012: Grouping and Sorting Reports in Access

07.08.2012: Creating visual reports in Project

24.07.2012: Working with large tables

10.07.2012: Libraries in Windows 7

26.06.2012: Creating Custom Shows in PowerPoint

12.06.2012: Using well-known commands in Outlook 2010

back to top
29.05.2012: Working with Text Boxes in Word

15.05.2012: Pivot charts in Visio

02.05.2012: Novelties in Access 2010

17.04.2012: Working with Sparklines in Excel

03.04.2012: Novelties in Outlook 2010

20.03.2012: Create a Baseline in MS Project

06.03.2012: Novelties in Word 2010

21.02.2012: Creating Screenshots with the Snipping Tool

07.02.2012: Novelties in PowerPoint 2010

24.01.2012: Your virtual mail manager - Using Rules in Lotus Notes

back to top
10.01.2012: Using Contact Groups in Outlook

13.12.2011: Converting rows into columns in Excel

29.11.2011: Comparing documents in Word

15.11.2011: Aligning objects in PowerPoint

01.11.2011: Arranging pictures in Text

18.10.2011: Conditional formatting in Access

04.10.2011: Delegating Tasks in Lotus Notes

20.09.2011: Using the Office-Clipboard

06.09.2011: Rounding numbers with Excel

23.08.2011: Creating Flowcharts in Visio

back to top
09.08.2011: Create appealing forms in PowerPoint

26.07.2011: Open files with a specific program

28.06.2011: Removing duplicates in Excel

14.06.2011: Pausing slide shows

31.05.2011: Match the tab order in Microsoft Access

17.05.2011: Clever use of the Autocorrect-Function

03.05.2011: Show calendar weeks and integrate holidays in Outlook

19.04.2011: Using line breaks in Excel

05.04.2011: Novelties Visio 2010

22.03.2011: Safe surfing

back to top
08.03.2011: Project 2010 Novelties

22.02.2011: Show hidden files in Windows

08.02.2011: Using non-breaking space and hyphens

25.01.2011: How to prepare a successful presentation

11.01.2011: Using Autoforms in Access

14.12.2010: Adjusting the Reading Pane in Outlook

30.11.2010: Saving a PowerPoint Presentation on a CD

16.11.2010: Find and replace words in Word

02.11.2010: Calculating across various files

19.10.2010: Create and print labels in Word

back to top
05.10.2010: Using favorites in Windows

21.09.2010: Creating queries with calculated fields in Access

07.09.2010: Sensitive Data in Word Documents

24.08.2010: Inserting Hyperlinks in PowerPoint Presentations

10.08.2010: Using Workspaces in Excel

27.07.2010: Create a Photo Album in PowerPoint

12.07.2010: Create a Calendar in Word

 

 

Go to Special Topics Archive..

    Feedback/Suggestions