Course Outline Learn the skills every Microsoft Excel user needs to know - no matter how new (or how experienced) you are... Whether you want to learn Excel 2016, 2013, 2010, 2007, or upgrade from one version to the next, our expert instructors will use a hands-on, engaging approach to teach you all of Excel's powerful features. Watch a single title or watch them all, as many times as you like for an entire year - all at one low price. Example Video (From Excel 2016) Many students ask us why we create our larger course bundles, when some people may not have time to complete all the courses inside the 12 month subscription window...Well, essentially they're created to enable you to dip in and out of multiple related programs and obtain cross-referenced knowledge; the intention is not for you to study it all or sit all the exams! With any kind of technical learning, building your background knowledge on closely related areas makes a lot of sense. Therefore, having access to a wide range of connected programs enables you to research related topics to the actual program you're studying for (often just watching the video/tutorial), enhancing your overall understanding. This is why we create the larger bundles; to build the breadth of your knowledge. Also, many IT professionals use them as reference material after certification, as we usually provide discounts on subsequent re-subscription - to enable you to have the material as a constant professional reference. Course Description This program covers several versions of Excel from beginner to advanced, but as an example, the topics covered (for Excel 2016) are... PART 1 : BASICSCHAPTER 01: MICROSOFT® EXCEL 2016 BASICS 4:04:11 Introduction Selecting and Navigating Keyboard Navigation and Basic Data Entry The Ribbon The Quick Access Toolbar Creating a New Spreadsheet Compatibility Issues Cell Data andamp; Data Types Accessing Help Creating Worksheet Formulas Insert Functions Re-using Formulas and Functions Insert, Delete, andamp; Adjust Columns andamp; Rows Find and Replace Use Proofing and Research Tools Apply Text Formats Apply Number Formats Align Cell Contents Applying Styles and Themes Conditional Formatting Creating and Using Templates Preview and Print a Notebook Page Layout Configure Headers and Footers Managing Worksheets View Options Managing Workbook Properties PART 2 : INTERMEDIATECHAPTER 01: FUNCTIONS 1:11:52 Working with Named Ranges Using Named Ranges in Formulas Using Specialized Functions Working with Logical Functions Displaying Functions/Formulas Nesting Functions Date and Time Functions Text Functions CHAPTER 02: DATA 32:24 Sorting Data Filtering Data Using Database Functions Using Subtotals CHAPTER 03: TABLES andamp; CONDITIONAL FORMATTING 22:11 Create and Modify Tables Manipulating Table Data Conditional Formatting Rules Using Logical Functions with Conditional Formatting CHAPTER 04: CHARTS 28:35 Creating Charts Modifying and Formatting Charts Creating a Dual Axis Chart Chart Templates CHAPTER 05: SHAPES, TABLES, SLICERS andamp; MORE 36:39 Formatting Shapes and Objects Creating a PivotTable Analyzing PivotTable Data Pivot Charts Slicers and Timelines PART 3 : ADVANCEDCHAPTER 01: MICROSOFT® EXCEL 2016 ADVANCED 2:53:26 Using Links and External References Using 3D References Consolidating Data Using Lookup Functions, Part 1 Using Lookup Functions, Part 2 Tracing Precedent and Dependent Cells Watching and Evaluating Formulas Comments and Track Changes Comparing and Merging Workbooks Accessibility Checker Protecting Worksheets and Workbooks Applying Data Validation Search for Invalid Data Working with Macros, Part 1 Working with Macros, Part 2 Creating Sparklines 3D Maps Data Tables Using Scenarios Goal Seek Forecasting Data Trends Changing Your Display Importing Delimited Text Files Data Forms and Form Controls Calculated Fields and Cube Functions * BONUS - Titles Include All Project Files to Work Along with the Instructor Learn anytime, anywhere, at home or on the go.Stream your training via the internet, or download to your computer and supported mobile device, including iPad, iPhone, iPod Touch and most Android devices. Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.
"Alright, so if you're trying to figure out who the absolute biggest and most popular Microsoft Excel Master Online Training Bundle stockists are here in the UK, it’s a right mixed bag, but some names just consistently pop up because of their sheer reach and customer pulling power. We’re talking about the retail behemoths everyone knows, like the swish department store giants such as John Lewis, Harrods, and Selfridges, which are always top of the list for brands aiming for that premium, high-footfall exposure. Then there are the high street heavyweights that pretty much have a presence in every single town and city: think Next, Marks & Spencer (M&S), and Boots, covering everything from fashion and homeware to health and beauty with incredible consistency. You absolutely can’t forget the massive supermarket chains either – Tesco, Sainsbury’s, and Asda aren't just for your weekly food shop; they've got huge sections for general merchandise, making them shockingly powerful Microsoft Excel Master Online Training Bundle stockists for a whole array of products. And, let's be real, the online champions like Amazon UK are just gargantuan, pulling in millions of shoppers every day, making them an unavoidable part of the 'popular Microsoft Excel Master Online Training Bundle stockists' conversation for pretty much anything. Essentially, getting your stuff into any of these big players means you're hitting a massive chunk of the British public, which is why they're perennially at the top of the popularity charts for brands looking to get noticed. " - Bargainplace UK
| Search for a bargain "Microsoft Excel Master Online Training Bundle" deal on eBay or Amazon |
|---|
| £24.50 | Best Deals >> |
Microsoft Excel Master Online Training Bundle stockists in London, Manchester, Birmingham, Glasgow, Hull, Grimsby and Edinburgh. Microsoft Excel Master Online Training Bundle suppliers in Newcastle, Sunderland, Leeds, Bradford and Middlesbrough. Microsoft Excel Master Online Training Bundle dealers in Blackpool, Lancaster, Oxford, Harrogate, York, Cambridge and Sheffield. Microsoft Excel Master Online Training Bundle sellers in Nottingham, Huddersfield, Warrington, Hartlepool, Wolverhampton, Southport, Stockport and Southampton. Microsoft Excel Master Online Training Bundle stockists in Barnsley, Brighton, Clitheroe, Lytham St Annes, Norwich, Ipswich, Leicester, Cardiff, Bristol, Swansea and more!