Get $1 credit for every $25 spent!

The 2022 Premium Microsoft Office Training Certification Bundle

Ending In:
Add to Cart - $29.99
Add to Cart ($29.99)
$2,200
98% off
wishlist
Courses
11
Lessons
677
Enrolled
117

What's Included

Product Details

Access
Lifetime
Content
11.0 hours
Lessons
100

PowerPoint From Beginner To Advanced Level

Learn MS Office PowerPoint Presentation (PPT) From Beginner To Advanced & Create Engaging Presentations, Templates, and Designs

By Magine Solutions | in Online Courses

This online PowerPoint course will teach you how to use PowerPoint the right way. Let’s learn every tool and every function inside PowerPoint and make presentations that impress! This PowerPoint course is designed to teach you all the tricks and tips you need to pull up your game in making awesome presentations. Regardless of what your level of experience is or what professional field you are in, this in-depth course is designed to provide you with everything you need to take your Presentation skills to the next level. Whether you prefer being more visual or using more animations, a great presenter knows how to compose a slide, animate it, and edit it. By honing these skills, you can sell your ideas so you can turn your passion into a career. This course shows you how to turn your ideas into visual slides that will gather the attention you need.

4.6/5 average rating: ★ ★ ★ ★

 

  • Access 100 lectures & 11 hours of content 24/7
  • Learn & Design Amazing PowerPoint Slides that wow your customers or colleagues
  • Build PowerPoint Projects to take you to the next level
  • Learn shortcuts that will save you time
  • Think out of the box with amazing animation possibilities inside PowerPoint
  • Turn a boring presentation into a sensational one
  • Use of every tool
  • Understand When Why & How to use PowerPoint to create amazing designs
  • Learn how to become a master or a guru of PowerPoint Software
  • Learn the essentials of an awesome design & how to be a Boss at designing your own content
  • Create Templates that sell
  • Be the best version of yourself at PowerPoint

Note: Software NOT included.

Instructor

Magine Solutions Team | This is Our World!

4.6/5 Instructor Rating: ★ ★ ★ ★

 

At Magine Solutions, the whole team believes that high-quality education should be available to everyone. That’s why the team is committed to working hard every day to promote online education in a new way. The team wants you and your friends and classmates to also get the best possible experience from this revolutionary approach by joining us today! With knowledgeable and experienced teachers with years of experience in the field, your learning will be at an advanced level. Whether you’re looking to learn more about the latest trends in marketing or how to use new software, Magine's courses offer hands-on instruction and practical advice for today’s most pressing industry issues.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any device with basic specifications
  • Any version of PowerPoint software

Course Outline

  • Your First Program
  • Section 1: PowerPoint: Home Tab
    • Introduction: Welcome and Resources
    • 1. Home Tab - The Clipboard_Updated - 5:38
    • 2. Home Tab - Slides - 5:07
    • 3. Home Tab - Fonts - 6:12
    • 4. Home Tab - Paragraphs - 6:02
    • 5.HOME . PARAGRAPGH 2 - 4:21
    • 6. Home Drawing 1 - 6:32
    • 6. Home - Drawing 2 - 7:31
    • 7.HOME . EDITING- - 6:32
  • Section 2: PowerPoint: Insert Tab
    • 8. Insert tab -tables 1 - 5:48
    • 9. Insert Tab - Table 2. Style Options - 4:49
    • 10.insert tab . table 3 style- - 6:28
    • 11. Insert Tab - Tables 4. Draw tables - 6:47
    • 12. INSERT TAB . TABLE LAYOUT - 5:08
    • 13.INSERT TAB . TABLE CELL SIZE - 3:43
    • 14.INSERT TAB LAYOUT ALIGNMENT - 8:00
    • 15. INSERT TAB . TABLE SIZE - 5:32
    • 16.INSERT TAB . PICTURE REMOVE BG - 6:02
    • 17.INSERT TAB . REMOVE BG ADVANCED - 8:31
    • 18.INSERT TAB. COLORS AND CORRECTIONS - 7:22
    • 19. Inset tab - Adjust color advanced - 8:28
    • 20.INSERT TAB . SCREEN SHOT - 5:37
    • 21.INSERT TAB PHOTO ALBUM - 5:54
    • 22.smart art - 8:00
    • 23.INSERT TAB SMART ART 2 - 6:15
    • 24.Insert tab . charts - 6:52
    • 25. INSERT TAB .CHART STYLES FINAL - 8:03
    • 26. Insert tab - chart tables- - 6:57
    • 27. Insert tab - Charts changing type - 5:22
    • 28 . Insert tab - Chart tool format section - 9:12
    • 29. Insert tab - Power tool - 5:42
    • 30. insert tab- comments - 3:08
    • 31. insert tab - text box - 1:48
    • 32. Insert tab - text 1 - 4:16
    • 33. Insert tab - Equation - 5:54
    • 34. Insert tab - Pen tool - 3:58
  • Section 3: PowerPoint: Design Tab
    • 35.Design tab - 9:36
  • Section 4: PowerPoint: Transitions Tab
    • 36. Transitions - 9:59
  • Section 5: PowerPoint: Animations Tab ​
    • 37. Animations- Entrance - 8:51
    • 38. Animation - Emphasis - 10:23
    • 39. Animation - exit - 10:47
  • Section 6: PowerPoint: Slideshow Tab
    • 40. Slideshow - 6:52
    • 41. slide show set up - 13:58
  • Section 7: PowerPoint: Review Tab
    • 42. Review tab - 4:32
    • 43. Reviews - Accesibility and insights - 4:20
    • 44. Review tab- Languages - 8:35
    • 45. Review tab - compare - 7:09
  • Section 8: PowerPoint: View Tab
    • 46. View- Normal and outline view - 4:33
    • 47. View - slide sorter - 3:09
    • 48. View-Notes and reading view - 3:26
    • 49.View-More Details - 13:57
    • 50. View -Master Slide Overview - 9:54
    • 51.Master Slide - Notes and hangouts - 7:15
  • Section 9: PowerPoint: Essential Tools
    • 1. Creating a new document - 1:56
    • 2. Quick Access Toolbar - 3:10
    • 3. File Tab - 4:18
    • 4. Tabs and Ribbons - 2:31
    • 5. Slide Tab - 2:58
    • 6. Status Bar - 4:30
    • 7. Aspect Ratio - 3:45
    • 8. Modifiers - 5:38
    • 9. Drawing Shapes - 6:45
    • 10. Copy Cat - 3:30
    • 11. Editing Vertices
    • 12. Color Schemes - 2:22
    • 13. Fonts - 4:32
    • 14. Show Less Mean More - 3:50
    • 15. Never Forget Again - 4:45
    • Bonus Section 1 - 12:39
  • Section 10: Universal Design Essentials (Part 1)
    • 2. Title Slide (creation and design) - 6:28
    • 1. Creation Design Animation - 3:16
    • 3. Title slide animation - 4:59
    • 4. Title Colors - 4:17
    • 5. Shape Color Alignment - 6:40
    • 6. PNG vs Vectors - 2:19
    • 7. Company Intro - Creation and Design - 9:44
    • 8. Company Intro Animation - 9:27
    • 9. Company Intro Animation (Continued) - 6:24
  • Section 11: Universal Design Essentials (Part 2)
    • 11. Portfolio Animation - 8:33
    • 15. Timeline vertical - 6:34
    • 10. Portfolio - 9:37
    • 18. Coffee Break Audio - 5:21
    • 14. Timeline Animation - 4:38
    • 16. Timeline vertical (animation) - 6:59
    • 13. Timeline - 5:37
    • 17. Coffee Break - 8:35
    • 12. Stages (design and animations) - 9:16
  • Section 12: Business Design Templates
    • 1.Title page for business presentation - 10:31
    • 2.Title Page - Variations - 7:24
    • 3. Our Team Designs - 7:17
    • 4.Sell Your Packages - 14:58
    • 5.sell your package better - 13:20
    • 6.Business Objectives - 8:51
    • 7.Our team audio ok - 16:02
    • 8.Our Team Revamped - 15:47
    • 9.Our Team Reloaded - 13:39
    • 10.SWOT analysis - 21:51
    • 11.Image Layout - 13:26
  • Section 14: Conclusion
    • Bonus lesson - 19:33
    • Check In - 1:06

View Full Curriculum


Access
Lifetime
Content
15.0 hours
Lessons
163

Microsoft Power BI - The Complete Masterclass

Become an Advanced Report Developer Through This Course That Covers Everything in Power BI

By Nikolai Schuler | in Online Courses

Do you want to learn the skills to professionally analyze data? Do you want to learn all the steps to create impressive reports? Then Microsoft Power BI is the right tool for you! In this course, you will learn – step by step – everything that is important in Power BI to become an advanced Power BI report creator. This course is right for you if you have never worked with Power BI and want to learn everything hands-on in one course or you have already some basic knowledge and want to dive deeper and become more advanced in the whole universe of Power BI. This is the course that covers everything in Power BI to become an advanced report developer!

4.6/5 average rating: ★ ★ ★ ★
  • Access 163 lectures & 15 hours of content 24/7
  • Understand everything from scratch – step by step, very structured and practice-oriented
  • Learn all the important tools – know when and how to use them properly
  • Connect different data sources – from basics to advanced
  • Create your data model – and understand it
  • Master DAX – to do more advanced analysis on your data
  • Get to know all the different visualizations – and how to use them
  • Storytelling with data – learn how to visualize your data effectively
  • Create interactive visualizations – with drill throughs and drill-downs
  • Advanced analysis – learn how to use R Script in Power BI (Data Science)
  • Forecasting – Advanced analytics which can be helpful in Data Science
  • Row-Level Security – Implement the security concept to control access to the data

Nikolai Schuler | Professional Data Scientist & BI Consultant

4.6/5 Instructor Rating: ★ ★ ★ ★

Nikolai Schuler is a data scientist and BI consultant. He sees that there a lot of new tools that bring a lot of benefits, as a data scientist and BI consultant. Yet, he also sees that it is not always easy to learn working with these tools. For that reason, he decided to create courses that are high quality on the one hand and easy to learn with on the other hand. These courses now have reached people in more than 130 countries.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any device with basic specifications

Course Outline

  • Getting started
    • Welcome! - 0:22
    • What is Power BI? - 3:01
    • Download & Installing - 4:06
    • The interface (Quick Tour) - 2:43
    • Mini Project - Transform Data - 6:52
    • Mini Project - Visualizing Data - 5:07
    • Mini Project - Data Model - 7:21
    • What will you learn in this course? - 5:02
    • All source files & course slides
  • Preparing the course project
    • Working with the attached project files - 3:51
  • Data Transformation - Beginner to Intermediate
    • Exploring the Query Editor - 6:11
    • Connecting to our data source - 6:48
    • Editing and removing rows - 8:10
    • Changing data types - 8:24
    • Replace Values - 3:27
    • Close & Apply - 3:29
    • Connecting Power BI to a csv file - 3:21
    • Connecting to a Web Page - 5:04
    • Extract Characters - 6:18
    • Splitting & Merging Columns - 9:22
    • Create a conditional column - 5:52
    • A little note on the next lecture!
    • Columns from examples - 8:38
    • Merging Queries - 17:23
    • Pivoting & Unpivoting - 5:43
    • Appending Tables - 8:20
    • Practise & Solution: PopulationTable - 14:30
    • Fact Dimension Model - 9:19
    • Practise: Load Dimension Table - 3:48
    • Organizing our Queries in Groups - 2:59
    • Text used in the next lecture
    • Entering data manually - 4:43
    • Creating an index column - 3:04
    • Workflow & more transformations - 4:38
    • Module Summary - 5:05
    • Excersice: Instructions - 1:41
    • Exercise: Solution - 11:09
  • Data Transformation - Advanced
    • Advanced Editor - Best practise - 8:43
    • References vs. Duplicates - 9:50
    • Enable Disable Load & Report Refresh - 4:31
    • Group by - 4:47
    • Mathematical Operations - 4:54
    • Run R Script - 14:36
    • Using Parameters to dynamically transform data - 6:28
    • M-language Basics - 6:40
    • M-Language Values, Lists & Tables - 13:57
    • M-Language Functions - 13:13
    • M-Language More functions & steps - 5:02
    • Exercise: Instructions - 0:55
    • Exercise: Solution - 4:31
  • Creating the Data Model
    • Understanding relationships - 5:07
    • Create & Edit relationships - 6:16
    • One-to-Many and One-to-One Relationship - 5:49
    • Many-to-Many relationship & Crossfilter direction - 8:15
    • Cross filter direction - 5:56
    • Activate & Deactivate relationships - 5:52
    • Section Summary - 3:04
    • Exercise 3 - Create Model - 2:27
    • Exersice 3 - Solution - 1:37
  • Data Visualization
    • Our first visual - 7:57
    • The format tab - 11:52
    • Tables - 9:53
    • Conditional Formatting - 8:48
    • The pie chart - 5:32
    • All about the Filter visual - 12:32
    • Filter pane for developers - 8:52
    • Cross filtering & Edit interactions - 3:56
    • Exercise 4 - Instructions - 1:00
    • Exercise 4 - Solution - 6:10
    • Syncing slicers across pages - 7:06
    • Drill down - 8:29
    • Drill through - 6:50
    • Tree map visual - 7:06
    • Decomposition tree - 5:23
    • Matrix visual - 5:17
    • Edit pages - 7:15
    • Buttons & Actions - 9:28
    • Bookmarks to customize your report - 9:31
    • Analytics and Forecast with Line Charts - 10:12
    • Working with Custom Visuals - 7:17
    • R scripts for the next lecture
    • Get data using R & R Script Visual - 8:26
    • Asking Questions - Q & A Visual - 3:45
    • Wrap up Data Visualization - 8:09
  • Power BI & Python
    • Python in Power BI: Plan of attack - 2:57
    • Setting up Python for Power BI - 3:03
    • Transforming data using Python scripts - 11:24
    • Python script I (for the next lecture)
    • Creating visualizations using Python - 7:55
    • Python script II (for the next lecture)
    • Violine plots, ridge plots & correlation analysis plots - 7:13
    • Python script III (for the next lecture)
    • Machine Learning & Text Analysis using Python - 9:53
    • Performance & Troubleshooting - 3:27
  • DAX - The Essentials
    • Welcome to DAX - 2:32
    • Let's look at our data - 4:09
    • DAX Cheat Sheet
    • All files for the DAX sections
    • Measures vs. Calculated columns - 14:37
    • Automatically create a date table - 8:17
    • CALENDAR - 5:08
    • Complete date table with additional features - 3:43
    • Script to be used in your future projects
    • Key Measures Table - 3:19
    • Aggregation functions - 6:07
    • COUNT and its variations - 14:05
    • SUMX - How does it work - 8:32
    • DAX Exercise 1
    • DAX Solutions 1
  • DAX - CALCULATE function
    • CALCULATE Basics - 10:53
    • FILTER - 6:31
    • ALL - 7:53
    • ALLSELECTED - 3:13
    • ALLEXCEPT - 7:24
    • DAX Exercise 2
    • DAX Solution 2
  • DAX - Time Intelligence
    • TimeIntelligence & DATEADD - 11:18
    • Year-to-Date & Month-to-Date - 5:19
    • TOTALYTD VS DATESYTD - 8:54
    • DATESBEETWEEN - 5:15
  • DAX - Operators, Variables & Quickmeasures
    • Logical Operators - 9:27
    • Commenting and Formatting - 5:48
    • Variables - 9:47
    • Quickmeasures - How to use them in a smart way - 4:46
  • Visualize effectively & Tell a story with your data
    • Intro - Best Practises - 1:01
    • Best practise #1 - Show Empathy & Identify the requirements - 2:37
    • Best practise #2 - Finding the most suitable KPIs - 2:18
    • Best Practise #3 - Choose an effective visualization - 3:39
    • Best Practise #4 Make use of natural reading pattern - 2:58
    • Best practise # 5 - Tell a story using visual cues - 5:21
    • Best practise # 6 - Avoid Chaos & Group information - 2:17
    • Wrap up - Stroytelling with data - 1:41
  • Power BI Cloud - Power BI Service
    • How to go from here? - 3:13
    • Power BI Pro vs. Premium & Registration - 3:48
    • An alternative if you don't have a business email
    • Exploring the Workspaces - 4:10
    • Discovering the workspaces - 2:31
    • Note on the next lecture
    • Connecting Power BI Desktop & Cloud - 4:00
    • Understanding Datasets & Reports - 3:24
    • Working with the reports - 3:53
    • Updating the reports from Power BI Desktop - 4:29
    • Creating and working with Workspaces - 7:13
    • Installing & Using a Data Gateway - 12:53
    • Get Quick Insights - 2:33
    • Creating Dashboards - 4:05
    • Sharing our results through Apps - 10:09
    • Power BI Mobile App - 5:26
    • Creating the layout for the Mobile App - 3:46
    • Cloud Wrap up - 7:13
  • Row-Level Security
    • Intro - 3:20
    • Creating a Row-Level Security - 4:51
    • Row-Level Security in the Cloud - 3:31
    • Row-Level Security & Data Model - 4:38
    • Dynamic Row-Level Security - 7:28
    • Dynamic Many-to-Many RLS - 4:04
    • Hierarchical Row-Level Security - 12:55
  • Additional data sources
    • JSON & REST API - 9:57
    • Setting up a local MySQL database - 14:01
    • Connecting to a SQL database - 4:59
    • Power BI & SQL database (PostgreSQL) - 5:01
  • Congratulations & how to stay up to date
    • Congratulations & Next steps - 6:24
    • More data to practise

View Full Curriculum


Access
Lifetime
Content
2.0 hours
Lessons
31

Microsoft 365 Teams

Get a Comprehensive Overview of Teams, Part of Microsoft 365

By Intellezi | in Online Courses

Teams are the hub for teamwork in Microsoft 365, providing a centralized workspace for teams to communicate and collaborate. It features persistent and threaded chats, file sharing, and the ability to hold meetings. Students will learn to create teams, add users, manage a team, start a team conversation, reply to a conversation, and add files. Students will also explore channels, create new channels, create and share files, work with meetings, schedule team meetings, integrate with SharePoint, add tabs to keep files, notes, and apps available, and connectors to access content and get updates.

4.4/5 average rating: ★ ★ ★ ★

  • Access 31 lectures & 2 hours of content 24/7
  • Converse & collaborate with Teams
  • Add & share files with Teams
  • Schedule team meetings, work with conversations & more
  • Know how to create & add users and manage a team
  • Find out ways on how to create channels & work with favorites
  • Gain insights on how to integrate SharePoint, add tabs & connectors
Intellezy Trainers | Computer Training Specialists
4.4/5 Instructor Rating: ★ ★ ★ ★

Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From their change management consulting to their learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Their online videos and quick reference guides are designed to educate and empower individuals, right when they need it.

In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Their library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any device with basic specifications

Course Outline

  • Introduction
    • Introduction - 3:13
  • A First Look at Teams
    • Getting Started with Teams - 4:02
    • Navigating and Understanding Teams - 5:24
    • Working with Presence Status - 7:25
  • Using Chat
    • Getting Started with Chat - 4:29
    • Sending a Message - 5:30
    • Advanced Messaging Options - 7:41
    • Sharing Files in Chat - 5:28
    • Managing Chat - 6:00
  • Working with Meetings
    • Creating a Meeting on the Spot - 4:53
    • Scheduling a Meeting - 5:49
    • Working with Meeting Settings - 6:56
    • Using Meeting Notes and Chat - 6:00
    • Sharing Content in a Meeting - 5:37
    • Recording a Meeting - 4:14
  • Collaborating Using Teams
    • Creating or Joining a Team - 6:38
    • Managing a Team - 5:46
    • Exploring Channels - 6:52
    • Understanding Channel Options - 1:37
    • Communicating Within a Team - 7:12
    • Sharing Files with a Team - 7:24
    • Adding Tabs - 5:23
    • Adding Connectors - 4:14
    • Using Teams in SharePoint - 4:32
  • Additional Features
    • Using Immersive Reader - 4:02
    • Using the Search and Command Box - 3:44
    • Working with the Activity Tab - 3:53
    • Adjusting Settings - 3:16
    • Managing Notifications - 3:46
  • Conclusion
    • Course Recap - 1:55
  • Microsoft 365 Teams - Assessment Quiz
    • Assessment Quiz

View Full Curriculum


Access
Lifetime
Content
5.0 hours
Lessons
58

Microsoft OneNote: Beginner to Advanced

Make Your Notes Highly Organized, Stored in One Place, & Easily Accessed From Any Device

By Earn and Excel | in Online Courses

Paperless and productive — the two biggest benefits you will get from doing this course. OneNote lets you take your work with you, wherever you go, on any device. It syncs automatically, so you never have to worry about saving notes when you're on the go. Earn, and Excel brings you a course that will teach you everything you need to know about OneNote, and then some. You will be taught by the highly experienced corporate professional and trainer Claudia, who shares her many years of using Office in some of the biggest, most high profile global companies. By the end of this course, your notes will be highly organized, stored in one place, and easily accessed from any device.

4.3/5 average rating: ★ ★ ★ ★

  • Access 58 lectures & 5 hours of content 24/7
  • Get started with OneNote: introduction, quick access toolbar & inserting notes
  • Copy cut text & split and merge containers
  • Delete & insert time stamp
  • Format text, apply styles & use format painter
  • Add & organize sections
  • Create subpages & section groups
  • Work with different page versions
  • Insert printouts & attachments
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Any device with basic specifications

Course Outline

  • 1 Getting Started, Intro, QAT, Inserting Notes
    • 1.1 Introduction to OneNote - 5:38
    • 1.2 OneNote Introduction to the ribbon - 8:52
    • 1.3 Organise QAT - 6:08
    • 1.4 Organise QAT Part 2 - 2:34
    • 1.5 Inserting notes - 5:54
  • 2 Containers, Time Stamp, Pages, Formatting, Bullets and Numbers, Spaces
    • 2.1 Copy cut text and split and merge containers - 8:06
    • 2.2 Deleting and inserting time stamp - 5:32
    • 2.3 Adding and deleting pages - 4:11
    • 2.4 Formatting text applying styles and using the format painter - 7:33
    • 2.5 Creating bulleted and numbered lists - 10:25
    • 2.6 Inserting and removing spaces between containers - 3:21
  • 3 Sections, Subpages, Section Groups, Templates
    • 3.1 Adding and organising sections - 5:53
    • 3.2 Creating subpages - 8:59
    • 3.3 Creating section groups - 10:27
    • 3.4 Applying OneNote templates - 9:01
    • 3.5 Creating customised templates - 5:11
  • 4 Page Versions, History, Quick Notes, Dock to Desktop, Linked Notes
    • 4.1 Working with different page versions - 4:58
    • 4.2 The History tab – recycle bin etc. - 5:42
    • 4.3 Using Quick Notes - 7:04
    • 4.4 Change default location of Quick Notes - 2:58
    • 4.5 Using dock to desktop - 9:27
    • 4.6 Using Linked Notes - 4:54
  • 5 Inserting Printouts, Attachments, Excel, Tables
    • 5.1 Inserting printouts and attachments - 5:56
    • 5.2 Inserting Excel part 1 - 6:38
    • 5.3 Inserting Excel part 2 - 5:01
    • 5.4 Inserting tables - 7:48
    • 5.5 Formatting tables - 6:21
    • 5.6 Sorting data within a table - 4:23
  • 6 Screen Clipping, Inserting Pictures & Symbols, Send to OneNote, Text to Ink
    • 6.1 Screen clipping - 7:13
    • 6.2 Inserting pictures - 5:12
    • 6.3 Using the Optical Character Recognition - OCR - 3:17
    • 6.4 Inserting symbols - 5:01
    • 6.5 Using Send to OneNote - 8:05
    • 6.6 Converting handwritten ink to text - 5:11
  • 7 View Tab, Side Panes, Tags, Audio Recording
    • 7.1 The View tab options - 13:08
    • 7.2 Customising the side panes - 6:42
    • 7.3 Applying tags - 6:34
    • 7.4 Searching tags - 8:27
    • 7.5 Audio recording part 1 - 3:08
    • 7.6 Audio recording part 2 - 2:03
  • 8 Research, Links, TOC, Pen & Highlighter, Shapes
    • 8.1 Using research option within the View tab - 8:56
    • 8.2 Creating links between notebooks sections and pages - 7:58
    • 8.3 Creating a TOC - 4:06
    • 8.4 Setting up the pen and highlighting text - 7:11
    • 8.5 Inserting and formatting shapes - 4:02
    • 8.6 Rearranging shapes - 7:08
    • 8.7 Using the pointer - 2:39
  • 9 Equations, Math, Sending & Exporting, Linking Contacts & Appointments
    • 9.1 Inserting Equations - 6:11
    • 9.2 Inserting handwritten Equations - 6:24
    • 9.3 Calculating simple math - 2:37
    • 9.4 Sending OneNote pages via email - 5:16
    • 9.5 Exporting OneNote - 5:04
    • 9.6 Linking Outlook Contacts in OneNote - 3:44
    • 9.7 Linking Outlook 365 appointments in OneNote - 7:20
    • 9.8 Using Outlook tasks in OneNote - 8:05
  • 10 Backups, Restores, Password Protecting
    • 10.1 Using Backups to restore sections - 3:32
    • 10.2 Restoring deleted pages and sections - 4:25
    • 10.3 Password protecting sections - 6:17

View Full Curriculum


Access
Lifetime
Content
6.0 hours
Lessons
36

Microsoft Access: Beginner To Advanced

Get Your Database Up & Running Quickly

By Earn and Excel | in Online Courses

If you are working in a small company and you want to be able to manage your data, whether that be some sales data, expenses, marketing information, or project focus data and you need to get up and running quickly with a database to handle it, well Access is definitely the tool for you. This course is created to teach you how to use Access to be a great end-user tool that you can get up and running quickly and give your database more advanced capability if you wish to.

4.7/5 average rating: ★ ★ ★ ★

  • Access 36 lectures & 5 hours of content 24/7
  • Learn the fundamentals of Access: tables, primary key & data types
  • Query your database
  • Create links between tables
  • Create forms with & without the wizard
  • Use the wizard to build a report or
  • Export data to Excel, Word, or PDF
  • Use buttons to carry out advanced functions, conditional outputs, & more
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Access

Course Outline

  • 1 Creating Tables
    • Course Materials
    • 1.1 Creating and Saving a Table in Design Mode - 15:53
    • 1.2 The Primary Key - 8:02
    • 1.3 Important Field Properties - 13:50
  • 2 Creating Queries
    • 2.1 The Select Query - 12:04
    • 2.2 Filtering and Sorting Records using Numeric and Date Fields - 12:06
    • 2.3 Filtering and Sorting Records using Text Fields and Wildcards - 12:21
    • 2.4 Adding a Calculated Field to a Query - 11:07
  • 3 Action Queries
    • 3.1 Queries that Change Data - 9:20
    • 3.2 Adding Pop Up Parameters to Queries - 10:10
  • 4 Linking Tables
    • 4.1 Two Reasons for a Relational Database - 14:35
    • 4.2 Creating Links Between Tables - 8:43
    • 4.3 Multiple Table Queries - 8:41
  • 5 Creating Forms
    • 5.1 Creating a Form Using the Wizard - 15:35
    • 5.2 Creating and Editing a Form WITHOUT the Wizard - 14:17
    • 5.3 The Clever ComboBox Record Finder - 8:35
  • 6 Creating SubForms
    • 6.1 Forms Within Forms in a Relational Database - 13:30
    • 6.2 SubForms Based on Query Data - 13:33
  • 7 Creating Splitforms
    • 7.1 Use of the SplitForm Feature - 6:33
  • 8 Creating Reports
    • 8.1 Create a Report with the Wizard - 9:13
    • 8.2 Create a Report from Scratch and add Special Fields - 14:15
    • 8.3 Grouping with Reports - 8:47
  • 9 Exporting Data
    • 9.1 Export Data into Excel - 8:04
    • 9.2 Export a Report to Word or PDF - 7:28
  • 10 Importing data
    • 10.1 Import from Excel - 13:52
    • 10.2 Use of Paste Append - 5:22
    • 10.3 Import an Access Table from another Database - 7:31
    • 10.4 Create a Mail Merge in Word using Data from Access - 9:54
    • 10.5 Mail Merging in Word using Data from Excel - 7:15
  • 11 Building VBA/Macros
    • 11.1 Introduction to Access Macros - 13:08
    • 11.2 Introduction to Events in Access using VBA - 9:01
    • 11.3 Create a Form with Buttons to open/close other objects - 12:40
    • 11.4 Refresh the data in one combo box when another combo box is changed - 17:08
    • 11.5 Decide on a course of action based on user input - 8:26
    • 11.6 Using VBA to connect Access to a SQL Server backend database - 11:56
    • 11.7 The special AUTOEXEC macro - 6:57

View Full Curriculum


Access
Lifetime
Content
3.0 hours
Lessons
32

Microsoft SharePoint

Manage Subsites & User Permissions to Add Powerful Controls to Your Document Management Experience

By Earn and Excel | in Online Courses

As the corporate world adopts more remote working practices, SharePoint's role as not just a document management tool but as a full collaboration tool is evolving. More than ever, SharePoint is playing a significant role in companies' success in managing their everyday work. Several of us experienced professionals at Earn and Excel collaborated and created an efficient and powerful training for SharePoint that will have you making the most of this brilliant tool for your team's needs. This course introduces you to SharePoint and how it is important to day-to-day organization tasks.

4.1/5 average rating: ★ ★ ★ ★

  • Access 32 lectures & 3 hours of content 24/7
  • Understand why SharePoint is so important for the modern day organization
  • Manage subsites & user permissions to add powerful controls
  • Explore SharePoint apps, lists & libraries
  • Work with SharePoint libraries to maximize document management capabilities
  • List views & calendar for a visual interpretation of your team's assets
  • Work with site pages to enhance & customize your SharePoint experience
  • Sync with OneDrive to connect data sources
  • Site columns & content types to further customize the management of your document assets
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft SharePoint

Course Outline

  • 1 Introduction to SharePoint
    • 1.1 Set Up and Create Site - 6:48
    • 1.2 Settings and Navigation - 6:39
    • 1.3 News, Activity and Quick Links - 7:15
    • 1.4 Documents - 5:47
  • 2 Apps List and Libraries
    • 2.1 Adding Data using Custom List - 12:03
    • 2.2 Views, Filters and Sorting - 6:29
    • 2.3 Site Contents and Document Libraries - 9:09
  • 3 Working with SharePoint Libraries
    • 3.1 Adding Files and Checking In and Out - 8:05
    • 3.2 Versioning and Restoring - 5:36
    • 3.3 Quick Edit, Sequence No. and Sorting - 6:46
    • 3.4 Grouping - 7:33
    • 3.5 Alerting - 4:57
    • 3.6 Permissions, Sharing and Pinning - 6:13
  • 4 List Views and Calendar
    • 4.1 List Views - 7:07
    • 4.2 Calendar - Part 1 - 7:28
    • 4.3 Calendar - Part 2 - 9:24
    • 4.4 Adding Calendar and Other Apps to Home Page - 5:42
  • 5 Working with Site Pages
    • 5.1 Creating a Site Page - 8:28
    • 5.2 Adding Sections and Web Parts - 7:11
    • 5.3 Adding More Web Parts - 6:16
    • 5.4 Adding to Home Page, Deleting and Restoring - 6:02
    • 5.5 Adding a Web Part Page - 9:53
    • 5.6 Adding a Wiki Page - 5:28
  • 6 Syncing with OneDrive
    • 6.1 Syncing with OneDrive - 7:27
  • 7 Site Columns and Content Types
    • 7.1 Creating a Custom Site Column - 6:27
    • 7.2 Adding Custom Column to List - 6:31
    • 7.3 Creating New Content Types - 8:35
    • 7.4 Creating a List using Content Types - 10:02
  • 8 Managing Sub Sites and User Permissions
    • 8.1 Creating Sub Sites - 10:23
    • 8.2 Site Permissions - 9:52
    • 8.3 Sub Site Permissions - 6:30
    • 8.4 Access Requests and Site Collections - 3:37

View Full Curriculum


Access
Lifetime
Content
4.0 hours
Lessons
83

Microsoft Word 365

Get Started with Creating Documents, Formatting & Stylizing

By Earn and Excel | in Online Courses

Earn and Excel worked with the highly experienced corporate professional and trainer Claudia Carrozzo who brought her many years of using Office in some of the biggest, most high profile global companies and created an incredible training course which will have you working to an intermediate level with Word in a few hours.

4.4/5 average rating: ★ ★ ★ ★

  • Access 83 lectures & 4 hours of content 24/7
  • Be familiar with the quick access toolbar, Ribbon, & basic operations
  • Get started with formatting, spell checking, & removing spaces
  • Work with tables
  • Use margins & alignments
  • Know the best practices with text boxes
  • Create shapes & objects
  • Use styles to customize your documents
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating:

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Word

Course Outline

  • Module 1
    • Module 1 download
    • 1.1 Opening a new blank document - 1:42
    • 1.2 New blank doc 3 ways - 1:20
    • 1.3 Highlighting and adding text - 1:32
    • 1.4 Revealing formatting marks - 4:01
    • 1.5 Customising the QAT - 3:43
    • 1.6 Changing the ribbon - 1:48
    • 1.7 Help menu and Search bar - 3:08
    • 1.8 Save and close doc - 1:51
  • Module 2
    • Module 2 download
    • 2.1 Formatting big docs at a glance and applying headings - 11:26
    • 2.2 Explanation of Headings - 1:55
    • 2.3 Spell Check - 3:57
    • 2.4 Spell Check continued - 1:53
    • 2.5 Removing extra paragraphs and bullet spaces - 2:37
    • 2.6 Follow up formatting removing bulleted list and spaces - 3:19
  • Module 3
    • Module 3 download
    • 3.1 Inserting a page break - 6:42
    • 3.2 Creating a table and entering data text - 2:13
    • 3.3 Creating a table and entering data text continued - 2:28
    • 3.4 Creating a table from scratch - 4:07
    • 3.5 Creating a table from scratch continued - 3:41
    • 3.6 Creating a table borders and shading - 5:07
    • 3.7 Creating a table text direction and shading - 5:29
  • Module 4
    • Module 4 download
    • 4.1 Preset margins - 3:04
    • 4.2 Orientation - 1:41
    • 4.3 Alignments and indenting - 5:46
    • 4.4 Margins manual adjustment - 1:54
    • 4.5 Formatting underline and bold - 8:20
    • 4.6 Cut and paste - 4:50
    • 4.7 Copy and paste - 4:14
  • Module 5
    • Module 5 download
    • 5.1 Applying bullets and picture bullets - 6:08
    • 5.2 Numbered list - 1:46
    • 5.3 Basic multilevel list - 5:11
    • 5.4 Paragraph numbering - 1:25
    • 5.5 Multi level list with headings - 6:16
    • 5.6 Inserting a coverpage - 3:37
  • Module 6
    • Module 6 download
    • 6.1 Convert text to table - 5:17
    • 6.2 Inserting and deleting rows and columns - 6:49
    • 6.3 Convert text to table with tabs - 3:31
    • 6.4 Working with text boxes - 7:36
    • 6.5 Working with text boxes continued - 14:36
    • 6.6 Linking text boxes - 3:56
  • Module 7
    • Module 7 download
    • 7.1 Building block explanation - 5:22
    • 7.2 Creating a building block from scratch - 3:46
    • 7.3 Delete a building block - 1:39
    • 7.4 Insert automatic date and time and update field - 4:03
    • 7.5 Section breaks - 5:30
    • 7.6 Text flow options - 3:23
  • Module 8
    • Module 8 download
    • 8.1 Insert header with building blocks - 3:00
    • 8.2 Insert footer with building blocks - 2:48
    • 8.3 Inserting page numbers and modifying where it starts - 4:59
    • 8.4 Insert header manually - 5:39
    • 8.5 Insert footer manually - 2:25
    • 8.6 All different views within Word - 5:23
  • Module 9
    • Module 9 download
    • 9.1 Find and replace - 3:12
    • 9.2 Creating shapes with fill and gradients - 8:04
    • 9.3 Adding text to shapes - 0:54
    • 9.4 Enter text with text box and group to objects - 5:41
    • 9.5Grouping and resizing shapes - 3:17
  • Module 10
    • Module 10 download
    • 10.1 Insert and format a picture - 2:48
    • 10.2 Applying page colour - 3:30
    • 10.3 Applying viewing and removing a watermark - 2:39
    • 10.4 Finding pages - 1:38
    • 10.5 Design a table manually - 3:21
    • 10.6 Setting repeat header rows - 1:36
    • 10.7 Removing all formatting and selecting headings - 3:58
  • Module 11
    • Module 11 download
    • 11.1 Creating and applying a new style - 4:49
    • 11.2 Remove style from gallery - 0:36
    • 11.3 Save Word doc as PDF file - 3:03
    • 11.4 Viewing recent docs - 2:48
    • 11.5 Creating a new folder - 2:01
    • 11.6 Using MS Word translator - 3:12
    • 11.7 Using a template - 3:38
    • 11.8 Find and replace font and formatting - 2:36

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
11

Microsoft Power Apps

Create Mobile Apps Without Coding

By Earn and Excel | in Online Courses

Microsoft’s PowerApps hasn’t gained the popularity it deserves, but it has the potential to be a gamechanger for companies. Without any coding knowledge, you can make your very own mobile apps that sync with Microsoft's tools. This course will walk you through the capabilities of PowerApps and focus particularly on SharePoint and Power Automate to automate lots of crucial everyday work tasks with PowerApps in developing some outstanding training on using this tool. There are some solid best practice guidance and more unconventional tips and strategies in getting the most out of it for, well, your team!

4.1/5 average rating: ★ ★ ★ ★

  • Access 11 lectures & 1 hour of content 24/7
  • Walk through the capabilities of PowerApps
  • Create mobile apps
  • Customize SharePoint list forms
  • Work with templates & PowerAutomate
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft PowerApps

Course Outline

  • 1 Power Apps Introduction
    • 1.1 Power Platform Course Introduction - 11:00
  • 2 Create Mobile App and Customise SP List Form
    • 2.1 Create Mobile App from SP List - 9:21
    • 2.2 Customise SP List Form - 3:18
  • 3 Templates
    • 3.1 PA Templates - 10:24
    • 3.2 Flow Templates - 7:03
  • 4 Flow Set Reminder and Sign Off
    • 4.1 Flow Set Reminder in SP List - 5:24
    • 4.2 Flow SP Sign Off - 5:08
    • 4.3 Robotic Process Automation with Power Automate - 10:33
  • 5 SP List Item, Flow Mobile Button and BI
    • 5.1 Flow SP List Item - 8:02
    • 5.2 Flow Mobile Button - 7:01
    • 5.3 BI - 6:17

View Full Curriculum


Access
Lifetime
Content
5.0 hours
Lessons
46

Microsoft Publisher 365

Create Business Cards, Greeting Cards, Calendars, Newsletters & Much More

By Earn and Excel | in Online Courses

This course takes you step-by-step from the very basics of setting up Publisher with personalizations and preferences through to designing and publishing a booklet. Along the way, you will learn how to maximize your efforts with tips and tricks to speed up your work. You will see how to create mail merges that can distribute your publications at the click of a button. Claudia will also show you how to find and personalize templates for business cards and much, much more.

  • Access 46 lectures & 5 hours of content 24/7
  • Personalize & set page options
  • Insert pages, business info, & setting preferences
  • Insert text boxes, columns & symbols
  • Find & replace list and tab stops
  • Master pages, spell check templates & mail merge
Note: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Publisher

Course Outline

  • 1 Introduction, Personalisation and Setting Page Options
    • 1.1 Introduction to Publisher - 0:58
    • 1.2 Look and feel of Publisher - 8:47
    • 1.3 Personalising QAT - 9:48
    • 1.4 Personalising the ribbon by creating new tabs and groups - 7:21
    • 1.5 Setting up page options before starting - 8:08
  • 2 Pages, Business Info and Preferences
    • 2.1 Inserting pages - 4:33
    • 2.2 Moving and deleting pages - 3:50
    • 2.3 Editing and inserting business info - 6:55
    • 2.4 Setting up preferences in the Options dialog box and using AutoCorrect - 8:30
  • 3 Text Boxes, Formatting, Importing, Columns and Symbols
    • 3.1 Inserting text boxes and text - 9:28
    • 3.2 Formatting text boxes - 10:34
    • 3.3 Formatting text - 8:58
    • 3.4 Further text formatting with WordArt Styles - 7:44
    • 3.5 Importing text and creating columns - 7:20
    • 3.6 Paragraph and columns spacing - 4:28
    • 3.7 Using hyphenations and inserting symbols - 6:38
  • 4 Find and Replace, Lists and Tab Stops
    • 4.1 Using find and replace - 3:21
    • 4.2 Finding words using a wild card - 1:57
    • 4.3 Creating bulleted lists - 5:52
    • 4.4 setting up tab stops - 6:36
  • 5 Tables and Pictures
    • 5.1 Inserting a table - 4:40
    • 5.2 Designing a table - 9:02
    • 5.3 Inserting pictures and text wrapping - 18:58
    • 5.4 Formatting a picture - 5:03
    • 5.5 Cropping a picture - 2:29
    • 5.6 Cropping pictures to shape - 3:22
    • 5.7 more picture effects and settings - 6:42
  • 6 Shapes, Borders, Backgrounds and Inserting Word and Excel
    • 6.1 Inserting shapes and using sample fill colours and grouping objects - 13:51
    • 6.2 Inserting and formatting shapes and its text - 9:21
    • 6.3 Inserting word and excel - 5:18
    • 6.4 Inserting and formatting callouts - 8:08
    • 6.5 Applying page background - 7:36
    • 6.6 Applying page borders - 8:19
  • 7 Master Pages, Spell Check Templates and Mail Merge
    • 7.1 Creating master pages - 14:12
    • 7.2 Running the spell check - 4:26
    • 7.3 Searching for templates and creating a mail merge with the wizard - 11:47
    • 7.4 Creating a mail merge manually - 10:08
  • 8 Design Checker, Embedded Fonts, Printing, Saving and Exporting
    • 8.1 Running the design checker - 4:16
    • 8.2 Managing embedded fonts - 2:46
    • 8.3 Printing the publication - 2:48
    • 8.4 Further saving and exporting options - 6:25
  • 9 Aligning, Anchor Points, Building Blocks, Captions and Hyperlinks
    • 9.1 Aligning objects - 5:01
    • 9.2 Using anchor points and creating new shapes - 14:41
    • 9.3 Creating building blocks - 3:12
    • 9.4 Adding captions and alternative text to images - 3:24
    • 9.5 Inserting hyperlinks - 2:18

View Full Curriculum


Access
Lifetime
Content
5.0 hours
Lessons
86

Microsoft Excel: Data Analysis with Pivot Tables

Master Excel Pivot Tables & Pivot Charts with Hands-On Demos

By Chris Dutton | in Online Courses

Pivot Tables are an essential tool for anyone who works with data in Excel. Pivots allow you to quickly explore and analyze raw data, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. So whether you're exploring product sales, analyzing marketing tactics, or wonder how Boston condo prices have trended over the past 15 years, Excel Pivot Tables provide fast, accurate, and intuitive solutions to even the most complicated questions. This course will give you a deep, 100% comprehensive understanding of Pivot Tables and Pivot Charts.

4.6/5 average rating: ★ ★ ★ ★

  • Access 85 lectures & 5 hours of content 24/7
  • Cover raw data structure, table layouts & styles
  • Explore design & formatting options
  • Understand sorting, filtering, & grouping tools
  • Analyze data from a number of real-world case studies including San Diego burrito ratings, shark attack records, MLB team statistics, & more
NOTE: Software NOT included.
Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: beginner
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2010-2019 or Office 365
  • Basic knowledge with Excel functionality

Course Outline

  • Getting Started
    • Course Structure & Outline - 1:32
    • Getting to Know the IMDb Movie Database - 2:21
    • Setting Expectations - 1:14
    • Important Note for StackSkills Students
  • PivotTable 101
    • Why PivotTables? - 4:10
    • Structuring the Source Data - 2:00
    • Inserting Your First PivotTable - 3:13
    • Navigating the Field List - 7:43
    • Analyze & Design Options - 1:33
    • Selecting, Clearing, Moving & Copying Pivots - 5:14
    • Refreshing & Updating Pivots - 7:30
    • PRO TIP: Dealing with Growing Source Data - 6:49
    • Removing & Reviving Data from Cache - 5:41
    • How PivotTables ACTUALLY Work - 3:39
    • QUIZ: PivotTable 101
    • HOMEWORK: PivotTable 101
  • PivotTable Formatting
    • Number Formatting - 2:12
    • PRO TIP: Formatting Empty Cells - 1:41
    • Table Layouts & Styles - 5:30
    • PRO TIP: Using Tabular Layouts to Create New Tables - 2:20
    • Customizing Headers & Labels - 1:16
    • Adding Conditional Formats - 6:51
    • PRO TIP: Data Bars with Invisible Text - 2:13
    • Advanced Conditional Formatting - 6:51
    • QUIZ: PivotTable Formatting
    • HOMEWORK: PivotTable Formatting
  • Sorting, Filtering & Grouping
    • Basic Sorting Options - 5:01
    • PRO TIP: Incorrect Alphabetical Sorting - 2:01
    • Label Filters & Manual Selections - 8:15
    • PRO TIP: Label Filters with Wildcards - 3:15
    • Value Filters - 3:10
    • PRO TIP: Enabling Multiple Filters - 2:42
    • Grouping Data - 3:23
    • Automatic Date Grouping - 4:25
    • Filtering with Slicers & Timelines - 4:51
    • Breaking Out Report Filter Pages - 4:13
    • QUIZ: Sorting, Filtering & Grouping
    • HOMEWORK: Sorting, Filtering & Grouping
  • Calculated Values & Fields
    • Summarizing Values - 4:45
    • PRO TIP: Avoiding the "Count Of" Trap - 3:49
    • "Show Values As" Calculations - 3:35
    • Show Values As: % of Column/Row - 3:47
    • Show Values As: % of Parent - 3:02
    • Show Values As: Difference From - 4:41
    • Show Values As: Running Total - 2:44
    • Show Values As: Rank - 2:36
    • Show Values As: Index - 8:06
    • Inserting Calculated Fields - 6:30
    • Calculations in Pivots vs. Raw Data - 4:32
    • Calculating Using Counts (Part 1) - 7:20
    • Calculating Using Counts (Part 2) - 4:19
    • Calculated Items (NOT RECOMMENDED) - 6:11
    • Solve Order & List Formula Tools - 4:54
    • QUIZ: Calculated Values & Fields
    • HOMEWORK: Calculated Values & Fields
  • Data Visualization with Pivot Charts
    • Intro to PivotCharts - 2:26
    • DEMO: Column Chart - 4:13
    • DEMO: Pie & Donut Charts - 5:46
    • DEMO: Clustered Bar Chart - 3:25
    • PRO TIP: Prevent Charts from Resizing with Cells - 4:45
    • Changing Chart Types on the Fly - 3:18
    • DEMO: Stacked Area Chart - 5:46
    • PivotChart Layouts & Styles - 4:03
    • Moving PivotCharts to New Sheets - 2:09
    • Applying Slicers & Timelines to Multiple Charts - 5:01
    • DEMO: Building a Dynamic Dashboard - 13:22
    • QUIZ: PivotCharts
    • HOMEWORK: PivotCharts
  • PivotTable Case Studies
    • Setting Expectations - 1:45
    • U.S. Voters (2012) - 10:33
    • HOMEWORK: U.S. Voters (2012)
    • San Francisco Salaries - 13:06
    • HOMEWORK: San Francisco Salaries
    • Shark Attack Records - 10:31
    • HOMEWORK: Shark Attack Records
    • Stock Market Data - 12:25
    • HOMEWORK: Stock Market Data
    • Baseball Team Statistics - 14:16
    • HOMEWORK: Baseball Team Statistics
    • San Diego Burrito Ratings - 16:40
    • HOMEWORK: San Diego Burrito Ratings
    • Daily Weather Conditions - 12:41
    • HOMEWORK: Daily Weather Conditions
    • Spartan Race Facebook Posts - 14:37
    • HOMEWORK: Spartan Race Facebook Posts
  • Wrapping Up
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
6.0 hours
Lessons
31

Microsoft SQL Server Development for Everyone!

Learn the Fundamentals of Database Design, Development & Querying Using Microsoft SQL Server

By Trevoir Williams | in Online Courses

This is a zero hero course on Microsoft SQL Databases and Querying. There are no pre-requisites for this course. This course provides you with fundamental SQL Server training and is enough to get you started as a Database Developer or Junior Database Administrator. We will explore best practices in database development using SQL Server Express 2017 (Free Edition) and will be building a small school management system database. At the end of this course, you should be comfortable writing queries for multiple situations and reports.

4.6/5 average rating: ★ ★ ★ ★

  • Access 31 lectures & 6 hours of content 24/7
  • Understand basic Database Design (tables, columns, data types, primary keys & more)
  • Query related data from multiple tables
  • Create relationships & foreign keys
  • Use aggregate functions in SQL
  • Export query results to Excel
  • Create complex database objects like stored procedures, functions, views & triggers
Trevoir Williams
4.5/5 Instructor Rating: ★ ★ ★ ★

Trevoir Williams is a Software Engineer and a part-time lecturer. With a Master's Degree in Computer Science, he has spent over a decade teaching Web, Software, and Database Development Courses. He also has as much industry experience in Web Application Development and Azure Cloud System and Server Administration. He enjoys teaching IT and Development courses and hopes to impart the latest in industry standards and knowledge to my students.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any device with basic specifications

Course Outline

  • Full Course
    • Introduction to SQL Server and Databases - 4:08
    • Download and Install SQL Server Express 2017 - 5:21
    • Connect to Database Instance and Create a Database - 5:55
    • Drop or Remove Database - 4:16
    • What is a Database Table? - 2:08
    • Create an SQL Database Table - 31:40
    • Insert Data into the Table with SQL Script - 15:03
    • Insert Data into the Table with Management Studio - 4:33
    • Select Data from the Table with SQL Script - 9:19
    • More Advanced Select Queries Part 1 - 17:50
    • Update Data in the Table - 9:49
    • Update Data in the Table with Management Studio GUI - 2:13
    • Delete Data from the Table with SQL Script - 6:27
    • Delete Data from the Table with Management Studio GUI - 1:23
    • What are Relationships, Foreign Keys and Normalization - 11:29
    • Create a Relationship in SQL Server - 19:24
    • Insert Records in Related Tables - 12:58
    • Run Queries on Related Tables (Inner Joins) - 19:22
    • Left, Right and Full Joins - 10:41
    • Grouping Data using SQL GROUP BY Clause - 11:41
    • SQL AVG Aggregate Function - 11:00
    • SQL COUNT Aggregate Function - 3:46
    • SQL MAX and MIN Aggregate Functions - 3:29
    • SQL SUM Aggregate Function - 4:02
    • Create and Manage Views - 23:12
    • Scalar Valued Functions - 26:52
    • Inline Table Valued Functions - 9:25
    • Multi Statement Table Valued Functions - 12:28
    • Stored Procedures - 27:38
    • Table Triggers - 19:13
    • Database Scripting, Backup and Restore - 14:35

View Full Curriculum



Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.