THE MOST COMPLETE COURSE ON THE NETWORK with more than 200 exercises to practice. You have to try this free 2023 Excel course in its 3 basic, intermediate and advanced levels.
In this MEGA PROJECT you will find the 3 levels of Excel with more than 200 exercises to practice and become an expert without spending anything.
Don't miss this opportunity where you will learn everything related to Excel in a single video.
👇 DOWNLOAD THE COURSE MASTERBOOK 👇
https://eltiotech.com/curso-completo-y-gratis-de-excel-2023/
00:00 Introduction to the complete Excel course
03:26 Course recommendations
👉First Steps:
07:15 Getting to know the Excel environment
19:21 Basic Settings
23:33 Save, Export and print
25:37 Managing Excel Sheets
31:09 Cell formats
👉Basic Fundamentals:
47:35 Workbook, sheet and cell protection
54:36 Handling rows, columns, cells, ranges and tables
01:04:20 Arithmetic operators in excel
01:09:53 Cell reference: relative, absolute and mixed.
👉Basic Functions:
01:19:51 Add, count, count, max, min and average function.
01:26:30 Conditionals: Add.if, count.if, average.if, max.if, min.if.
01:34:30 Text: concatenate, left, right, extract,
01:39:50 Separate text into Columns, remove duplicates.
👉Advanced Features:
01:46:10 Nested functions (Yes Nested)
02:00:40 Logic Functions: IF, AND, OR
02:05:00 Search functions: searchV, searchH,
02:14:20 Reference functions: index and match
👉Table format:
02:24:56 Create a table
02:30:27 Sub Totals
02:32:20 Autofilter and advanced filter
02:38:40 Sort Data
02:39:25 Data validation
👉Chart creation:
02:45:23 Columns, bars, lines, scatter etc.
02:53:09 Edit Elements
👉Pivot tables and dynamic graphs
03:19:04 Create pivot tables
03:26:50 Edit pivot tables: styles, group data, sort
03:31:50 Field settings and options
03:35:50 Calculated fields
03:39:20 Create dynamic charts
03:42:00 Data segmentation
Timeline
👉Advanced Filters:
03:50:28 Filter by criteria
03:55:25 Filter by two criteria
03:57:09 Filter by three criteria
03:59:10 Filter values starting with the first letter
04:03:48 Filter values that end in a letter
👉Creation of Macros
04:11:50 What is a macro and what is it for?
04:15:09 Macro to feed Database
04:30:10 Macro with advanced filters
04:34:00 Create Absolute and Relative Macro
👉04:39:40 Dashboard Creation
🔴04:40:40 https://www.youtube.com/watch?v=nQ0XIH8kSow
Dynamic table configuration
Configuration Shapes
Dashboard Creation
VISIT OUR WEB PAGES:
🔵 https://www.eltiotech.com
🔵 https://www.tiotech.net
FOLLOW US ON OUR SOCIAL NETWORKS
🔴 TikTok: https://www.tiktok.com/@eltiotech_
🔴 Instagram: https://www.instagram.com/luismiguevelavela/
🔴 Facebook: https://www.facebook.com/eltiotechh
CHECK OUT OUR HELP GROUPS
Help in Excel: https://www.facebook.com/groups/excelayudas/
🔵 Help in Word: https://www.facebook.com/groups/2954410744838915