4 out of 5
4
6 reviews

Microsoft Excel

With no prior experience, you will have the opportunity to walk through hands-on examples with Hadoop and Spark frameworks, two of the most common in the industry. You will be comfortable explaining the specific components and basic processes of the Hadoop architecture, software stack, and execution environment. In the assignments you will be guided in how data scientists apply the important concepts and techniques such as Map-Reduce that are used to solve fundamental problems in big data. You’ll feel empowered to have conversations about big data and the data analysis process.

34 students enrolled

The primary goal of this quick start guide is to introduce you to Unreal Engine 4’s (UE4) development environment. By the end of this guide, you’ll know how to set up and develop C++ Projects in UE4. This guide shows you how to create a new Unreal Engine project, add a new C++ class to it, compile the project, and add an instance of a new class to your level. By the time you reach the end of this guide, you’ll be able to see your programmed Actor floating above a table in the level.

This quick start guide shows you how to add assets to your Unreal Engine (UE4) games. By the end of this guide, you’ll know how to use the Project Browser to create new projects and navigate the Content Browser to find and add content. You’ll also know where to find information on the FBX Content Pipeline while learning how to use the Material Editor to modify Materials before applying them to a Static Mesh Actor.

Main Features

  • Achieve Hollywood best quality visuals out of the box.
  • With complete C++ source code access, you can study.
  • Comes with designer-friendly Blueprint visual scripting.
  • Unreal Engine provides Robust Multiplayer Framework.
  • The built-in Cascade visual effects editor enables particles.
  • Unreal Engine 4’s Material Editor makes use of physically-based.

What is the target audience?

  • You might be thinking, all of the above – and that is fine. But as a complete beginner learning Unreal Engine 4.
  • The rendering system in Unreal Engine 4 is an all-new, DirectX 11 pipeline that includes deferred shading.

Learning a new game engine as a complete beginner is very intimidating. There are a lot of tutorials, documentation and advice already out but how do you start and proceed with learning Unreal Engine 4 is unclear. You get pulled into many different directions and end up confused and overwhelmed.

I have spent a lot of time deconstructing what it takes to learn a game engine from scratch. What it is that you should focus on first and what you should avoid until later.

Excel Fundamentals

1
Understand the Excel Ribbon and Screen
10Mins
2
How to create blank & template-based workbooks in Excel
20Mins
3
How to Navigate Worksheets in Excel
15Mins
4
How to Open Workbooks in Excel
20Mins
5
How to Save Workbooks in Excel
15Mins
6
How to AutoRecover Excel Files
15Mins
7
How to Use The Quick Access Toolbar in Excel
15Mins
8
How to Print in Excel
15Mins
9
How to Get Help in Excel
10Mins
10
How to Close and Exit from Excel
10Mins

Edit a Workbook

1
How to Select Cells and Ranges in Excel
15Mins
2
How to Edit Cell Data in Excel
15Mins
3
How to Cut, Copy, and Paste in Excel
15Mins
4
How to Use Undo, Redo, Repeat Commands in Excel
5
How to Use Special Paste Options in Excel
15
6
How to Insert and Move Cells in Excel
15Mins
7
How to Delete Cells in Excel
10Mins
8
How to use Excel’s spell check to proof your worksheets for spelling errors.
10Mins
9
How to Hide Columns and Rows in Excel
15Mins
10
How to View and Edit Document Properties in Excel
15Mins

Basic Formulas

1
How to Create Basic Formulas in Excel
20Mins
2
How to Use AutoFill in Excel
15Mins
3
How to Use Sum and Average Formulas in Excel
20Mins
4
How to Use MIN and MAX Functions in Microsoft Excel
15Mins
5
How to Use the COUNT Function in Excel
10Mins

Basic Formatting

1
How to Apply Formatting to Text in Excel
15Mins
2
How to Merge Cells in Excel
20Mins
3
How to Format Numbers and Dates in Excel
15Mins
4
5
How to Copy Formatting in Excel
10Mins
6
How to Adjust Row Heights and Column Widths in Excel
15Mins

Insert Objects

1
How to Insert Images in Excel
10Mins
2
How to Insert and Format Shapes in Excel
15Mins
3
How to Insert Hyperlinks in Excel
10Mins
4
How to Adjust Object Properties and Alt Text in Excel
15Mins

Manage Worksheets

1
How to Change Worksheet Views in Excel
10Mins
2
How to Work with Multiple Windows in Excel
15Mins
3
How to Move and Copy Worksheets in Excel
10Mins
4
How to Insert, Rename, and Delete Worksheets in Excel
20Mins
5
How to Freeze and Unfreeze Rows and Columns in Excel
15Mins
6
How to Hide Worksheets and Gridlines in Excel
10Mins

Charts

1
How to Move and Resize a Chart in Excel
10Mins
2
How to Change Chart Types in Excel
10Mins
3
How to Apply Chart Layouts and Styles in Excel
15Mins
4
How to Customize Chart Titles and Legends in Excel
20Mins
5
How to Display Chart Gridlines, Labels, and Data Tables in Excel
20Mins
6
How to Format Chart Data in Excel
15Mins
7
How to Modify Chart Data in Excel
20Mins
8
How to Add Trendlines in Excel
20Mins
9
How to Create Dual-Axis Charts in Excel
20Mins
10
How to Create Chart Templates in Excel
20Mins
11
How to Add Sparklines in Excel
15Mins

Print and Distribute

1
How to Adjust Page Size and Scale in Excel
20Mins
2
How to Set Print Area and Page Breaks in Excel
20Mins
3
How to Print Titles, Gridlines, and Headings in Excel
20Mins
4
How to Add Headers and Footers in Excel
20Mins

Intermediate Formulas

1
How to Reference External Worksheets in Excel
20Mins
2
How to use Absolute and Relative Cell References in Excel
20Mins
3
Order of Operations in Excel
20Mins
4
How to Add Cell and Range Names in Excel
20Mins
5
How to Insert Functions in Excel
20Mins
6
How to use the Concatenate Text Function in Excel
20Mins
7
How to Use the PMT Function in Excel
20Mins
8
How to Display Formulas in Excel
20Mins
9
How to Use Date Formulas in Excel
20Mins

Manage Data

1
How to use Quick Analysis too to format your data into a chart table or sparkline.
20Mins
2
How to Use the Outline and Subtotal Features in Excel
20Mins
3
How to Use Data Validation Rules in Excel
20Mins
4
How to Use Flash Fill in Excel
10Mins
5
How to Import and Export Excel Data
20Mins

Tables

1
How to Insert a Table in Excel
20Mins
2
How to Sort Data in Excel
10Mins
3
How to Filter Data in Excel
10Mins
4
How to Remove Duplicates in Excel
10Mins
5
How to Use Slicers in Excel
20Mins
6
How to Use Structured References in Excel
20Mins

Intermediate Formatting

1
How to Apply Conditional Formatting in Excel
20Mins

Collaboration

1
How to Add Edit and Delete Cell Comments in Excel
20Mins
2
How to Share Workbooks in Excel
20Mins
3
How to Use Version History in Excel
20Mins
4
How to Protect a Worksheet in Excel
20Mins
5
How to Protect a Workbook’s Structure in Excel
20Mins
6
How to Add Password Protection in Excel
10Mins

PivotTables

1
How to Create PivotTables in Excel
20Mins
2
How to Add Multiple PivotTable Fields to a PivotTable in Excel
20Mins
3
How to Add and Remove Calculated Fields in Excel PivotTables
20Mins
4
How to Use the GETPIVOTDATA Function in Excel
20Mins
5
How to Filter PivotTables in Excel
20Mins
6
How to Group Values in Excel
15Mins
7
How to Refresh a PivotTable in Excel
20Mins
8
How to Format a PivotTable in Excel
20Mins

PivotCharts

1
How to Create PivotCharts in Excel
20Mins

Troubleshoot Formulas

1
How to Fix Formula Errors in Excel
20Mins
2
How to The Watch Window in Excel
10Mins
3
How to Evaluate Formulas in Excel
10Mins

Advanced Formatting

1
How to Customize Conditional Formatting in Excel
10Mins
2
How to Use Conditional Formatting with Formulas in Excel
10Mins
3
How to Use International Currency and Formats in Excel
20Mins
4
How to Create and Apply Color Schemes in Excel
20Mins
5
How to Create and Apply Custom Themes in Excel
20Mins
6
How to Form Controls in Excel

Advanced Formulas

1
How to Use the IF Function in Excel
15Mins
2
How to Insert Nested Functions in Excel
10Mins
3
How to use AND OR and NOT Functions in Excel
10Mins
4
How to Use SUMIF AVERAGEIF and COUNTIF Functions in Excel
20Mins
5
How to Use the VLOOKUP Function in Excel
20Mins
6
How to Use HLOOKUP in Excel
20Mins
7
How to Use the INDEX and MATCH Functions in Excel
30Mins
8
How to Use UPPER, LOWER, and PROPER Functions in Excel
20Mins
9
How to Use RIGHT, LEFT, and MID Functions in Excel
20Mins
10
How to Change Formula Calculation Options in Excel
20Mins

Analyze Data

1
How to use Goal Seek feature in Excel
20Mins
2
How Use to Scenario Manager in Excel
30Mins
3
How to Consolidate Data in Excel
30Mins

Macros

1
2
How to Create Macros in Excel
30Mins
3
How to Modify Macros in Excel
30Mins
Faq Content 1
Faq Content 2
Faq3
Faq 4

Productivity Hacks to Get More Done in 2018

— 28 February 2017

  1. Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
  2. Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
  3. Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!


4
4 out of 5
6 Ratings

Detailed Rating

Stars 5
3
Stars 4
0
Stars 3
3
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
Course available for 30 days
30-Day Money-Back Guarantee

Includes

9 hours
Full lifetime access
Access on mobile and TV

Members

Who’s Online

There are no users currently online

Recently Active Members

Microsoft Excel
Price:
₦2,000