Word and Excel practice files – sample files2023-07-09T08:28:44+02:00

Word and Excel practice files – Sample files

On this page we have provided some practice and example files to help you improve your understanding of specific procedures for different use cases in Excel. These files are of course free.

Word and Excel practice files – Sample files

On this page we have provided some practice and example files to help you improve your understanding of specific procedures for different use cases in Excel. These files are of course free.

Custom formatting

Date, times, working days

Goal Seek, Scenario Manager

Basic arithmetic, partial result

Index function

Vlookup, Wlookup

Nested Functions

IF THEN, IF AND, IF OR…

Types of Cell Reference

Conditional formatting

Custom formatting

Date, times, working days

Goal Seek, Scenario Manager

Basic arithmetic, partial result

Index function

Vlookup, Wlookup

Nested Functions

IF THEN, IF AND, IF OR…

Types of Cell Reference

Conditional formatting

Search for:

Search for:

Popular Posts

2810, 2025

Who owns the future? AI training and the global battle for copyright.

October 28th, 2025|Categories: Shorts & Tutorials, Artificial intelligence, AutoGPT, ChatGPT, Data Protection, Internet, Finance & Shopping, LLaMa, TruthGPT|Tags: , , |

AI companies are training their models with billions of copyrighted works from the internet – often without permission. Is this transformative "fair use" or theft? Authors and artists are complaining because AI is now directly competing with them and copying their styles.

2710, 2025

Dynamic ranges in Excel: OFFSET function

October 27th, 2025|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Office 365|Tags: , |

The OFFSET function in Excel creates a flexible reference. Instead of fixing =SUM(B5:B7), the function finds the range itself, e.g., for the "last 3 months". Ideal for dynamic charts or dashboards that grow automatically.

2710, 2025

Mastering the INDIRECT function in Excel

October 27th, 2025|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Office 365|Tags: , |

The INDIRECT function in Excel converts text into a real reference. Instead of manually typing =January!E10, use =INDIRECT(A2 & "!E10"), where A2 contains 'January'. This allows you to easily create dynamic summaries for multiple worksheets.

2310, 2025

From assistant to agent: Microsoft’s Copilot

October 23rd, 2025|Categories: Shorts & Tutorials, Artificial intelligence, AutoGPT, ChatGPT, Homeoffice, LLaMa, Microsoft Excel, Microsoft Office, Microsoft Outlook, Microsoft PowerPoint, Microsoft Teams, Microsoft Word, Office 365, TruthGPT, Windows 10/11/12|Tags: , , , |

Copilot is growing up: Microsoft's AI is no longer an assistant, but a proactive agent. With "Vision," it sees your Windows desktop; in M365, it analyzes data as a "Researcher"; and in GitHub, it autonomously corrects code. The biggest update yet.

2010, 2025

The “Zero Inbox” method with Outlook: How to permanently get your mailbox under control.

October 20th, 2025|Categories: Shorts & Tutorials, Data Protection, Homeoffice, Microsoft Office, Microsoft Outlook, Office 365, Windows 10/11/12|Tags: , , , |

Caught red-handed? Your Outlook inbox has 1000+ emails? That's pure stress. Stop the email deluge with the "Zero Inbox" method. We'll show you how to clean up your inbox and regain control using Quick Steps and rules.

2010, 2025

5 simple security rules against phishing and spam that everyone should know

October 20th, 2025|Categories: Shorts & Tutorials, Data Protection, Homeoffice, Internet, Finance & Shopping, Microsoft Office, Office 365, Software, Windows 10/11/12|Tags: , , , |

Deceptively authentic emails from your bank, DHL, or PayPal? That's phishing! Data theft and viruses are a daily threat. We'll show you 5 simple rules (2FA, password managers, etc.) to protect yourself immediately and effectively and help you spot scammers.

Offers 2024: Word & Excel Templates

Popular Posts

2810, 2025

Who owns the future? AI training and the global battle for copyright.

October 28th, 2025|Categories: Shorts & Tutorials, Artificial intelligence, AutoGPT, ChatGPT, Data Protection, Internet, Finance & Shopping, LLaMa, TruthGPT|Tags: , , |

AI companies are training their models with billions of copyrighted works from the internet – often without permission. Is this transformative "fair use" or theft? Authors and artists are complaining because AI is now directly competing with them and copying their styles.

2710, 2025

Dynamic ranges in Excel: OFFSET function

October 27th, 2025|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Office 365|Tags: , |

The OFFSET function in Excel creates a flexible reference. Instead of fixing =SUM(B5:B7), the function finds the range itself, e.g., for the "last 3 months". Ideal for dynamic charts or dashboards that grow automatically.

2710, 2025

Mastering the INDIRECT function in Excel

October 27th, 2025|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Office 365|Tags: , |

The INDIRECT function in Excel converts text into a real reference. Instead of manually typing =January!E10, use =INDIRECT(A2 & "!E10"), where A2 contains 'January'. This allows you to easily create dynamic summaries for multiple worksheets.

2310, 2025

From assistant to agent: Microsoft’s Copilot

October 23rd, 2025|Categories: Shorts & Tutorials, Artificial intelligence, AutoGPT, ChatGPT, Homeoffice, LLaMa, Microsoft Excel, Microsoft Office, Microsoft Outlook, Microsoft PowerPoint, Microsoft Teams, Microsoft Word, Office 365, TruthGPT, Windows 10/11/12|Tags: , , , |

Copilot is growing up: Microsoft's AI is no longer an assistant, but a proactive agent. With "Vision," it sees your Windows desktop; in M365, it analyzes data as a "Researcher"; and in GitHub, it autonomously corrects code. The biggest update yet.

2010, 2025

The “Zero Inbox” method with Outlook: How to permanently get your mailbox under control.

October 20th, 2025|Categories: Shorts & Tutorials, Data Protection, Homeoffice, Microsoft Office, Microsoft Outlook, Office 365, Windows 10/11/12|Tags: , , , |

Caught red-handed? Your Outlook inbox has 1000+ emails? That's pure stress. Stop the email deluge with the "Zero Inbox" method. We'll show you how to clean up your inbox and regain control using Quick Steps and rules.

2010, 2025

5 simple security rules against phishing and spam that everyone should know

October 20th, 2025|Categories: Shorts & Tutorials, Data Protection, Homeoffice, Internet, Finance & Shopping, Microsoft Office, Office 365, Software, Windows 10/11/12|Tags: , , , |

Deceptively authentic emails from your bank, DHL, or PayPal? That's phishing! Data theft and viruses are a daily threat. We'll show you 5 simple rules (2FA, password managers, etc.) to protect yourself immediately and effectively and help you spot scammers.

Offers 2024: Word & Excel Templates

* contained paid Promotion
Ads

Popular Posts:

Search by category:

Autumn Specials:

Anzeige
Go to Top