Contents
Excel Tutorial for Dummies will allow you to easily understand and master the basic skills of working in Excel, so that you can confidently move on to more complex topics. The tutorial will teach you how to use the Excel interface, apply formulas and functions to solve a variety of problems, build graphs and charts, work with pivot tables and much more.
The tutorial was created specifically for novice Excel users, more precisely for “complete dummies”. Information is given in stages, starting with the very basics. From section to section of the tutorial, more and more interesting and exciting things are offered. After completing the entire course, you will confidently apply your knowledge in practice and learn how to work with Excel tools that will solve 80% of all your tasks. And most importantly:
- You will forever forget the question: “How to work in Excel?”
- Now no one will ever dare to call you a “teapot”.
- No need to buy useless tutorials for beginners, which will then gather dust on the shelf for years. Buy only worthwhile and useful literature!
- On our site you will find many more different courses, lessons and manuals for working in Microsoft Excel and not only. And all this in one place!
Section 1: Excel Basics
- Introduction to Excel
- Microsoft Excel interface
- Ribbon in Microsoft Excel
- Backstage view in Excel
- Quick Access Toolbar and Book Views
- Create and open workbooks
- Create and open Excel workbooks
- Compatibility Mode in Excel
- Saving books and sharing
- Save and AutoRecover Workbooks in Excel
- Exporting Excel Workbooks
- Sharing Excel Workbooks
- Cell Basics
- Cell in Excel – basic concepts
- Cell content in Excel
- Copying, moving and deleting cells in Excel
- Autocomplete cells in Excel
- Find and Replace in Excel
- Change columns, rows and cells
- Change column width and row height in Excel
- Insert and delete rows and columns in Excel
- Move and hide rows and columns in Excel
- Wrap text and merge cells in Excel
- Cell Formatting
- Font setting in Excel
- Aligning text in Excel cells
- Borders, shading and cell styles in Excel
- Number formatting in Excel
- Excel Sheet Basics
- Rename, insert and delete a sheet in Excel
- Copy, move and change the color of a worksheet in Excel
- Grouping sheets in Excel
- Page layout
- Formatting margins and page orientation in Excel
- Insert page breaks, print headers and footers in Excel
- Book printing
- Print panel in Microsoft Excel
- Set the print area in Excel
- Setting margins and scale when printing in Excel
Section 2: Formulas and Functions
- Simple Formulas
- Math operators and cell references in Excel formulas
- Creating Simple Formulas in Microsoft Excel
- Edit formulas in Excel
- Complex formulas
- Introduction to complex formulas in Excel
- Creating complex formulas in Microsoft Excel
- Relative and absolute links
- Relative links in Excel
- Absolute references in Excel
- Links to other sheets in Excel
- Formulas and Functions
- Introduction to Functions in Excel
- Inserting a Function in Excel
- Function Library in Excel
- Function Wizard in Excel
Section 3: Working with data
- Worksheet Appearance Control
- Freezing regions in Microsoft Excel
- Split sheets and view Excel workbook in different windows
- Sort data in Excel
- Filtering data in Excel
- Working with groups and debriefing
- Groups and Subtotals in Excel
- Tables in Excel
- Create, modify and delete tables in Excel
- Charts and Sparklines
- Charts in Excel – Basics
- Layout, Style, and Other Chart Options
- How to work with sparklines in Excel
Section 4: Advanced features of Excel
- Working with Notes and Tracking Changes
- Track revisions in Excel
- Review revisions in Excel
- Cell comments in Excel
- Completing and Protecting Workbooks
- Shut down and protect workbooks in Excel
- Conditional Formatting
- Conditional Formatting in Excel
- Pivot tables and data analysis
- Introduction to PivotTables in Excel
- Data Pivot, Filters, Slicers, and PivotCharts
- What if analysis in Excel
Section 5: Advanced Formulas in Excel
- We solve problems using logical functions
- How to set a simple boolean condition in Excel
- Using Excel Boolean Functions to Specify Complex Conditions
- IF function in Excel with a simple example
- Counting and summing in Excel
- Count cells in Excel using COUNTIF and COUNTIF functions
- Sum in Excel using the SUM and SUMIF functions
- How to calculate the cumulative total in Excel
- Calculate weighted averages using SUMPRODUCT
- Working with dates and times in Excel
- Date and time in Excel – basic concepts
- Entering and formatting dates and times in Excel
- Functions to extract various parameters from dates and times in Excel
- Functions to create and display dates and times in Excel
- Excel functions for calculating dates and times
- Search data
- VLOOKUP function in Excel with simple examples
- VIEW function in Excel with a simple example
- INDEX and MATCH functions in Excel with simple examples
- Good to know
- Excel Statistical Functions You Need to Know
- Excel math functions you need to know
- Excel text functions in examples
- Overview of errors that occur in Excel formulas
- Working with names in Excel
- Introduction to cell and range names in Excel
- How to name a cell or range in Excel
- 5 Useful Rules and Guidelines for Creating Cell and Range Names in Excel
- Name Manager in Excel – Tools and Features
- How to name constants in Excel?
- Working with arrays in Excel
- Introduction to array formulas in Excel
- Multicell array formulas in Excel
- Single cell array formulas in Excel
- Arrays of constants in Excel
- Editing array formulas in Excel
- Applying array formulas in Excel
- Approaches to editing array formulas in Excel
Section 6: Optional
- Interface customization
- How to customize the Ribbon in Excel 2013
- Tap mode of the Ribbon in Excel 2013
- Link styles in Microsoft Excel
Want to learn more about Excel? Especially for you, we have prepared two simple and useful tutorials: 300 Excel examples and 30 Excel functions in 30 days.