Free ebook for Excel beginners covering formulas, formatting, charts, pivot tables, data analysis, macros, and productivity tools.
Free ebook + audiobook content
-
Introduction to Excel
+ Exercise: What is one of the main advantages of Excel? 1 minutes
-
Excel interface
+ Exercise: What is the bar located at the bottom of the Excel window that displays information about the worksheet, such as the number of cells selected, the current view and the status of the worksheet? 2 minutes
-
spreadsheet creation
+ Exercise: What is the function of the "Insert chart" option on the Excel toolbar? 2 minutes
-
cell formatting
+ Exercise: What is one of the most used formatting options in Excel? 1 minutes
-
Basic formulas and functions
+ Exercise: What is the difference between formulas and functions in Excel? 2 minutes
-
cell references
+ Exercise: What is the difference between relative reference and absolute reference in Excel? 2 minutes
-
mathematical operators
+ Exercise: What operator is used to compare whether a value is greater than or equal to another? 3 minutes
-
date and time functions
+ Exercise: Which Excel function returns the current date? 2 minutes
-
text functions
+ Exercise: Which Excel function allows you to combine different texts in a single cell? 2 minutes
-
Search and reference functions
+ Exercise: Which Excel function allows you to find values in a table based on a reference or lookup value? 2 minutes
-
conditional functions
+ Exercise: What is the Excel function used to count the number of cells in a worksheet that meet a certain condition? 3 minutes
-
conditional formatting
+ Exercise: How can you use conditional formatting in Excel? 1 minutes
-
basic graphics
+ Exercise: What is the most suitable type of graph to show the proportion of each category in relation to the whole? 2 minutes
-
pivot tables
+ Exercise: What is the area where you specify the information you want to appear in the rows of the pivot table? 2 minutes
-
Data sorting and filtering
+ Exercise: What is the difference between sorting and filtering data in Excel? 2 minutes
-
data validation
+ Exercise: What type of data validation allows you to create a drop-down list of options for users to choose from? 2 minutes
-
data consolidation
+ Exercise: What is the function used to add values during data consolidation in Excel? 2 minutes
-
worksheet protection
+ Exercise: What is the function of protecting worksheets in Excel? 1 minutes
-
Task automation with macros
+ Exercise: What is the purpose of creating macros in Excel? 2 minutes
-
Spreadsheet sharing
+ Exercise: How to share a spreadsheet in Excel? 1 minutes
-
Spreadsheet printing
+ Exercise: Which of the options below is one of the most important settings to configure before printing a worksheet in Excel? 2 minutes
-
Tips and tricks to increase productivity
+ Exercise: What is the function that allows summing the values in a column based on a certain criterion in Excel? 2 minutes
-
keyboard shortcuts
+ Exercise: What is the keyboard shortcut to select all cells in a worksheet in Excel? 2 minutes
-
Interface customization
+ Exercise: What is one of the simplest ways to customize the Excel interface? 3 minutes
-
Data import and export
+ Exercise: What is the purpose of importing and exporting data in Excel? 1 minutes
-
Use of add-ins
+ Exercise: Which add-in adds an optimization tool that allows finding the optimal solution to a problem, such as resource allocation or profit maximization? 2 minutes
-
Data analysis with Excel
+ Exercise: What is one of the most powerful tools in Excel for data analysis? 2 minutes
-
solver
+ Exercise: What is one of the main advantages of Solver? 1 minutes
-
Trend analysis
+ Exercise: What is the purpose of trend analysis in Excel? 2 minutes
-
Linear regression
+ Exercise: What is the purpose of linear regression? 2 minutes
-
Time series forecasting
+ Exercise: What is the most used Excel function for forecasting time series? 2 minutes
-
Hypothesis analysis
+ Exercise: What is the test used to compare the mean of two data samples in Excel? 1 minutes
-
sensitivity analysis
+ Exercise: What is one of the most useful tools for performing sensitivity analysis in Excel? 1 minutes
-
Monte Carlo Simulation
+ Exercise: What is the first step to carry out the Monte Carlo Simulation in Excel? 2 minutes
-
Scenario analysis
+ Exercise: What is the purpose of the "Scenario Manager" tool in Excel? 1 minutes
-
Using Statistical Functions
+ Exercise: What is the statistical function that calculates the arithmetic mean of the values of a set of data in Excel? 2 minutes
-
Use of financial functions
+ Exercise: What is the financial function in Excel that calculates the future value of an investment? 2 minutes
About the free ebook with audio
Complete Excel Course for Beginners
Build practical spreadsheet skills with this free beginner-friendly Excel ebook. Learn how to navigate Excel confidently, create organized worksheets, format cells, and use formulas to turn everyday data into useful information.
Learn essential Excel skills
Start with the interface, spreadsheet creation, cell references, mathematical operators, and core functions for dates, times, text, conditions, searching, and references. Clear explanations help you understand how formulas work and how to avoid common mistakes.
Organize and present data
Explore sorting, filtering, validation, conditional formatting, charts, pivot tables, consolidation, sharing, printing, and worksheet protection. These skills support cleaner reports and more reliable workbooks.
Work smarter with Excel
Discover productivity techniques including keyboard shortcuts, interface customization, add-ins, importing and exporting data, and macro-based task automation. Learn to make repetitive spreadsheet work faster and more consistent.
Introduction to data analysis
Go beyond basic spreadsheets with tools for data analysis, Solver, trend analysis, linear regression, forecasting, hypothesis testing, sensitivity analysis, Monte Carlo simulation, scenarios, and statistical and financial functions.
Who this ebook is for
- Beginners learning Microsoft Excel from the ground up
- Students and professionals who need stronger spreadsheet skills
- Anyone who wants to organize, analyze, and present data more effectively
Use this ebook as a practical foundation for creating accurate, efficient, and professional Excel workbooks.
Is this Excel ebook suitable for complete beginners?
Yes. It starts with the Excel interface, worksheets, formatting, and basic formulas.
Does the ebook cover Excel formulas and functions?
Yes. It includes basic, text, date, conditional, lookup, statistical, and financial functions.
Will I learn Excel data analysis techniques?
Yes. Topics include pivot tables, Solver, regression, forecasting, scenarios, and sensitivity analysis.
This ebook/audiobook includes:
1 hours and 21 minutes of audio content
Digital certificate of course completion (Free)
Exercises to train your knowledge
100% free, from content to certificate
Ready to get started?
recommended
In the app you will also find...
Over 5,000 free courses
Programming, English, Digital Marketing and much more! Learn whatever you want, for free.
Study plan with AI
Our app's Artificial Intelligence can create a study schedule for the course you choose.
From zero to professional success
Improve your resume with our free Certificate and then use our Artificial Intelligence to find your dream job.
You can also use the QR Code or the links below.
