Published 3/2023MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 9.12 GB | Duration: 21h 18m
Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365 Master unique tips & techniques that you won't find in ANY other course, guaranteed Automate, streamline, and completely revolutionize your workflow with Excel Get LIFE access to project files, quizzes, homework exercises, and 1-on-1 expert support Explore fun, interactive, and highly eLearn how to THINK like Excel, and write powerful and dynamic Excel forffective demos from a best-selling Excel instructor Build stunning, professional-quality dashboards in Excel (from scratch!) Apply powerful techniques for transfog raw data into beautiful, interactive visuals Learn the same tools used by professional business intelligence analysts and data scientists Analyzing Data with Business Intelligence (Power Queries and Trendlines) and more ......... Microsoft Excel 2007-2021 or Office 365 (Note: some tips may not apply to all versions of Excel) This course covers 35 sections.Students can learn basic and advanced concepts of Excel in this course.Learn pivottables ,pivotcharts,power query,power pivot,power map,what-if-analysis tools,solver and others topics.Learn how to add charts in Microsoft Excel sheet.Learn how to use formulas and functions in Microsoft Excel .To see more topics of this course,view course contents below.Who this course is for: If someone want to learn excel from basic to Advance,this course covers basic and advance levels topics.Requirements : This course is recorded on excel 2019 but all previous versions 2007,2010,2013,2016 and office 365 will work on this course.If you're looking to master Microsoft Excel, then this comprehensive course is exactly what you need! Whether you're a bner just starting out or an experienced user looking to enhance your skills, this course has everything you need to take your Excel knowledge to the next level.With this course, you'll start with the basics of Excel and quickly progress through more advanced topics, such as data analysis, charts, graphs, pivot tables, macros, and more. You'll learn how to create professional-looking spreadsheets, automate repetitive tasks, and streamline your workflow. Plus, you'll learn tips and tricks that will save you and make your work more efficient.One of the biggest advantages of this course is its accessibility. You can learn at your own pace and on your own schedule. With video tutorials, able practice files, and hands-on exercises, you'll be able to practice what you learn and test your skills every step of the way.The instructor of this course is an expert in Excel with years of experience. He has designed this course to be easy to follow and understand, even for those who have never used Excel before. The lessons are broken down into bite-sized chunks, so you can learn one topic at a and build upon your knowledge as you go.By the end of this course, you'll be able to confidently use Excel for a wide range of tasks. You'll have the skills you need to create complex spreadsheets, analyze data, and present your findings in a clear and concise manner. Whether you're looking to improve your job performance, advance your career, or simply become more proficient with Excel, this course is the perfect choice.Don't wait any longer to start mastering Microsoft Excel. Enroll in this course today and take the first step towards becoming an Excel expert! Section 1: Introduction Lecture 1 Introduction Lecture 2 Excel Tabs,Groups and Commands Lecture 3 Excel Rows and Columns Lecture 4 Chag the Size of Columns and Rows Lecture 5 Entering Text and Numbers in Worksheet Lecture 6 Wrap Text Inside the Cell Lecture 7 Edit Text Within a Cell Lecture 8 Meg and Formatting Cells in a Worksheet Lecture 9 Formatting Header in a Worksheet Lecture 10 Adding Image in a Worksheet Lecture 11 Formatting Date in Excel Worksheet Lecture 12 Working of Undo & Redo Commands in an Excel Worksheet Lecture 13 Home Work Section 2: Creating Excel Tables,PivotTables and PivotCharts Lecture 14 Freezing Header or Row Lecture 15 Converting Data in an Excel Table Lecture 16 Adding Records in an Excel Table Lecture 17 Renaming and Finding Records in an Excel Table Lecture 18 Editing and Deleting Records in an Excel Table Lecture 19 Remove Duplicates Lecture 20 Sorting Date Column in an Excel Table Lecture 21 Sorting Multiple Columns Lecture 22 Filtering Data in an Excel Worksheet and Deleting an Excel Table Lecture 23 Filtering Data by Creating Criteria Lecture 24 Filtering Data in an Excel Table by Using Slicer Lecture 25 Splitting the Worksheet into Panes Lecture 26 Calculating Records in an Excel Table Lecture 27 Inserting Subtotals Lecture 28 Creating and Adding Data in a Pivot Table Lecture 29 Filtering Data in a Pivot Table Lecture 30 Adding Pivot Chart in a Pivot Table Lecture 31 Home Work Section 3: Analyzing Sales Data in Pivot Tables and Pivot Charts Lecture 32 Adding Data in Excel Table Lecture 33 Adding and Formatting First Chart in Pivot Table Lecture 34 Adding and Formatting Second Chart in Pivot Table Lecture 35 Adding and Formatting Third Chart in Pivot Table Lecture 36 Adding and Formatting Fourth Chart in Pivot Table Lecture 37 Adding and Formatting Fifth Chart in Pivot Table Lecture 38 Adding and Formatting Sixth Chart in Pivot Table Lecture 39 Adding Chart in Excel Dashboard Lecture 40 Designing Dashboard Layout and Extracting Pivot Tables Data in Text Box Lecture 41 Inserting Slicers in the Dashboard for Analyzing Sales Data Section 4: Data Validation and Inserting Comments Lecture 42 Specifying a Validation Rule by Using List Lecture 43 Displaying Error Alert Message Lecture 44 Show an Input Message on an Active Cell Lecture 45 Circle Invalid Data Lecture 46 Inserting Comments in a Worksheet Lecture 47 Home Work Section 5: Analyzing Data in the Table Lecture 48 Introducing and Converting a Range to a Table Lecture 49 Sorting a Table using Different Methods Lecture 50 Filtering a Table using Different Methods Lecture 51 Analyzing Basic Table Operations Lecture 52 Analyzing Table Data using COUNTIF,SUMIF and AVERAGEIF Functions Section 6: Analyzing Data with PivotTables Lecture 53 Introducing PivotTables Lecture 54 Creating PivotTable Lecture 55 Inserting Subtotals In the PivotTable Lecture 56 Summarizes Value Field by Chag Functions Lecture 57 Adding PivotChart and Slicer in the PivotTable Section 7: Analyzing Data with Business Intelligence (Power Queries and Trendlines) Lecture 58 Introducing Power Query and Upload CSV File Lecture 59 Retrieving Power Query Data into an Excel Table and Editing a Query Data Lecture 60 Adding a New Column and Grouping Values in a Power Query Data Lecture 61 Analyzing Revenue Data by Adding Trendlines in the Chart Section 8: Analyzing Data with Business Intelligence (Forecast Sheet) Lecture 62 Analyzing Revenue Data by Creating a Forecast Sheet Section 9: Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map) Lecture 63 Introducing Database and Upload Access Database File Lecture 64 Creating the Data Model Lecture 65 Transferring Data in the Power Pivot Lecture 66 Exploring the Data Model in the Diagram View Lecture 67 Managing Table Relationships in the Power Pivot Lecture 68 Creating a PivotTable from the Data Model Lecture 69 Adding a line Slicer in the PivotTable Lecture 70 Drilling down into the Data in the PivotTable Lecture 71 Visualizing Stores Sale Data with Power Map Section 10: Extracting Data from the Website(Power Query,Power Pivot,Pivot Table) Lecture 72 Importing Population and Area Data from the Website and Creating Queries Lecture 73 Extracting Population and Area Data into PivotTable Lecture 74 Meg Two Queries into One query Section 11: Loading Website Data into Power Map(Power Query,Power Map) Lecture 75 Loading Website Data into Power Map Section 12: Extracting Data from the Website(Power Query,Pivot Table) Lecture 76 Extracting and Transfog User Rating Data from the Website Lecture 77 Combining Queries Section 13: Extracting Football Team Data from the Website(Power Query,Pivot Table) Lecture 78 1. Extracting and Transfog Data from the Website Section 14: Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table) Lecture 79 Cost-Volume-Profit(CVP) Chart Analysis Lecture 80 Find the Break-Even Point by Using Goal Seek Lecture 81 Generate $30000 Net Income of Company by using Goal Seek Tool Lecture 82 Creating One-Variable Data Table to Examine the Impact of Chag Sales Volume Lecture 83 Completing the One-Variable Data Table Lecture 84 Creating the CVP Chart of the Data Table Lecture 85 Viewing the Impact of Chag the Sales Price in the Data Table Lecture 86 Creating the Two-Variable Data Table Lecture 87 Create a Chart of the Two Variable Data Table Section 15: Analyzing Business Data by using What-If Analysis Tools(Scenario Manager) Lecture 88 Define Names for the Income Statement Values Lecture 89 Adding the Scenarios in the Scenario Manager Lecture 90 View the Impact of the Reduced Operations Scenario Lecture 91 Creating the Scenario Summary Report Lecture 92 Creating the Scenario PivotTable Report Section 16: Analyzing Business Data with Solver Lecture 93 Understand Solver with Simple Example Lecture 94 Introducing Product Mix and Find an Optimal Solution with Solver Part 1 Lecture 95 Introducing Product Mix and Find an Optimal Solution with Solver Part 2 Lecture 96 Creating a Solver Answer Report Lecture 97 Saving and Loading Solver Model Section 17: Calculations With Basic Formulas Lecture 98 Introduction to Arithmetic Operators Lecture 99 Calculations with Arithmetic Operators Lecture 100 Copy and Paste the Formula Lecture 101 Auto Complete Formula Lecture 102 Inserting and Deleting Columns and Rows Lecture 103 Hide and Unhide Columns and Rows Lecture 104 Moving a Cell or Range by Drag and Drop Method Lecture 105 Moving a Cell or Range by Cut and Paste Method Lecture 106 Relative and Absolute Cell References Lecture 107 Home Work Section 18: Calculations with Simple Excel Functions Lecture 108 Introduction to Function Syntax Lecture 109 Calculating Total Sales by Using SUM Function Lecture 110 Calculating Total Sales Quantities by Using SUM Function Lecture 111 Count Price Items by Using COUNT Function Lecture 112 Count Food Items by Using COUNTA Function Lecture 113 Calculating Average Sales by Using AVERAGE Function Lecture 114 Calculating Maximum Sales Value of Customer by Using MAX Function Lecture 115 Calculating Minimum Sales Value of Customer by Using MIN Function Lecture 116 Calculating Total Price of Products by Using PRODUCT Function Lecture 117 Calculating Sales Data by Using Auto FUNCTION Button Lecture 118 Calculating a Tax Rate on Total Sales Lecture 119 Home Work Section 19: Formatting a Worksheet Lecture 120 Meg Two or More Cells into One Cell Lecture 121 Alignment of Cell Text Lecture 122 Splitting Text into Multiple Lines Lecture 123 Rotating a Cell Text or Numbers Lecture 124 Formatting Background Color of Text and Numbers Lecture 125 Formatting Font Size and Font Color Lecture 126 Adding Border into Cells Lecture 127 Formatting Cell Styles Lecture 128 Find and Replace Text in a Worksheet Lecture 129 Calculating Students Enrollment and Difference Between two Columns Values Lecture 130 Calculating Percentage Difference Between two Columns Values Lecture 131 Conditionally Formatting Cells in a Worksheet Lecture 132 Conditionally Formatting Cells with a Top and Bottom Rules Lecture 133 Home Work Section 20: Saving and Printing a Workbook Lecture 134 Saving a Workbook Lecture 135 Worksheet Views,Page Orientation and Scaling Lecture 136 Setting Mas in a Print Page Lecture 137 Adding Header and Footer in a Print Page Lecture 138 Print Preview and Selecting Print Area Lecture 139 Setting Scaling and Mas in a Print Page(Document 1) Section 21: Project Calculations with Operators and Functions Lecture 140 Calculating the Area of Field and Plots Lecture 141 Calculating the Grown and Empty Area of Vegetables Field Lecture 142 Calculating the Percentage of Grown and Empty area in Vegetables Field Lecture 143 Calculating Cost of Sales and Weightages of Vegetables Lecture 144 Calculating Profit and Percentage of Profit from Vegetables Lecture 145 Calculating Revenue by Using Sum,Max,Min,Average and Median Functions Lecture 146 Introduction to NESTED Function Lecture 147 Nesting the SUM and MEDIAN Functions within ROUND Function Lecture 148 Home Work Section 22: IF and VLOOKUP Functions Lecture 149 Introduction to IF Function and Apply Weather Condition on IF Function Lecture 150 Apply Different Conditions on IF Function Lecture 151 Introduction to VLOOKUP Function Lecture 152 Apply VLOOKUP Function on Data Table Lecture 153 Retrieving Values from Data Table by Using VLOOKUP Function Lecture 154 Errors in VLOOKUP Function Lecture 155 Home Work Section 23: Adding Column and Pie Charts in an Excel worksheet Lecture 156 Embed Column Chart in a Worksheet Lecture 157 Analyzing Data with a Column Chart Lecture 158 Analyzing Data with a Pie Chart Lecture 159 Recommended Charts Lecture 160 Home Work Section 24: Date and Functions in an Excel Lecture 161 NOW and Functions Lecture 162 HOUR,MINUTE and SECOND Functions Lecture 163 TODAY,DATE and DAYS Functions Lecture 164 YEAR,MONTH and DAY Functions Lecture 165 WEEKDAY Function Lecture 166 WEEKNUM Function Lecture 167 EDATE Function Lecture 168 EOMONTH Function Lecture 169 Deteing Person's Birthday Lecture 170 Calculating Age of Person Lecture 171 Formatting Date in a Cell Lecture 172 DATEVALUE Function Lecture 173 DAYS360 Function Lecture 174 ISOWEEKNUM Function Lecture 175 NETWORKDAYS Function Lecture 176 VALUE Function Lecture 177 YEARFRAC Function Section 25: Logical Functions in an Excel Lecture 178 Calculating the Age of Employees and Length of Service Lecture 179 Analyzing Data by Using IF Function Lecture 180 Deteing Birthday of Employees Lecture 181 Specifying Day of Birthdate by Nesting DAY Function Within IF Function Lecture 182 Deteing Employee Eligibility for Promotion by Using AND Function Lecture 183 Nesting the AND Function Within IF Function Lecture 184 Deteing Employee Eligibility for Promotion by Using OR Function Lecture 185 Nesting the OR Function Within IF Function Lecture 186 IFERROR Function Lecture 187 IFNA Function Lecture 188 FALSE Function Lecture 189 IFS Function Lecture 190 NOT Function Lecture 191 SWITCH Function Lecture 192 TRUE Function Lecture 193 XOR Function Lecture 194 Home Work Section 26: Lookup and Reference Functions in an Excel Lecture 195 Extracting Value from Data Table by Using VLOOKUP Function Lecture 196 Extracting Value from Data Table by Using HLOOKUP Function Lecture 197 Calculating Discount and Total Price Lecture 198 Calculating Tax Rate on Total Price Value Lecture 199 Extracting Value by Using CHOOSE Function Lecture 200 Nesting the CHOOSE Function Within Sum Function Lecture 201 MATCH Function Lecture 202 Extracting Value by Using INDEX Function Lecture 203 Nesting the MATCH Function Within an INDEX Function Lecture 204 Nesting the VLOOKUP Function Within an IFERROR Function Lecture 205 COLUMN Function Lecture 206 LOOKUP Function Lecture 207 TRANSPOSE Function Lecture 208 Home Work Section 27: Adding Line and Combination Charts in an Excel Lecture 209 Adding and Formatting Line Chart Lecture 210 Adding and Formatting Combination Chart Section 28: Text Functions in an Excel Lecture 211 BHATTEXT Function Lecture 212 CHAR Function Lecture 213 CLEAN Function Lecture 214 CODE Function Lecture 215 CONCAT Function Lecture 216 DOLLAR Function Lecture 217 EXACT Function Lecture 218 FIND Function Lecture 219 FIXED Function Lecture 220 LEFT Function Lecture 221 LEN Function Lecture 222 LOWER Function Lecture 223 MID Function Lecture 224 NUMBERVALUE Function Lecture 225 PROPER Function Lecture 226 REPLACE Function Lecture 227 REPT Function Lecture 228 RIGHT Function Lecture 229 SEARCH Function Lecture 230 SUBSTITUTE Function Lecture 231 T Function Lecture 232 TEXT Function Lecture 233 TEXTJOIN Function Lecture 234 TRIM Function Lecture 235 UNICHAR Function Lecture 236 UNICODE Function Lecture 237 UPPER Function Lecture 238 VALUE Function Section 29: Math and Trigonometry Functions in an Excel Lecture 239 SUM Function Lecture 240 MOD Function Lecture 241 POWER Function Lecture 242 SUBTOTAL Function Lecture 243 SUMIF Function Lecture 244 SUMIFS Function Lecture 245 SUMPRODUCT Function Lecture 246 ROUND Function Lecture 247 ROUNDDOWN Function Lecture 248 ROUNDUP Function Lecture 249 CEILING.MATH Function Lecture 250 FLOOR.MATH Function Lecture 251 EVEN Function Lecture 252 ODD Function Lecture 253 INT Function Lecture 254 TRUNC Function Section 30: Statistical Functions in an Excel Lecture 255 AVERAGE Function Lecture 256 AVERAGEIF Function Lecture 257 AVERAGEIFS Function Lecture 258 COUNT and COUNTA Function Lecture 259 COUNTBLANK Function Lecture 260 COUNTIF Function Lecture 261 COUNTIFS Function Lecture 262 LARGE Function Lecture 263 SMALL Function Lecture 264 MAX and MIN Function Lecture 265 MEDIAN Function Lecture 266 MODE.MULT Function Lecture 267 MODE.SNGL Function Section 31: Eeering Functions in an Excel Lecture 268 BIN2DEC Function Lecture 269 BIN2HEX Function Lecture 270 BIN2OCT Function Lecture 271 COMPLEX Function Lecture 272 CONVERT Function Lecture 273 DEC2BIN Function Lecture 274 DEC2HEX Function Lecture 275 DEC2OCT Function Section 32: Information Functions in an Excel Lecture 276 CELL Function Lecture 277 ERROR.TYPE Function Lecture 278 INFO Function Lecture 279 ISBLANK Function Lecture 280 ISERR Function Lecture 281 ISERROR Function Lecture 282 ISEVEN Function Lecture 283 ISFORMULA Function Lecture 284 ISLOGICAL Function Lecture 285 ISNA Function Lecture 286 ISNONTEXT Function Lecture 287 ISNUMBER Function Lecture 288 ISODD Function Lecture 289 ISREF Function Lecture 290 ISTEXT Function Lecture 291 N Function Lecture 292 NA Function Lecture 293 SHEET Function Lecture 294 SHEETS Function Lecture 295 TYPE Function Section 33: Database Functions in an Excel Lecture 296 DAVERAGE Function Lecture 297 DSUM Function Lecture 298 DMAX and DMIN Functions Lecture 299 DCOUNTA Function Section 34: Financial FunctionsBorrow Money to Bank Lecture 300 Calculating a Quarterly Payment of Loan by using the PMT Function Lecture 301 Calculating a Future Value of Loan by using the FV Function Lecture 302 Calculating a Payment Period of Loan by using the NPER Function Lecture 303 Calculating a Present Value of Loan by using the PV Function Lecture 304 Calculating an Interest Rate of Loan by using the RATE Function Lecture 305 Positive Cash Flow and Negative Cash Flow Lecture 306 Calculating the Value of Inflation by Using FV Functio Lecture 307 Calculating a Monthly Car Payment Lecture 308 Calculating the Interest Payment by using IPMT Function Lecture 309 Calculating the Principal Payment by using PPMT Function Lecture 310 Calculating Remaining Principal Amount and Total Payment Lecture 311 Completing the Amortization Schedule of Loan Lecture 312 Plotting Interest and Principal Payments Lecture 313 Calculating Cumulative Interest Payments by Using CUMIPMT Function Lecture 314 Calculating Cumulative Principal Payments by Using CUMPRINC Function Lecture 315 Calculating Remaining Principal,Total Interest and Total Principal Payments Lecture 316 Calculating Total Loan Amount Section 35: Financial FunctionsInvest Money in the Bank Saving Account Lecture 317 Calculating the Compound Interest Lecture 318 Calculating Nominal and Effective Interest Rates Using NOMINAL&EFFECT Functions Lecture 319 Calculating the Future Value of an Investment by Monthly and Initial Deposits Lecture 320 Calculating the Interest Rate of an Investment Lecture 321 Calculating the Total Number of Deposits of an Investment Lecture 322 Calculating the Initial Deposit or Present Value of an investment Lecture 323 Calculating the Value of Deposit Per Month Lecture 324 Calculating the Variable Interest Rates by using FVSCHEDULE Function Lecture 325 Amortization Schedule of an Investment 1 Lecture 326 Amortization Schedule of an Investment 2 Section 36: Financial FunctiomsBuild Future Income Statement of Company Lecture 327 Introduction to Income Statement Worksheet Lecture 328 Linear and Growth Trend Values Lecture 329 Projecting Future Value of Sales or Revenue by using Linear Trend Option Lecture 330 Projecting Future Value of Sales or Revenue by Inserting a Growth Trend Lecture 331 Calculating the Cost of Research and Development Lecture 332 Calculating the Cost of Sales and Marketing Lecture 333 Calculating the Gross Profit Lecture 334 Calculating the Expenses of Company Part 1 Lecture 335 Calculating the Expenses of Company Part 2 Lecture 336 Calculating the Expenses of Company Part 3 Lecture 337 Calculating the Total General Expenses and Initial Earnings Lecture 338 Adding Depreciation of an Asset in the Income Statement Lecture 339 Calculating Operating Profit in the Income Statement Lecture 340 Adding Interest Expenses in the Income Statement Lecture 341 Calculating Profit Without Adding Tax Lecture 342 Adding Taxes in the Income Statement Lecture 343 Calculating Final Profit of the Company in the Income Statement Section 37: Financial FunctionsCalculate Depreciation of an Asset of Company Lecture 344 Straight Line Depreciation of an Asset Part 1 Lecture 345 Straight Line Depreciation of an Asset Part 2 Lecture 346 Straight Line Depreciation of an Asset Part 3 Lecture 347 Declining Balance Depreciation of an Asset Part 1 Lecture 348 Declining Balance Depreciation of an Asset Part 2 Lecture 349 Calculating Depreciation of an asset by Using SYD Function Lecture 350 Calculating Depreciation of an asset by Using DDB Function Lecture 351 Calculating Depreciation of an asset by Using VDB Function Lecture 352 Calculating Depreciation Value of a Car Lecture 353 Selecting Method of Depreciation to Calculate Depreciation of an Asset Section 38: Financial FunctionsInvest Money in Company Lecture 354 Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 1 Lecture 355 Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 2 Lecture 356 Calculating Payback Period of an Investment Part 1 Lecture 357 Calculating Payback Period of an Investment Part 2 Lecture 358 Calculating Payback Period of an Investment Part 3 Lecture 359 Calculate Present Value of an Invetment by Using NPV Function Part 1 Lecture 360 Calculate Present Value of an Invetment by Using NPV Function Part 2 Lecture 361 Calculate Net Present Value of an Invetment Lecture 362 Calculate Internal Rate of Return of an Invetment by Using IRR Function Lecture 363 Calculate Net Present Value & Internal Rate of Return using XNPV & XIRR Functons Lecture 364 Calculate Equivalent Value of Interest Rate by Using RRI Function Section 39: Basic Financial Examples(Learn Use of Operators +,-,,) Lecture 365 Calculating the Remaining Amount with 30% Rate Lecture 366 Calculating the Remaining Amount with 15% and 40% Rate Lecture 367 Calculating the Percentage of Remaining Amount Lecture 368 Calculating the Percentage of Savings Lecture 369 Finding the Value of Actual Amount Lecture 370 Calculating the Value of Expense,Save and Total Amount Lecture 371 Calculating the Remaining Profit Lecture 372 Calculating the Values of Profit and Percentage of Profit Lecture 373 Calculating the Values of Loss and Percentage of Loss Anyone looking to pursue a career in data analysis, finance, eeering and business intelligence,Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level,recommended for absolute bners and also for experts HomePage: gfxtra__MicrosoftE.part01.rar.html gfxtra__MicrosoftE.part02.rar.html gfxtra__MicrosoftE.part03.rar.html gfxtra__MicrosoftE.part04.rar.html gfxtra__MicrosoftE.part05.rar.html gfxtra__MicrosoftE.part06.rar.html gfxtra__MicrosoftE.part07.rar.html gfxtra__MicrosoftE.part08.rar.html
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.