- Certificate of completion - Free
Microsoft Excel Master Online Training Package
Learning 247
Summary
Overview
Learn the skills every 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.
Contact us for Multi Course Purchase Discounts.
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.
Training Bundle Includes
- Microsoft Excel 2016
- Microsoft Excel 2013
- Microsoft Excel 2010
- Microsoft Excel 2007
* BONUS - Titles Include All Project Files to Work Along with the Instructor
Certificates
Certificate of completion
Digital certificate - Included
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 : BASICS
CHAPTER 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 & Data Types
- Accessing Help
- Creating Worksheet Formulas
- Insert Functions
- Re-using Formulas and Functions
- Insert, Delete, & Adjust Columns & 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 : INTERMEDIATE
CHAPTER 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 & 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 & MORE 36:39
- Formatting Shapes and Objects
- Creating a PivotTable
- Analyzing PivotTable Data
- Pivot Charts
- Slicers and Timelines
PART 3 : ADVANCED
CHAPTER 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
Who is this course for?
Anyone wishing to learn Microsoft Excel. New & experienced users can benefit from this comprehensive all-in-one online training bundle.
Requirements
None
Questions and answers
Can you tell me if this course is suitable for excel with office 365?
Answer:Yes, it covers Excel for Office 365.
This was helpful.Do I have to do all the versions to get a certificate or can I just do 2007 to receive a certificate
Answer:You get a downloadable certificate after completing each course; not for the entire bundle of courses.
This was helpful.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
FAQs
Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2024. All rights reserved.