More DiscountTotal Training Online: All-Access Library The All Access library gives you access to every online training title! With aprprox. hours and titles to choose from, you're sure to find a lesson to help you master a new technique or learn a new program entirely. This is perfect for creative pros, designers, developers, office enthusiasts who need to master a new technique, or learn an entire program.
We offer various licenses/editions for Total Training Online Subscriptions. Save 40% off with the coupon code: spring40, as shown below:
Note: Once entered Online Store, please Select your license and Fill the quantity into the blank to purchase this product. (1 is default)
Click "Get It Now" Button above or below to activate this coupon code or deal. It's only valid on SoftCns.com If The Coupon Code Not Available Please bookmark this page first, and then clear the cookies of your browser. Lastly, restart your browser again or try to use another web browser, If you don't get it clearly, please visit Coupon Using Guide or send us expired.
Description: Learning to use Microsoft Excel has never been this simple. Our video tutorials quickly and thoroughly walk you step-by-step through all aspects Excel offers. This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time!
Highlights • Explore the new user interface in Office Excel 2007 to find powerful tools when you need them. • Learn how to import, organize, and explore massive data sets in spreadsheets. • Discover how to quickly format cells and tables the way you want. • Improve spreadsheet analysis and communicate your findings in professional-looking charts. • See how to adjust page margins, and add or edit headers and footers, so your spreadsheet prints exactly as you'd like.
Chapter 1: WORKING WITH THE USER INTERFACE (25 min) • Introducing the Ribbon User Interface • Introducing Workbooks & Worksheets • Introducing the Formula Bar • Saving with Different File Extensions • Customizing the User Interface
Chapter 2: ENTERING & MANAGING DATA (47 min) • Getting Data into Excel • Importing Text Files • Using the Freeze Panes Functionality • Using the Zoom Functionality • Using Hot Keys • Managing Rows & Columns • Finding Data • Matching Case & Entire Cell Contents • Replacing Data • Finding & Replacing Empty Values • Sorting Data • Sorting Multiple Columns • Filtering Data
Chapter 3: USING FORMATTING TECHNIQUES (23 min) • Formatting Numbers & Dates • Formatting Cells • Setting the Font Type, Color & Size • Using Borders & Cell Styles • Adding Shapes & Pictures • Creating WordArt
Chapter 4: Formula Basics (34 min) • Constants, Formulas & Cell References • Understanding the Order of Operations • Using Formulas with Dates & Text • Linking Cells & Using Comparison Operators • Creating an Absolute Reference • Defining Named Ranges • Exploring the Function Library • Using the AutoSum Function
Chapter 5: USEFUL FUNCTIONS (40 min) • Using the INT Function • Using the Rounding Function • Using the ABS Function • Using the SUBTotal Function • Using Logical Functions • Using the AND & the OR Function • Using LEFT, RIGHT & MID Functions • Using the UPPER, LOWER, PROPER & TRIM Functions • Using COUNT Functions • Using the VLOOKUP Function
Chapter 6: CREATING REPORTS (33 min) • Creating a Subtotal Report • Using Conditional Formatting • Creating & Managing Conditions • Creating a Chart • Refining Charts • Using Basic Chart Types
Chapter 7: SHARING & DISTRIBUTING YOUR WORK (25 min) • Inserting Headers & Footers • Adding Comments • Adjusting Page Layout • Distributing Your Worksheets • Protecting Your Worksheets • Understanding Compatibility
Chapter 8: TIPS & TRICKS (53 min) • Using the Fill Handle • Filling in a Series of Numbers • Typing in Multiple Cells at Once • Leveraging a Custom List & Transposing a Range • Deleting & Inserting Blank Cells • Filling Holes in Your Data • Getting a List of Unique Records & Parsing Text • Rearranging Columns & Linking to Multiple Cells • Using Right Mouse Button Drag Options • Make Format Painter Persist & Paste Special Formats • Formatting Portions of Text & Multiple Sheets • Creating Cell Border Effects & Sorting on Color • Turning Formulas into Hard Data • Copy Formula References & Highlight Formulas • Creating Dynamic Charts & Combination Charts • Add a Secondary Axis, Average Line & Smooth Line • Comparing Data Dynamically with Charts • Final Comments & Credits