About This Class This is class #1 in a series called the Ultimate Excel Course. When you first start to learn Excel, the formulas are always the most daunting aspect. This class will break through those barriers as it explains everything you need to know to get started with Excel formulas in plain English. In just 1 hour you will understand the different parts that make up a formula and will be able to write some typical formulas and functions. This class builds a solid foundation for further learning from other classes, or from your everyday work. The Excel Formulas for Beginners files are provided in the Projects section of this class to download, so that you may follow me through each lesson. There are also plenty of project files provided so that you may practice and test the skills that you have learnt. If you have any questions, please do ask through the discussion area. I am happy to help. What you will learn; Please note that this is class #1 in a series called the Ultimate Excel Course. You can find direct links to the other classes in the series below. Class #1 - Excel Formulas Made Easy - Power Up your Excel Formula Skills Fast Class #2 - Essential Skills for Working With Large Spreadsheets Class #3 - Logical Functions - The Decision Making Formulas of Excel Class #4 - Conditional Formatting: Make your Data Come to Life Class #5 - Lookup Functions - The Powerful VLOOKUP Function and Beyond Class #6 - Validating and Protecting Excel Data Class #7 - Advanced Formulas for Analysing Data Class #8 - Excel Charts for Simple and Effective Data Presentation Class #9 - Cleaning and Preparing Data Ready for Analysis Class #10 - Formatting your Data Ranges as Tables for Superior Management Class #11 - Master PivotTables for Powerful Analysis and Reporting Class #12 - Get & Transform Data with Power Query Class #13 - Introduction to the Data Model and PowerPivot
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.