Learn Excel

Excel Lessons

Free Excel Lessons

348 Animated lessons

The course consists of four stages. You first study flatness and its design and then move on to concepts that simplify computational processes. The next step is to learn about relative linking, which will completely change your perception of information processing. The last stage concerns large-scale information processing facilities.

After 120 lessons, you master the program at an intermediate level (90% in offices generally know within 80-100 lessons).

After 240 lessons, you will become a strong professional.

After 348 lessons, you will fully master any program other than Visual Basic. You can arrange a design of any complexity, as conceived by the authors of the program. Combine Excel databases with other programs and create relative information models.

 Subscribe to youtube channel 

Create a new file in Excel, lesson 1

Create a new file in Excel from templates, lesson 2

How to save file in excel, lesson 3

Always save Excel files in the same folder, lesson 4

How open excel file, lesson 5

How to print excel file, lesson 6

How to password protect excel file, lesson 7

How to remove password from excel file, lesson 8

How to rewind the action back and forth in Excel, lesson 9

How to select all cells in Excel lesson 10

Copy, cut and paste cells in Excel, lesson 11

Alt key in excel, lesson 12

Find Excel file author, created date, size, last printed or modified date, lesson 13

How to insert a formula in excel, lesson 14

How to align content in Excel cells, lesson 15

Underline or double underline, content in excel cells, lesson 16

How to make content bold or italic in an Excel cell, lesson 17

How to add an auto-numbering to content using Excel intellect lesson 18

How display content in cells with different fonts and sizes in excel, lesson 19

How Display text in excel cells with strikethrough and change font color, lesson 20

How to display content in Excel cells in superscript and subscript, lesson 21

How to create a simple table (range) in excel, lesson 22

How to change excel cell border style, lesson 23

Diagonal line in Excel cells, lesson 24

Different Colors of Excel Cell Borders, lesson 25

how to merge cells in excel, lesson 26

How to slant text in an Excel cell, lesson 27

Move (horizontally) text in excel cells, lesson 28

Wrap extra-long text in multiple lines of excel cell, lesson 29

Copy Excel cell with or without design, lesson 30

Copy Excel cell without border formation, lesson 31

Copy Excel cell with border formation lesson 32

Copy and change the horizontal formula to vertical in excel, lesson 33

How to copy Excel cell values (results) without formulas, lesson 34

How to copy excel cell design without formulas and values and absolute cell references, lesson 35

Connect excel cell to image, lesson 36

Excel cell format painter, lesson 37

Using excel paste special menu, lesson 38

Dynamic copying excel cells, without loss of connection, lesson 39

Copy vertical excel table to horizontal, lesson 40

Copy Excel cell with format change and value multiplication, lesson 41

How to compare two columns in excel, lesson 41-1

How to change decimal point value in excel cell, lesson 42

How to change number value in excel cell to currency, lesson 43

Automatically change Excel cell design if value exceeds specified, Lesson 44

Change Excel cell design if value is outside specified range of numbers, lesson 45

Change the design of an Excel cell if the text value partially matches the given text, lesson 46

Change the format of the excel table, if the cell contains specific piece of text, lesson 47

Change the format of the table, if the excel cell contains specific dates , lesson 48

how to find duplicates in excel, lesson 49

How to visualize dynamically top numbers in excel, lesson 50

How to highlight bottom cell values in excel, lesson 51

How to automatically extract the largest values from a table in Excel using percentages, Lesson 52

How to highlight above average values from a table, lesson 53

How to highlight Below average values from a table, lesson 54

Show numbers in excel cell as loading bar, lesson 55

The changeable color scale in excel numeric values, lesson 56

The changeable icons in excel numeric values, lesson 57

How to display excel table in 2 colors by number value, lesson 58

How to change excel cell format by true or false value, lesson 59

How to change excel cell format if the cell is empty or filled, lesson 60

Change the format of the table if the cells are equal to each other, Lesson 61

Change the format of the cell table if the content is on a specific date Lesson 62

Gallery of Excel table designs Lesson 63

Add your own design to the Excel table designs gallery lesson 64

Gallery of excel cell designs lesson 65

Add your own design to the excel cell designs gallery lesson 66

insert or remove columns and rows on the excel worksheet lesson 67

Insert new excel Worksheet lesson 68

–°hange the height of all excel cells lesson 69

Automatically –°hange the height of all excel cells lesson 70

–°hange the width of all excel cells lesson 71

Hide or unhide excel cells lesson 72

Hide or unhide excel worksheet lesson 73

Rename excel worksheet, change color of worksheet button lesson 74

Copy or delete Excel worksheet lesson 75

how to lock cells in excel, lesson 76

Unprotect Excel sheet lesson 77

Excel Cell protection and blocking second way lesson 78

Simple way to sum, average, number of excel cells, maximum, minimum lesson 79

Copy adjacent excel cells lesson 80

Create numeric series in excel lesson 81

Create date series in Excel lesson 82

Automatically fill all cells vertically in Excel lesson 83

Justify the text into columns in Excel lesson 84

Extracting the desired value from text in Excel (flash fill), lesson 85

Create Excel cell and sheet Links lesson 86

Links between Excel cells lesson 87

Create web links and file links in a Excel worksheet lesson 88

Create email links on a Excel sheet lesson 89

Excel Cell cleaning functions lesson 90

Find images and information online from a Excel worksheet lesson 91

Synchronous or asynchronous sorting of Excel tables lesson 92

Sorting the Excel table columns by more parameters lesson 93

Creating a Excel table filter lesson 94

Fastest way to create a Excel table filter lesson 95

Excel Table color filters lesson 96

Excel Filter by font color lesson 97

Excel Filter by date lesson 98

Excel Filter by text lesson 99

Excel Filter by numbers, lesson 100

Clear all Excel filters lesson 101

Search in a Excel workbook or sheet lesson 102

Search only in the selected design in Excel lesson 103

Search in Excel formulas, lesson 104

Find and replace text in Excel, lesson 105

Find and replace Excel cell format, lesson 106

Select all the desired field types in Excel, lesson 107

pivot tables in excel, lesson 108

Create a pivot table from templates in Excel, lesson 109

Change the format of pivot table cells in Excel, lesson 110

Show pivot table data details in Excel, lesson 111

Add a new dimension unit to the Excel table, lesson 112

Extend Pivot Table Data Source in Excel, Lesson 113

Add a calculated field to a Excel pivot table, lesson 114

Add slicer to Excel pivot table, lesson 115

Give name to Excel pivot table, lesson 116

Choice of design for adding report fields in Excel, lesson 117

Create new sheets from excel pivot table filter, lesson 118

Gradient fill in a Excel pivot table, lesson 119

Remove calculated field in Excel pivot table, lesson 120

Show or hide grand totals in a Excel pivot table, lesson 121

Show the difference between sales per month in a Excel pivot table, lesson 122

Change number format with colored arrows in Excel pivot table, lesson 123

Group rows in a Excel pivot table, lesson 124

Insert timeline into Excel pivot table, lesson 125

Excel Pivot charts, lesson 126

Difference between table and range in Excel. (Excel Smart table with name), lesson 127

Add rows to Excel smart table, lesson 128

Difference between smart table and range formulas in Excel, lesson 129

Convert smart table to range in Excel, lesson 130

Converting a smart table to a pivot table in Excel, lesson 131

how to remove duplicates in excel, lesson 132

Add slicer to Excel smart table, lesson 133

Rename excel slicer change slicer design, lesson 134

Smart Table style options, add totals, hide table name, lesson 135

Change number formats of an Excel smart table, lesson 136

How the excel slicer works, remove slicer, lesson 137

Hide Excel slicer when printing sheet, lesson 138

Excel slicer advanced settings, lesson 139

Hide excel slicer from sheet, lesson 140

insert a pixel image into a Excel sheet, lesson 141

insert vector image into Excel sheet, lesson 142

Remove pixel image background in Excel, lesson 143

Pixel image background removal tools in Excel, lesson 144

Adjusting the sharpness, brightness, contrast of the image in Excel, lesson 145

Changing the color temperature and saturation of an image in Excel, lesson 146

Artistic image effects in Excel, lesson 147

How to Compress pictures in Excel, lesson 148

Replace or reset the picture in Excel, lesson 149

Change the borders of the image in Excel, lesson 150

Image layouts in Excel, lesson 151

Bring image to front or back in Excel, lesson 152

Align images in Excel, lesson 153

Snap image to the grid in Excel, lesson 154

Group images in Excel, lesson 155

resize, rotate and restore image settings in excel, lesson 156

Insert image into SmartArt in Excel, lesson 157

How to extract image (media) files from Excel, lesson 157 -1

Edit vector image in Excel, lesson 158

Vector drawing in Excel, lesson 159

Change shapes in Excel, lesson 160

Excel shape connecting lines, lesson 161

Insert text into the Excel shape, lesson 162

Lock Excel shape drawing mode, lesson 163

Shape formula, link cell to shape in Excel, lesson 164

Resizing a vector object, freezing, while growing cells in Excel, lesson 165

Repeating the style of one vector object for other objects in Excel, lesson 166

Replace shape without change text, disable wrap text in Excel, lesson 167

Create a tree in Excel SmartArt, lesson 168

Insert text to create tree in SmartArt in Excel, lesson 169

Shape formula, link cell to SmartArt in Excel, lesson 170

Screenshots from active windows in Excel, lesson 171

Install add-ins in Excel, lesson 172

Remove add-ins from Excel, lesson 173

Manage Excel add-ins, lesson 174

Create Chart in Excel, lesson 175

Extend Chart Data Resource in Excel, lesson 176

Chart parameters in Excel, lesson 177

Rename the source columns of the chart in Excel, lesson 178

Chart additional legend options in Excel, lesson 179

Create pivot table and chart at the same time in Excel, lesson 180

Create Sparkline in Excel, lesson 181

Sparkline high and low points in Excel, lesson 182

Maximum value of the Sparkline along the vertical axis in Excel, lesson 183

Grouping Sparkline's in Excel, lesson 184

A quick way to analyze data in Excel, lesson 185

Resize by clicking in Excel, lesson 186

Page header and footer in Excel, lesson 187

Add page numbers in Excel, lesson 188

Add information to the header and footer of the page in Excel, lesson 189

Another heading on the first page in Excel, lesson 190

Different titles on odd and even pages in Excel, lesson 191

Scale footer with a document in Excel, lesson 192

Automatically align header and footer with document in Excel, lesson 193

WordArt in Excel, lesson 194

Insert a signature into a Excel document, lesson 195

insert a different type of file in Excel, lesson 196

Math input control in Excel, lesson 197

Insert symbols in Excel, lesson 198

Page Layout Design Gallery in Excel, Lesson 199

Saving Your Own Page Layout in Excel, Lesson 200

Page margin settings in Excel, Lesson 201

Rotate page, portrait, and landscape in Excel, Lesson 202

List of page printing standards in Excel, Lesson 203

Print only selected areas in Excel, Lesson 204

Page break split the printed page from the selected point to a new page in Excel, Lesson 205

Change the background of the sheet in Excel, lesson 206

Show grid lines in print area in Excel, lesson 207

Black and white printing in Excel, lesson 208

Remove color and borders when printing, draft quality in Excel, lesson 209

Printing with Row and Column Headers in Excel, lesson 210

Print with comment in Excel, lesson 211

Print everything on one page in Excel, lesson 212

Sequence of printing pages in Excel, lesson 213

Simple repetition of a table heading when printing in Excel, lesson 214

Find and insert function in Excel, lesson 215

SUM function, how select cell segments in Excel, lesson 216

AVERAGE function in Excel, lesson 217

COUNT function, count cells in Excel, lesson 218

MAX function in Excel, lesson 219

MIN function in Excel, lesson 220

if function in Excel, lesson 221

SUMIF function in Excel, lesson 222

SUMIFS function in Excel, lesson 223

TODAY function show today's date in Excel, lesson 224

HUPERLINK function in Excel, lesson 225

ROUND function in Excel, lesson 226

UPPER function in Excel, lesson 227

LOWER function in Excel, lesson 228

COUNTIF function in Excel, lesson 229

How many days between dates, Excel, lesson 230

How to freeze the dynamics of a formula in one cell, Excel lesson 231

Cell math operations in Excel, lesson 232

The cell is dynamically equal to the cell, dynamic concatenation of cells in Excel, lesson 233

Make formulas with one click in Excel, lesson 234

vlookup in excel, lesson 235

how to separate names in excel, lesson 236

Object Neighbor Naming in Excel, lesson 237

Naming from the TOP row in Excel, lesson 238

Different naming techniques in Excel, lesson 239

Object name as a dynamic concept in Excel, lesson 240

Object name in links, Excel lesson 241

Show formulas in Excel cells, lesson 242

Show related formulas in Excel, lesson 243

Find errors in related formulas in Excel, lesson 244

Create a Change Monitoring Window in Excel, lesson 245

Compare changes between file versions in Excel, lesson 246

Pause calculation of formulas in Excel, lesson 247

Show hide main menu in Excel, lesson 248

Insert a table from the internet in Excel, lesson 249

Insert a table in excel from MS Access, lesson 250

Only write predefined numeric values in the Excel cell, lesson 251

Control text input in Excel cell, lesson 252

Control date input in Excel cell, lesson 253

how to create a drop down list in excel, lesson 254

insert checkbox in Excel, lesson 254-1

Call entry error message in Excel, lesson 255

Delete cell entry rules in Excel, lesson 256

Show cells with violation of input rules in Excel, lesson 257

Sum of Values with Consolidation Vertical Table in Excel, lesson 258

Sum of values with consolidation horizontal table in Excel, lesson 259

Sum of values with consolidation, create link to source data in Excel, lesson 260

Split text into columns using a delimiter in Excel, lesson 261

Split text into columns using a text length in Excel, lesson 262

Copy the filtered table through the advanced filter in Excel, lesson 263

Planning in Excel (planning tool), lesson 264

Show all calculation scenarios on a new sheet in Excel, lesson 265

Convert all calculation scenarios to a pivot table in Excel, lesson 266

A tool in Excel that calculates how much is needed to get the desired result, lesson 267

Loan calculator, PMT function in Excel, lesson 268

Scaling simple logic from another formula in Excel, Lesson 269

Scaling complex logic in Excel from another formula, lesson 270

Create a forecast worksheet in Excel, lesson 271

Forecast table design in Excel, lesson 272

Forecast tables more options in Excel, lesson 273

Grouping data, creating a tree in Excel, lesson 274

Spell Checker in Excel, lesson 275

Synonym dictionary in Excel, lesson 276

Worksheet statistics in Excel, lesson 277

Detecting stylistic errors in Excel, lesson 278

Translate content in Excel, lesson 279

Display all comments at once in Excel, lesson 280

Protect an Excel sheet using administrator rights, lesson 281

Disappearing unused cells in Excel, lesson 282

Hide or show sheet gridlines in Excel, lesson 283

Hide or show the formula bar in Excel, lesson 284

Hide or show headings in Excel, lesson 285

Enlarge or reduce a sheet in Excel, lesson 286

Freeze the first column in Excel, lesson 287

Freeze top row in Excel, lesson 288

how to freeze a row in excel, lesson 289

Split sheet in Excel, lesson 290

Repeat actions through macros in Excel, Lesson 291

Repeat the path using a macro in Excel, lesson 292

How to create a relational model in Excel, lesson 293

Excel Relational model, Foreign key, lesson 294

Relative connection of two Excel tables one to many, lesson 295

Pivot Table from Related tables in Excel, lesson 296

How to Enable Power Pivot in Excel, lesson 297

How Power Pivot Manager shows the relative connected tables in Excel, lesson 298

The relational model between three tables in Excel, lesson 299

How Power Pivot Manager shows the relative connections between three tables in Excel, lesson 300

How to Add a new calculated field to the Power pivot manager, Excel, lesson 301

How the Pivot Table shows the calculated field from the Power pivot manager Excel, lesson 302

Add new calculated fields Cost and Profit in Power pivot Manager, Excel lesson 303

Add measures from Power Pivot Manager, Excel lesson 304

Add measure Total Profit from Power Pivot Manager, Excel lesson 305

Add measure Average profit per Customers Power Pivot Manager, Excel lesson 306

How show the profit for each customer in a relative pivot table, Excel lesson 307

Key Performance indicator KPIs, Excel lesson 308

Add a slicer and pivot chart for relative pivot table, Excel lesson 309

The ability to import data and dynamic connections in Power Pivot Manager, Excel lesson 310

Hide appearance of table columns in Power Pivot Manager, Excel lesson 311

Add calendar table to the data model, Excel lesson 312

Adding Pivot Tables and Charts from Power Pivot Manager, Excel lesson 313

Synonyms are used to easily eliminate demand in different terminology, Excel lesson 314

Import the file into a worksheet in Excel, lesson 315

Power Query Editor filter the entry we don't need, Excel lesson 316

Remove the column in the query Power Query Editor, Excel lesson 317

Getting two new columns from one query column has been split Power Query Editor, Excel lesson 318

Change the name of the column in the query Power Query Editor, Excel lesson 319

Change the type of the column in the query Power Query Editor, Excel lesson 320

Create a new column, column minus column Power Query Editor, Excel lesson 321

Add a number to all values in a column Power Query Editor, Excel lesson 322

Get a new column with math operations on another column Power Query Editor, Excel lesson 323

Add a column using the if operator Power Query Editor, Excel lesson 324

Add an index column to the query Power Query Editor, Excel lesson 325

Convert text to uppercase in a query column Power Query Editor, Excel lesson 326

Ways to influence the text of a query column Power Query Editor, Excel lesson 327

Combine query columns Power Query Editor, Excel lesson 328

Different Ways to Affect Query Column Data Power Query Editor, Excel lesson 329

Split date column Power Query Editor, Excel lesson 330

View Power Query Editor functions, Excel lesson 331

Move the query from the Power Query Editor to the Excel sheet, lesson 332

Hide or show query columns, Power Query Editor, Excel lesson 333

Grouping of query, Power Query Editor, Excel lesson 334

Navigate between the sheet and Power Query, display query settings on the sheet, Excel lesson 335

Ways to influence rows in a query, Power Query Editor, Excel lesson 336

Replace column values, Power Query Editor, Excel lesson 337

The data source of query and access rights, Power Query Editor, Excel lesson 338

Add new Data source, Power Query Editor, Excel lesson 339

Change query properties, update rate, connection type, Power Query Editor, Excel lesson 340

Exporting a query file, Power Query Editor, Excel lesson 341

Duplicate a query, Power Query Editor, Excel lesson 342

Create a new query based on the existing query, Power Query Editor, Excel lesson 343

Combine existing queries or add one to the other, Power Query Editor, Excel lesson 344

A query submitted with Power Query , Excel lesson 345

Index function in Excel, lesson 346

How to create difficult if logic in Excel, lesson 347

How to extract information from illogical (difficult) lists, Excel lesson 348

importing and merging files into excel from a folder, lesson 349

How to create tests in Excel and Google sheets, lesson 350