In this book, you will understand a step-by-step method to learn:

• Basic Components of Excel such as why should you learn Excel, where can you get it, and how to start it
• The Basics of Microsoft Excel such as how to insert rows, columns, autofil, filters and more
• Tips on how to use the formula functions correctly, including the basic math operations such as sum, division, percentage, and how to use the random number generator
• How to apply the different Excel text functions like the CONCATENATE, TRIM, SEARCH FUNCTION, TEXTJOIN FUNCTION, and more
• The different logic, counting, and conditional functions like the MAX & MIN, NOT FUNCTION, COUNTIF, COUNTA, AVERAGE IF, SUMIFS FUNCTION, and more
• How to make the most of the date & time functions such as weekday, date, today & now, workday, and more
• The different functions of entering and managing data like the entering data, auto fill and moving data
• What to do when encountering Excel problems like formulas are not working, hashes in cell and functions to manage errors such as IF ERROR, IFNA
• The different methods of creating pivot tables, formatting tables, charts, and graphs
• Latest Features of MS Excel 2021, tips and tricks to master them