Reply to thread

Message: <blockquote data-quote="sarinda100" data-source="post: 13633757" data-attributes="member: 267712"><img src="http://i742.photobucket.com/albums/xx68/aylpic/AYL%20Pics%202/TotalTrainingExcel2010.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" />Complete 2 Award-Winning Training  Courses. Total Training Microsoft Excel 2010 ESSENTIALS and ADVANCED  TRAINING COURSES. Project Files are Included. ESSENTIALS –  This series is for anyone who wants to know Excel in a non-intimidating,  soup-to-nuts manner. If you’ve never used Excel, this is your starting  point. No prior experience is necessary. If you’ve used Excel but never  had formal training, this course will fill in the gaps so it all makes  sense and so you are efficient and accurate. If you’ve used previous  versions of Excel (prior to Office 2007) then there are a lot of  features and changes you need to be aware of to fully utilize this  software. In this course we take you from start to finish including  entering data, configuring workbooks, working with calculations,  applying regular and conditional formatting, creating custom formats,  using names, leveraging the power of tables and charts and outputting  your work. These are the skills every Excel user needs to know no matter  how new or how experienced you may be! Highlights1. Break down Excel into its component parts to make it more manageable and less overwhelming2. Use common, understandable names to replace confusing cell references3. Apply traditional formatting, create custom formats and apply  formatting that automatically changes based on conditions you designate4. Truly understand how formulas and functions work, no matter how seemingly simple or complex5. Learn the Commandments of Excel Usageâ„¢ to ensure your work is efficient and accurate6. Embrace the power of tables to sort, filter and manage data more easily7. Create charts with just one click Chapter 1: GETTING COMFORTABLE WITH EXCEL (51 min)1. Introducing Excel2. Recognizing Interface Features Unique to Excel3. Understanding Workbook Structure4. Navigating through Workbooks5. Making Workbook Selections Chapter 2: THE BASICS OF DATA (41 min)1. Entering Text2. Entering Dates & Numbers3. Editing Cell Entries4. Copying & Moving Data5. Filling a Series Chapter 3: MANAGING WORKBOOK STRUCTURE (28 min)1. Modifying Workbook & Worksheet Structure2. Resizing Worksheet Elements3. Hiding Workbook Components Chapter 4: CREATING FORMULAS (33 min)1. Excel Calculations 1012. Entering Formulas3. Enforcing Absolute Referencing4. Controlling Calculation Options Chapter 5: THE BASICS OF FUNCTIONS (26 min)1. The Foundation of Functions2. Using AutoSum & the Formulas Tab3. Using Function AutoComplete Chapter 6: WHAT’S IN A NAME? (43 min)1. Creating Named Cells2. Dening Names3. Creating Names from Selections4. Creating Named Formulas5. Using Names as References6. Managing & Displaying Names Chapter 7: MAKING DATA LOOK GOOD (74 min)1. Applying Basic Formatting2. Formatting Numbers3. Exploring the Format Cells Dialog Box4. Dening Custom Formats5. Creating & Applying Cell Styles6. Conditional Formatting7. Applying & Editing Conditional Formatting Rules Chapter 8 A PICTURE IS WORTH A THOUSAND WORDS (38 min)1. Getting In-Cell Summaries with Sparklines2. Creating Charts3. Modifying Chart Design4. Working with Chart Layout & Format5. Saving & Using a Chart Template Chapter 9 THE SIMPLICITY OF TABLES (54 min)1. Converting Data Ranges to Tables2. Modifying Table Formatting3. Working with Table Records4. Using Table Calculations5. Sorting Data6. Creating Custom Lists7. Filtering Data Chapter 10 MANAGING THE EXCEL ENVIRONMENT (20 min)1. Conguring Excel Options2. Adjusting the View3. Controlling Excel Windows Chapter 11 PREPARING FILES FOR DISTRIBUTION (23 min)1. Print Area, Print Titles & Sheet Options2. Renaming Sheets & Adding Headers/Footers3. Printing Worksheets4. Credits ADVANCED -  Microsoft Excel. It’s a mainstay for many Office users. Unfortunately,  many people know the BASICS of spreadsheets but they never get to the  next level, integrating and advancing basic skills to escalate  worksheets to elegant, powerful solutions. In this series, new and  longtime Excel users will learn how to take core skills to the next  level by exploring advanced functions and chart features, connecting to  external data, utilizing data tools, leveraging auditing features and  gaining insight with what-if features. You’ll also learn how to create  macros and work with basic VBA code to customize and automate your work.  Does EVERY Excel user need to know these skills? No. But if you want to  use Excel beyond simple data entry and calculations to its fullest  potential and therefore be able to reach your own full potential, this  series will help get you there. Highlights1. Take basic Excel skills to the next level by integrating and extending basic skills to create elegant solutions2. See how advanced functions and data tools automate routine tasks and provide easy answers to not-so-easy questions3. Discover the power of simplifying complex data through advanced charts and pivot tables4. Audit calculations, manage errors and ask find answer to your “what if…” questions5. Import & connect to external data6. Create macros and make simple edits using VBA to automate routine tasks Chapter 1: ADVANCED CALCULATIONS (97 min)1. Using Lookup Functions2. Using Text Functions3. Breaking Apart Text Entries4. Using Date & Time Functions5. Using the Net Workdays Function6. Using Logical Functions & Fixing Errors7. Using Text in Calculations8. Using Financial Functions9. Using the Cumulative Interest Payment Function10. Using Aggregate vs. Math Functions Chapter 2: SUBTOTALS & OUTLINES (25 min)1. Creating Subtotals2. Working with Outlined Data3. Manually Creating Subtotals & Outlines4. Creating Custom Views Chapter 3: PIVOTTABLES© (57 min)1. Constructing PivotTables2. Modifying PivotTable Calculations3. Setting PivotTable Properties4. Using Filters & Slicers in the PivotTable5. Using the Report Filter & Updating Data6. Working with PivotTable Data in Formulas & PivotCharts Chapter 4: ADAPTING CHARTS FOR COMPLEX DATA (19 min)1. Adding a Secondary Chart Axis2. Working with a Scatter Chart3. Hidden & Empty Cell Settings, Formatting Error Bars4. Adding a Trendline Chapter 5: ADVANCED DATA TOOLS (44 min)1. Importing Data & Adding Hyperlinks2. Converting Text to Columns3. Linking to Databases & Removing Duplicate Records4. Consolidating Data5. Validating & Protecting Data Chapter 6: AUDITING CALCULATED VALUES (34 min)1. Working with Circular References2. Tracing Precedents & Dependents3. Evaluating Formulas4. Using the Watch Window5. Error Checking Chapter 7: PERFORMING A WHAT-IF ANALYSIS (28 min)1. Finding an Input Value with Goal Seek2. Displaying Options via Scenarios3. Including Variable Values through Data Tables Chapter 8: MACROS, VBA & SECURITY 60 min)1. Macro Concepts2. Creating a Basic Macro3. Manipulating Cell & Range References4. A Brief Introduction to VBA5. Viewing & Editing VBA in Excel6. Making Macros Accessible7. Applying Security Settings8. Credits. RAREFILE <a href="http://www.rarefile.net/6vt6ug6bamud/TT.Excel2010.part01.rar" target="_blank">http://www.rarefile.net/6vt6ug6bamud/TT.Excel2010.part01.rar</a> <a href="http://www.rarefile.net/bgjrmxft72n5/TT.Excel2010.part02.rar" target="_blank">http://www.rarefile.net/bgjrmxft72n5/TT.Excel2010.part02.rar</a> <a href="http://www.rarefile.net/iz516kpblwwq/TT.Excel2010.part03.rar" target="_blank">http://www.rarefile.net/iz516kpblwwq/TT.Excel2010.part03.rar</a> <a href="http://www.rarefile.net/j0zeu5fz8t47/TT.Excel2010.part04.rar" target="_blank">http://www.rarefile.net/j0zeu5fz8t47/TT.Excel2010.part04.rar</a> <a href="http://www.rarefile.net/8ugg7f0hoca8/TT.Excel2010.part05.rar" target="_blank">http://www.rarefile.net/8ugg7f0hoca8/TT.Excel2010.part05.rar</a> <a href="http://www.rarefile.net/g2ox9j1xbdo4/TT.Excel2010.part06.rar" target="_blank">http://www.rarefile.net/g2ox9j1xbdo4/TT.Excel2010.part06.rar</a> <a href="http://www.rarefile.net/ytnh1jn4mgz9/TT.Excel2010.part07.rar" target="_blank">http://www.rarefile.net/ytnh1jn4mgz9/TT.Excel2010.part07.rar</a> <a href="http://www.rarefile.net/xv2djfmk3w76/TT.Excel2010.part08.rar" target="_blank">http://www.rarefile.net/xv2djfmk3w76/TT.Excel2010.part08.rar</a> <a href="http://www.rarefile.net/2mdd292otedp/TT.Excel2010.part09.rar" target="_blank">http://www.rarefile.net/2mdd292otedp/TT.Excel2010.part09.rar</a> <a href="http://www.rarefile.net/xk3spjgcxwpd/TT.Excel2010.part10.rar" target="_blank">http://www.rarefile.net/xk3spjgcxwpd/TT.Excel2010.part10.rar</a> <a href="http://www.rarefile.net/why0aezysg8i/TT.Excel2010.part11.rar" target="_blank">http://www.rarefile.net/why0aezysg8i/TT.Excel2010.part11.rar</a> <a href="http://www.rarefile.net/qjlvksmyyrlj/TT.Excel2010.part12.rar" target="_blank">http://www.rarefile.net/qjlvksmyyrlj/TT.Excel2010.part12.rar</a> <a href="http://www.rarefile.net/ag8fodtd7u5u/TT.Excel2010.part13.rar" target="_blank">http://www.rarefile.net/ag8fodtd7u5u/TT.Excel2010.part13.rar</a> <a href="http://www.rarefile.net/akbowhtzw1wv/TT.Excel2010.part14.rar" target="_blank">http://www.rarefile.net/akbowhtzw1wv/TT.Excel2010.part14.rar</a> . EXTABIT <a href="http://extabit.com/file/27awtn63jq29y/TT.Excel2010.part01.rar" target="_blank">http://extabit.com/file/27awtn63jq29y/TT.Excel2010.part01.rar</a> <a href="http://extabit.com/file/27awtn63m7vmu/TT.Excel2010.part02.rar" target="_blank">http://extabit.com/file/27awtn63m7vmu/TT.Excel2010.part02.rar</a> <a href="http://extabit.com/file/27awtn63m7p6e/TT.Excel2010.part03.rar" target="_blank">http://extabit.com/file/27awtn63m7p6e/TT.Excel2010.part03.rar</a> <a href="http://extabit.com/file/27awtn63j4112/TT.Excel2010.part04.rar" target="_blank">http://extabit.com/file/27awtn63j4112/TT.Excel2010.part04.rar</a> <a href="http://extabit.com/file/27awtn63m7fo6/TT.Excel2010.part05.rar" target="_blank">http://extabit.com/file/27awtn63m7fo6/TT.Excel2010.part05.rar</a> <a href="http://extabit.com/file/27awtn63igl86/TT.Excel2010.part06.rar" target="_blank">http://extabit.com/file/27awtn63igl86/TT.Excel2010.part06.rar</a> <a href="http://extabit.com/file/27awtn63ihk2e/TT.Excel2010.part07.rar" target="_blank">http://extabit.com/file/27awtn63ihk2e/TT.Excel2010.part07.rar</a> <a href="http://extabit.com/file/27awtn63m7sdy/TT.Excel2010.part08.rar" target="_blank">http://extabit.com/file/27awtn63m7sdy/TT.Excel2010.part08.rar</a> <a href="http://extabit.com/file/27awtn63igl6u/TT.Excel2010.part09.rar" target="_blank">http://extabit.com/file/27awtn63igl6u/TT.Excel2010.part09.rar</a> <a href="http://extabit.com/file/27awtn63m7fnq/TT.Excel2010.part10.rar" target="_blank">http://extabit.com/file/27awtn63m7fnq/TT.Excel2010.part10.rar</a> <a href="http://extabit.com/file/27awtn63htxqe/TT.Excel2010.part11.rar" target="_blank">http://extabit.com/file/27awtn63htxqe/TT.Excel2010.part11.rar</a> <a href="http://extabit.com/file/27awtn63ihakm/TT.Excel2010.part12.rar" target="_blank">http://extabit.com/file/27awtn63ihakm/TT.Excel2010.part12.rar</a> <a href="http://extabit.com/file/27awtn63igi5i/TT.Excel2010.part13.rar" target="_blank">http://extabit.com/file/27awtn63igi5i/TT.Excel2010.part13.rar</a> <a href="http://extabit.com/file/27awtn63ih10m/TT.Excel2010.part14.rar" target="_blank">http://extabit.com/file/27awtn63ih10m/TT.Excel2010.part14.rar</a></blockquote>

Verification: Hath warak paha keeyada? (hatha wadikireema paha)

Top Bottom