Picking up where the ’Basics’ course left off, this 3+ hour ’Mastering Excel 2016 – Intermediate’ course will cover topics such as: working with Named Ranges, using Functions, PivotTables, and so much more!
Length: 3 hrs 11 min
This title is available in the
Total Training All-Access library.
If you’ve mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course builds on your existing knowledge of Excel basics and teaches you how to manage data, charts, and tables, and how to use powerful tools such as PivotTables, Pivot Charts, Slicers, Timelines, and more.
Explain the importance of named ranges
Write nested functions
Create and modify tables of data
Develop visuals on your table, based on the data, using conditional formatting
Organize large amounts of data into smaller, more specific tables using PivotTables
This is our most requested training course! If you learn to use Excel 2016, you will start to see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. If you are comfortable with the basics of Excel, let our Microsoft Certified Trainers Barbara Evers and Christina Tankersley walk you through more useful topics about Microsoft Excel 2016, including:
Working with Named Ranges and Tables
Using Logical, Text, Date, and other Functions
Sorting, Filtering, and Summarizing Data
Creating PivotTables and Pivot Charts
Using Conditional Formatting
Adding Slicers and Timelines to Analyze Information
CHAPTER 01: FUNCTIONS 1:11:52 1. Working with Named Ranges 2. Using Named Ranges in Formulas 3. Using Specialized Functions 4. Working with Logical Functions 5. Displaying Functions/Formulas 6. Nesting Functions 7. Date and Time Functions 8. Text Functions
CHAPTER 02: DATA 32:24 1. Sorting Data 2. Filtering Data 3. Using Database Functions 4. Using Subtotals
CHAPTER 03: TABLES & CONDITIONAL FORMATTING 22:11 1. Create and Modify Tables 2. Manipulating Table Data 3. Conditional Formatting Rules 4. Using Logical Functions with Conditional Formatting
CHAPTER 05: SHAPES, TABLES, SLICERS & MORE 36:39 1. Formatting Shapes and Objects 2. Creating a PivotTable 3. Analyzing PivotTable Data 4. Pivot Charts 5. Slicers and Timelines
It doesn’t take long for people who meet Barbara Evers to recognize her talents in written and verbal communication. Tapping into this strength, Barbara has found success in many facets of her life. Her mission is to help others do the same professionally and personally.
Barbara received a Bachelor of Arts degree in Zoology and a Master of Arts in Professional Communication from Clemson University. She is an active member of the Association for Type International, and her certifications include:
Myers Briggs Type Indicator
Coaching Using Multiple Models
Global Corporate College (GCC)
Development Dimensions International (DDI)
Barbara has over twenty-five years’ experience in training and public speaking with an emphasis in Career Development. With a broad list of clients in the corporate, non-profit, and government arenas, she excels in teaching participants the skills and techniques that will advance their careers. Her educational and career pursuits have provided a diverse background for her to use in instructional design and in the classroom. She draws from this experience to customize her materials and provide a valuable, interactive experience for each participant. Her areas of expertise include Communication, Customer Service, Management, and Leadership as well as software training.
Barbara lives in Greer, SC and is a published writer and the recipient of several writing awards, including a Pushcart Prize nomination. She writes for several blogs including two of her own and is an active member of South Carolina Writers Association and HubCity Writers.
Christina Tankersley has been involved with software education and project management since 1994. Her career includes working on software development and varying manufacturing projects, helping people understand the power of diverse thinking, and continue to learn tools to share with customers, students, and the population at large.
Her primary focus for instruction includes:
Herrmann Brain Dominance Index
Customer Relationship Management Tools
Information Technology Infrastructure Library
She has a BS in Business from the University of Charleston, an MBA from North Greenville University, and certifications including Project Management Professional (PMP), Comptia A+, Comptia Certified Technical Trainer, and Microsoft Certified Trainer.
When not working or studying, she loves to travel, read, and spend time with friends and family.