Articles and news about Advanced Computing

Extra programming list in Excel 1-3

More exercises to improve your knowledge in Excel or Google Sheets

Search functions: the pivot table in Excel or spreadsheets

The pivot table in Excel automates everything we have learned to date with just a few clicks

Search functions: VLOOKUP or VLOOKUP and HLOOKUP or HLOOKUP

Now we will see new types of functions in Excel or Spreadsheets: search functions! Such as VLOOKUP or VLOOKUP and HLOOKUP or HLOOKUP

Search functions: RANK, INDEX + MATCH or INDEX + MATCH

Could there be a better way to search than VLOOKUP? Discover the combination of the INDEX function with MATCH in Excel or spreadsheets!

Search functions: Filters, OFFSET and INDEX:INDEX

In this class we will see how to reduce your database in Excel or spreadsheets so that we can only use what we want

Working with Text in Excel: How to extract and replace words

Learn effective techniques for working with text in Excel, from extracting specific words to efficiently replacing them. Improve your Excel skills an...

Time Functions in Excel: How to Work with Dates

Discover Excel's essential tools for dealing with dates, learn how to use time functions in an effective and simplified way, and master the art of con...

Conditional functions: COUNTUNIQUEIF and AVERAGEIF

Let's continue looking at Excel formulas, now let's try to understand COUNTIFUNIQUEIF and AVERAGEIF

Conditional functions: SUMIF or SUMIF and COUNTIF or COUNTIF

Let's continue looking at Excel formulas, now let's try to understand SUMIF or SUMIF, COUNTIF or COUNTIF

Basic and essential Excel functions: Sum, Average, Maximum, Minimum and more

Discover how to use fundamental Excel functions, such as Sum, Average, Maximum and Minimum, to optimize your spreadsheets and increase your productivi...

Logical or conditional functions in Excel or spreadsheets: AND, OR and IF

In the first class of Advanced Computing 2, we will see the Excel formulas "OR" and "AND" and how they are applied within other functions such as IF

Getting Started in Excel or Spreadsheets: First IF Function

Let's get to know our first function in Excel! The IF function and what we can do with it

Getting started in Excel or spreadsheets: arithmetic operators and sign

Within each Excel cell we can perform different calculations. Let's start by looking at what we can do with arithmetic and reference operations

Getting Started in Excel or Spreadsheets: Its Interface

Let's switch applications now and see how Microsoft Excel or Google Sheets works

Reviewing and commenting on text templates

Let's take examples of templates for your text editor on the internet, let's modify them to your needs and make beautiful work out of them

Inserting header, table of contents, bullets and figures in Word

Advancing our knowledge of Word a little further, today we will analyze how to insert necessary elements into texts in the document

Text editing using applications such as Microsoft Word

Microsoft Word, Google documents, LibreOffice Writer are programs used for editing and laying out texts. Today we will see how to get started with th...

Your computer, IT and applications

In a world full of Windows, Apple and Linux we need to adapt and understand how programs work

Introduction to VBA in Excel

Welcome to the world of Excel automation with VBA (Visual Basic for Applications)! In this lesson, you will learn the basics to start creating macros ...

How to Handle Errors in Excel

In this lesson, we will explore the main types of errors in Excel, how to interpret them and which functions can help correct or work around them.