100% ONLINE
Training

Microsoft Excel
Specialist

Approved by over 5,800 Students ⭐⭐⭐⭐⭐

✅ Basic Excel Course
✅ Intermediate Excel Course
✅ Advanced Excel Course
✅ Dashboard Course
✅ Smart Spreadsheets Course

Hours
Minutes
Seconds

( LAST UNITS WITH DISCOUNT )

2,784 Copies Sold in the last 2 months

GET TO KNOW THE EXCEL E-BOOK FROM BASIC TO ADVANCED

Excel Bible

By Gabriel Venturini

This is the result of more than 10 years studying Excel software…  The “Excel Bible” is a complete manual for all those who want to learn to use Excel from scratch or improve their current level. 

Divided into 15 modules ranging from the fully practical (Basic, Intermediate, and Advanced) that will teach you to step by step all the methods and techniques you need to know to learn to solve any problem with spreadsheets, learn important formulas, tables/charts, and dynamic charts… To even record macros! 

In addition, we will build our spreadsheet from scratch, transforming it into Interactive Dashboards and you will be able to apply your Excel knowledge to any project you want!

WHAT WILL I LEARN FROM THIS E-BOOK?

Module 00

The Beginning of Your Journey

Class 01: Start Here

Class 02: How will the support work in case of doubts?

Module 01

Mental Alignment and Overview

Class 03: Mental Alignment and Overview

Class 04: Who is the Course Instructor?

Class 05: Microsoft Excel 

Module 02

The Beginning

Class 06: Introduction

Class 07: Getting to know the Working Area

Class 08: Formatting cells

Class 09: Cells, Columns and Lines

Class 10: Configuration Font

Class 11: Alignment Setup

Class 12: Equals sign (=)

Class 13: Freezing and Unfreezing Rows and Columns

Class 14: Formatting Brushes

Class 15: Automatic Filling of Cells

Class 16: Cutting

Class 17: Paste

Class 18: Worksheets (Create, Rename and Delete)

Class 19: Creating, Renaming and Deleting Tabs

Class 20: Hiding and showing again tabs, columns and rows

Class 21: Merge and Center Cells

Class 22: Status Bar

Class 23: Changing Row Height and Column Width

Class 24: Creating, Saving, Closing and Opening a File

Class 25: Inserting Images, Layout, Icons and Webdings

Class 26: Automatic Calendar

Class 27: Creating and Designing Tables/Charts

Class 28: Creating an Inventory Control Table/Charts

Class 29: Conclusion

Module 03

Mathematical Formulas

Class 30: Introduction

Class 31: Table/Chart of Basic Formulas

Class 32: Sum

Class 33: Max

Class 34: Min

Class 35: Large

Class 36: Small

Class 37: Product

Class 38: Quotient

Class 39: Power

Class 40: Fact

Class 41: ABS

Class 42: LCM

Class 43: ODD

Class 44: Even

Class 45: SUMIF

Class 46: SUMIFS

Class 47: RandomBetween

Class 48: RandomInter with Dates

Class 49: Database

Class 50: Conclusion

Module 04

Date and Time Formulas

Class 51: Introduction

Class 52: Now

Class 53: Today

Class 54: Date

Class 55: Day

Class 56: Month

Class 57: Year

Class 58: Workday

Class 59: Hour

Class 60: Weekday

Class 61: Minute

Class 62: Second

Class 63: Conclusion

Module 05

Counting Formulas

Class 64: Introduction

Class 65: Count

Class 66: Counta

Class 67: CONT.IF

Class 68: CONT.IFS

Class 69: Countblank

Class 70: Roundup

Class 71: Rounddown

Class 72: Conclusion

Module 06

Condition Formulas

Class 73: Introduction

Class 74: IF

Class 75: AND

Class 76: OR

Class 77: NA

Class 78: IFNA

Class 79: IFERROR

Class 80: & (Commercial)

Class 81: Rept

Class 82: Rept in Graphic

Class 83: Conditional Formatting

Class 84: Conclusion

Module 07

Conversion Formulas

Class 85: Introduction

Class 86: Convert

Class 87: OCT2HEX

Class 88: OCT2DEC

Class 89: OCT2BIN

Class 90: HEX2OCT

Class 91: HEX2DEC

Class 92: HEX2BIN

Class 93: DEC2OCT

Class 94: DEC2HEX

Class 95: DEC2BIN

Class 96: BIN2OCT

Class 97: BIN2HEX

Class 98: Conclusion

Module 08

Statistical Formulas

Class 99: Introduction

Class 100: Median

Class 101: Average

Class 102: Mod

Class 103: AVERAGEIF

Class 104: AVERAGEIFS

Class 105: RANK.EQ

Class 106: SumProduct

Class 107: Subtotal

Class 108: Roman

Class 109: Mode

Class 110: Conclusion

Module 09

Search Formulas

Class 111: Introduction

Class 112: Offset

Class 113: Indirect

Class 114: Transpose

Class 115: VLOOKUP

Class 116: VLOOKUP – Example 02

Class 117: VLOOKUP – Example 03

Class 118: Index + Corresp

Class 119: Index + Corresp – Example 02

Class 120: Index + Corresp – Example 03

Class 121: HLOOKUP

Class 122: HLOOKUP – Example 02

Class 123: HLOOKUP – Example 03

Class 124: Direct Mail

Class 125: Conclusion

Module 10

Text Formulas

Class 126: Introduction

Class 127: Trim

Class 128: Char and Code

Class 129: Concatenate

Class 130: Right

Class 131: Left

Class 132: Isnumber

Class 133: Istext

Class 134: Exact

Class 135: MID

Class 136: Upper

Class 137: Lower

Class 138: Proper

Class 139: Find and Replace

Class 140: Len

Class 141: Text

Class 142: Validation of Data

Class 143: Conclusion

Module 11

Financial Formulas

Class 144: Introduction

Class 145: Financial Functions

Class 146: Net Present Value

Class 147: IRR

Class 148: XNPV

Class 149: XIRR

Class 150: Conclusion

Module 12

Types of Charts

Class 151: Introduction

Class 152: Chart Types

Class 153: Graph Tools

Class 154: Bar Graphs

Class 155: Bubble Chart

Class 156: Area Chart

Class 157: Column Chart

Class 158: Dispersion Chart

Class 159: Stock Chart

Class 160: Line Graphs

Class 161: Pie Chart

Class 162: Radar Chart

Class 163: Thread Chart

Class 164: Surface Chart

Class 165: Dynamic Graphics

Class 166: Combination Charting

Class 167: Gantt Chart

Class 168: Button Chart

Class 169: Chart with Image

Class 170: Graph of Goal x Accomplished

Class 171: Traffic Light Chart

Class 172: Speedometer Chart

Class 173: Dynamic Charts

Class 174: Forms Customization

Class 175: Conclusion

Module 13

Dashboard’s

Class 176: Introduction

Class 177: Creating a Dashboard

Class 178: Dashboard – Example 02

Class 179: Conclusion

Module 14

Advanced Learning

Class 180: Introduction

Class 181: + Menus in Excel

Class 182: Password Protect your Sheet

Class 183: Quick Tips

Class 184: Saving a PDF File

Class 185: Hyperlink

Class 186: Adding a Macro Button

Class 187: Inserting your ID, Issuance of Individual Taxpayer Registry, and

Telephone

Class 188: Filtering Parts of a Chart

Class 189: Calculating in Excel without Formulas

Class 190: Autofill with More Options

Class 191: Background in Comments

Class 192: Opening an XML File

Class 193: Conclusion

Take a look at some of the many excel features you will learn.
These and much more.

THERE’S MORE 💙

BUT ONLY TODAY… By Purchasing Today You Get This Incredible Collection Of SPECIAL BONUSES!

[ UNIQUE PROMOTION ]

SPECIAL SUPER BONUS 01

6 Super Smart Spreadsheets

From $6.00 for
$0,00
FREE today, just for you!

Plus, I’ll teach you how to build super creative and dynamic charts in Excel so you can rock your reports, dashboards, infographics, and all your other presentations!

You will learn how to build from scratch:

 

Filling Cup Chart

Repetition Chart

Waffle Chart

Heat Chart

Journey Chart

SWOT Analysis

SPECIAL SUPER BONUS 02

Dominating the Job Market (the definitive guide)

From $16.00 for
$0,00
FREE today, just for you!

At the beginning of a career, for both interns and trainees, it is natural to have questions.

If you are open to learning more about yourself, breaking down paradigms and beliefs that limit your career progress, are ready to create change in your life, and are willing to succeed in your career, then read this e-book.

Every professional will benefit from the practical and immediately applicable tips on behavioral dilemmas and relationship problems that we face during our corporate life, which will teach you step by step how to become a qualified professional.

This e-book contains content on the main subjects of today’s market: How to get the job you want, tips for job interviews, corporate behavior, career leverage, getting the job you want, and tips to get your resume approved by any company!

SPECIAL SUPER BONUS 03

Write a Professional Resume

Don’t make the same old MISTAKE
every time!
Write a Professional Resume

 
From $9.00 for
$0,00
FREE today, JUST for you!

Did you know that nowadays companies’ selection processes are evaluated by artificial intelligence?

You may have been eliminated from your dream job only because you entered your data wrongly.

That’s right… You may have been eliminated from a much-desired position just for entering your personal and professional data wrongly.

Robots start picking resumes in job selections, the logic is to use artificial intelligence and algorithms to scan a resume for indications that the candidate will be great (or not) for a given vacancy.

But now you won’t have this problem anymore. We have developed a resume that “knocks out” the machine so you can be selected for all the jobs you want!

SPECIAL SUPER BONUS 04

SUPER PACK OF WORKSHEETS

BESIDES ALL THE CONTENT OF THE E-BOOK YOU RECEIVE

EXCLUSIVE AND FREE BONUSES!

From $6.00 for
$0,00
FREE today for you

Dashboard for Workplace Safety (Managing Accidents with a Workplace Safety Worksheet. This spreadsheet is used to post objective accident data: accident name, age, gender, accident location, the type of accident, and the date and day of the week).

Research and Satisfaction Dashboard (Conducting customer satisfaction surveys is a business practice that offers at least two major advantages for companies: they establish a dialogue channel with customers, who start to feel more considered and contemplated; and the company gains more chances to get it right when offering its products and services, meeting the real demands of its customers).

Action Plan System (This spreadsheet is a great tool for monitoring activities, from the simple ones like meeting minutes to the more complex ones like a small project. It is a document used to plan all the necessary actions to achieve the desired result or solve problems).

Spreadsheet for Family Budget Control (A family budget spreadsheet is suitable for those who live with other family members. So it should include all the people who live with you. It is a more complex control than the individual spreadsheet. In theory, it would be like a set of personal expense spreadsheets for each family member).

Spreadsheet of Personal Expenses (This spreadsheet was developed for the control of personal expenses, where it consists in listing the amounts that enter and leave your cash, showing at the end the remaining balance). Made exclusively Easily and Practically for the daily control of expenses.

Resume Control Sheet (List in Excel the companies in which you would like to work. Then, register your resume on the site of the intended company and register in your control table the date you registered your resume).

Sales Spreadsheet (this is a very useful tool for controlling and tracking all company and/or personal sales. Therefore, using a system or spreadsheet to control and follow up on sales and updating it daily is fundamental to having more precise control of goals and results).

Spreadsheet of Courses and Improvements (Assists for the control of Certificates of Courses and Improvements, to be inserted the data and help to control Hours x Course Held).

Worksheet to Calculate Overtime (One of the competencies of the human resources sector is to calculate overtime, that is, the hours worked beyond the hours established in the contract with the employee. There are several ways to control overtime. The spreadsheet was designed to calculate overtime, which can greatly facilitate the closing of the payroll at the end of the month, and also for the employee’s own internal control).

HAVEN’T DOWNLOADED OUR WORKBOOK YET? THEN READ THIS.

If you are still here with me it is because you want to become an expert in excel, identified with everything that was said, and are willing to learn how to use the tool to become an expert and impress in your work, business, or day-to-day personally.

If you do not want to purchase our excel workbook today, that’s fine, but soon we will raise the price because we will add much more amazing content and those who have already downloaded will receive all updates for free, (remember that access is forever). So do not miss this opportunity.

WHAT DOES THE BIBLE HAVE THAT OTHER E-BOOKS DO NOT?

EXCLUSIVE GROUP
FOR STUDENTS

A closed community in Whatsapp with me, to encourage and provoke you positively every day (optional).

 
DAILY INDIVIDUAL PROFESSIONAL ASSISTANCE


Have questions about the class? Send us your question. days (optional).

 
SUPER PACK OF 
EDITABLE SPREADSHEETS


Spreadsheets ready to download and edit as you wish, usable for professional and personal use!

STUDY PLAN

This a practical guide for you to get the most out of 15+ lessons, at your own pace and according to your own schedule.

LIFETIME ACCESS TO CONTENT

You can view and review the content as many times as you like!

My Work With the Excel Bible... I love what I do

Instant Access to Everything

The Excel Bible is Fully Up-to-Date with the Best to Become an Excel Expert

You will find that the method I use makes you start seeing results from the very beginning of the ebook…

You do NOT need to finish, or complete all the modules to get results!

By purchasing the Excel Bible today, you get a $37.00 bonus

See below all that you will get.

Content 100% Updated to June 2024

Excel Bible

Super Smart Spreadsheets (ENHANCED) from $6.00 for FREE today for you

Mastering the Job Market E-book for $16.00 FREE today for you

Professional Resume for $9 FREE today for you

Super Pack of Editable Spreadsheets for $6.00 FREE today for you

Exclusive Group for Students

Daily Exclusive Service

Study Plan

Extra Materials and Complementary Activities

Free Upgrades

THAT'S EXACTLY WHAT YOU'RE READING!

I truly believe in the power of transformation that Excel has. That is why I offer a guarantee.

If within the 7 days, for any reason, you are not satisfied with our e-book, just send me 1 single email through our support and we will refund all your money Immediately!

Exclusive Offer!
5 courses in 1

CONTACT US

Our Support E-mail

contato@descomplicaonline.com

FAQ

Any Questions?

The E-book is in PDF format, if the payment is by bank payment slip, payment can take up to 48 hours, after which you will receive an automatic e-mail with the login and access data to the e-book.

If the payment is by credit card, you will receive the access data in your e-mail in a matter of minutes!

YES, if you wish you can print it and turn it into a booklet, which is very cheap to buy in a stationery store and looks beautiful, is easy to handle for study and to practice what you have learned in class.

If you apply the way I teach step by step and make it happen, it is practically impossible not to give results, the method has already been tested and validated by more than 5,800 students.

I have full conviction that it will work for you, it’s very simple, just do what I’m going to show you (even with little time to practice) and you will get results!

If you apply it, you can’t go wrong!

Absolutely! The E-book was designed and made exclusively for you who know absolutely nothing about Excel. Even for those who have never opened an Excel. You will learn everything from scratch step by step simply and practically.

TERMS AND CONDITIONS

The products and services sold on this site should not be construed as a promise or guarantee of results.

Your level of success in achieving the results advertised with the use of our products and information depends on the time you put into the program, the techniques used, and different knowledge, and skills.

Because these factors differ between individuals, we cannot guarantee success or the level of results, nor are we responsible for any of our actions.

Any forward-looking statements contained on this site or in any of our products are intended to express our opinion about the potential results that some people may achieve.

All Rights Reserved 

Excel Bible by Gabriel Venturini