Remote Training Instructions

Can't login to the portal?

• Do not use Incognito/InPrivate browser mode.

• Ensure your browser isn't configured to block cookies (including 3rd party).

• In addition, corporate VPNs and Security Settings might block asses to sites and files.

• • We recommend using public internet (not via VPN) and modifying security settings if possible.

Can't see your enrolments in the portal?

• You may be in Billing Contact mode.

• Switch the toggle to Student to view your course details.

Download your Software and Exercise Files

• Do not wait until your course date to get set up - get started now!
  
  
• Select your course below and follow the instructions.

Excel Courses - Beginner to Advanced

• Microsoft Excel
  • Do you have the latest version of Excel installed?
  • Are you licensed to use it?
  • Excel Advanced & Expert courses: Excel 2016 or later Windows stand alone versions or Microsoft 365 subscription plans required.
  • Excel Expert remote users will need to download and install Power Automate Desktop.
    
    

• Browser:
  • Use Chrome, Edge or FireFox.
  • Is your browser up to date?
  • Internet Explorer is not compatible with our delivery technologies

• Windows
  • Are you using Windows 10? - highly recommended.

• Download and Unzip Files
  • Login to your student portal, Nexacu Hub.
  • Click on the "Materials" tab.

• • Download your exercise files. 
  • Extract your Exercise Files to the specified folder below:

• How to save files to the folder specified above:

• • On your computer (in This PC) create a folder called Exercise_Files_All_Courses
  • Create another folder under this called Excel Exercise Files.
  • All files should be unzipped or copied to this folder.

• macOS - If you are using an apple device:
  • Use Safari or similar modern browser
  • Training experience may diminish due to different features and appearance
  • Nexacu's trainers are unable to provide detailed guidance for macOS

Power BI Courses - Beginner to Advanced

• Power BI
  
  • Install the latest Power BI Desktop (available for windows only)
  • https://powerbi.microsoft.com/en-us/downloads/
  • Power BI Beginner course: 32 or 64 bit version required
  • Power BI Intermediate to DAX courses: 64 bit version strongly recommended, not 32 bit. 
  • To find the Power BI Desktop version you are running, open the app, click on the Help tab and select About.

• Download and Unzip Files
  • Login to your student portal, Nexacu Hub.
  • Click on the "Materials" tab.

• • Download your exercise files. 
  • Extract your Exercise Files to the specified folder below:

• Power BI Beginner:
  • optional install of Analyze in Excel (plug-in).
  • Not mandatory for successful course participation
  • Direct download (click on this link) or
  • start from the Power BI Service (see this screenshot and this article)

Power BI DAX Course

• Power BI
  
  • Install the latest Power BI Desktop (available for windows only)
  • https://powerbi.microsoft.com/en-us/downloads/
  • Power BI Intermediate to DAX courses: 64 bit version strongly recommended, not 32 bit. 
  • To find the Power BI Desktop version you are running, open the app, click on the Help tab and select About.

• Install DAX Studio.
  • https://daxstudio.org/ (click on the green button to download the installer)

• Download and Unzip Files
  • Login to your student portal, Nexacu Hub.
  • Click on the "Materials" tab.

• • Download your exercise files. 
  • Extract your Exercise Files to the specified folder below:

Microsoft 365 Courses

• Microsoft Teams
  
  • Install the Microsoft Teams desktop application.

• Download and Unzip Files (Advanced Only)
  • Login to your student portal, Nexacu Hub.
  • Click on the "Materials" tab.

• • Download your exercise files. 
  • Extract your Exercise Files to the specified folder below:

Teams Courses

• Microsoft Teams
  
  • Install the Microsoft Teams desktop application.

• Access your Course Guide
  • Login to your student portal, Nexacu Hub.
  • Click on the "Materials" tab.
  • Access your Course Guide

Power Automate Courses

• Microsoft Teams
  
  • Install the Microsoft Teams desktop application.

• Download and Unzip Files
  • Login to your student portal, Nexacu Hub.
  • Click on the "Materials" tab.

• • Download your exercise files. 
  • Extract your Exercise Files to the specified folder below:

SharePoint Courses

• Download and Unzip Files
  • Login to your student portal, Nexacu Hub
  • Click on the "Materials" tab.
  • Download your exercise files. 
  • Extract your Exercise Files to the specified folder below:

 Power Apps Courses

• Microsoft Teams
  
  • Install the Microsoft Teams desktop application.

• Download and Unzip Files
  • Login to your student portal, Nexacu Hub.
  • Click on the "Materials" tab.

• • Download your exercise files. 
  • Extract your Exercise Files to the specified folder below:

Microsoft Project Courses

• Project
  
  • Install Microsoft Project desktop application (Windows only)
    • click here for detailed instructions.
  • Do you have a valid license: Project Standard or Professional, or Project Plan 3 or Plan 5 (not Plan 1)?

• Download and Unzip Files
  • Login to your student portal, Nexacu Hub.
  • Click on the "Materials" tab.

• • Download your exercise files. 
  • Extract your Exercise Files to the specified folder below:

R Programming Courses

R Programming Basics

• Install R - https://cran.csiro.au/ - select base
• Install RStudio - https://rstudio.com/products/rstudio/ - RStudio Desktop (open source ed.)
• Install Hmisc and psych packages. Open up RStudio and go to Tools > Install Packages. Under Packages, type in 'Hmisc'.  Repeat this process for 'psych'.
  • If you have difficulty installing the packages, go to Tools > Global Options > Packages and untick 'Use secure download method for HTTP'.

R Programming Beginner

• Install R and R Studio (see links above)
• Install the tidyverse Open up RStudio and go to Tools > Install Packages. Under Packages type 'tidyverse'. 

R Programming Intermediate

• Install R and R Studio (see links above)
• Install the Hmisc and tidyverse packages (see instructions above)

Machine Learning in R

• Install R and R Studio (see links above)
• Install Power BI Desktop (see Power BI section above)
• Download dataset from:
  • https://archive.ics.uci.edu/ml/datasets/bike+sharing+dataset
• Go to Data Folder and download the zip file. We will be working with the hour file.
• Run the following in RStudio (or install each of these packages):

install.packages("DescTools")

install.packages("factoextra")

install.packages("tidyverse")

install.packages("rfm")

install.packages("cluster")

install.packages("rpart")

install.packages("rpart.plot")

install.packages("caret")

install.packages("ranger")

install.packages("Metrics")

install.packages("randomForest")

• Test R scripts in Power BI
  • Please run the following test to ensure that Power BI is detecting your installation of R and installed contributed packages.
  • You must have installed the tidyverse package to your machine prior to running this script. If you have not done this already, please install it from RStudio and then do the following.
    • Open the Power BI file named Test.
    • Click on Transform Data.
    • With the query, Test selected:
    • Click on Run R Script
    • This will open a window. Under the existing text, copy in the following:

library(tidyverse)

y <- dataset %>% sqrt

• If you are asked about privacy levels, grant access or ignore.
• If this is successful, you should see a table containing the square roots of the numbers 1-10.
• If it fails and returns an error, please email [email protected].

Python Courses

• Download and install Anaconda Individual Edition from https://www.anaconda.com/products/individual

• Download and Unzip Files
  • • Login to your student portal, Nexacu Hub.
    • Click on the "Materials" tab.

  

  • • Download your exercise files. 

• Python Intermediate
  • You can work in a new or existing Anaconda environment.
  • Ensure the following packages are installed:
    • pandas
    • NumPy
    • Matplotlib
    • scikit-learn
    • Bokeh

SQL Courses

• Download and install Azure Data Studio.

• Download and Unzip Files

• • • Login to your student portal, Nexacu Hub.
    • Click on the "Materials" tab.
    • Download your exercise files. 

  

 Excel Specialist - Analysis and Dashboards

• Microsoft Excel
  • Do you have the latest version of Excel installed?
  • Are you licensed to use it?

• Browser:
  • Use Chrome, Edge or FireFox.
  • Is your browser up to date?
  • Internet Explorer is not compatible with our delivery technologies

• Windows
  • Are you using Windows 10? - highly recommended.

• Download and Unzip Files
  • Login to your student portal, Nexacu Hub.
  • Click on the "Materials" tab.

• • Download your exercise files. 
  • Extract your Exercise Files to the specified folder below:

• macOS - not suitable for this course. 

 Excel Specialist - Financial Modelling

• Microsoft Excel
  • Do you have the latest version of Excel installed?
  • Are you licensed to use it?

• Browser:
  • Use Chrome, Edge or FireFox.
  • Is your browser up to date?
  • Internet Explorer is not compatible with our delivery technologies

• Windows
  • Are you using Windows 10? - highly recommended.

• Download and Unzip Files
  • Login to your student portal, Nexacu Hub.
  • Click on the "Materials" tab.

• • Download your exercise files. 
  • Extract your Exercise Files to the specified folder below:

Excel Specialist -VBA

• Microsoft Excel
  • Do you have the latest version of Excel installed?
  • Are you licensed to use it?

• Browser:
  • Use Chrome, Edge or FireFox.
  • Is your browser up to date?
  • Internet Explorer is not compatible with our delivery technologies

• Windows
  • Are you using Windows 10? - highly recommended.

• Download and Unzip Files
  • Login to your student portal, Nexacu Hub.
  • Click on the "Materials" tab.

• • Download your exercise files. 
  • Extract your Exercise Files to the specified folder below:

Visio Courses

• Install Microsoft Visio desktop application (Windows only) – click here for instructions (Subscription version)
• Do you have a valid license: Visio Plan 2 ?

• Download and Unzip Files
  • Login to your student portal, Nexacu Hub.
  • Click on the "Materials" tab.

• • Download your exercise files. 
  • Extract your Exercise Files to the specified folder below:

Word Courses

• Microsoft Word
  • Do you have the latest version of Word installed?
  • Are you licensed to use it?

• Browser:
  • Use Chrome, Edge or FireFox.
  • Is your browser up to date?
  • Internet Explorer is not compatible with our delivery technologies

• Windows
  • Are you using Windows 10? - highly recommended.

• Download and Unzip Files
  • Login to your student portal, Nexacu Hub.
  • Click on the "Materials" tab.

• • Download your exercise files. 
  • Extract your Exercise Files to the specified folder below:

• macOS - If you are using an apple device:
  • Use Safari or similar modern browser
  • Training experience may diminish due to different features and appearance
  • Nexacu's trainers are unable to provide detailed guidance for macOS

Power Point Courses

• Microsoft PowerPoint
  • Do you have the latest version of Power Point installed?
  • Are you licensed to use it?

• Browser:
  • Use Chrome, Edge or FireFox.
  • Is your browser up to date?
  • Internet Explorer is not compatible with our delivery technologies

• Windows
  • Are you using Windows 10? - highly recommended

• Download and Unzip Files
  • Login to your student portal, Nexacu Hub.
  • Click on the "Materials" tab.

• • Download your exercise files. 
  • Extract your Exercise Files to the specified folder below:

• macOS - If you are using an apple device:
  • Use Safari or similar modern browser
  • Training experience may diminish due to different features and appearance
  • Nexacu's trainers are unable to provide detailed guidance for macOS

Your Virtual Classroom

• Find your meeting link in your Final Confirmation Email or in your Nexacu Hub.

• Join your class at least 15 mins. before your class start time.

What to do on Training Day

• Join your class at least 15 mins. before the start time.

• Keep your microphone on mute unless speaking.
• Keep your webcam on for a more interactive learning experience.

• Ask questions and participate as you would in the classroom.
• Let the trainer know if you:
  • can’t hear or see something,
  • have difficulty with any exercises.

• While the trainer is sharing their screen, you can zoom and pan around using your mouse.
  • hold Ctrl and use the mouse wheel to zoom in or out,
  • hold Ctrl and press the plus and minus

How to join class with Teams

1. Find your meeting link in your Final Confirmation Email or in your Nexacu Hub.
2. Click on the link to join your session using Microsoft Teams.
3. Teams can be accessed via the Desktop Application or the Browser.

If you have Teams installed and are logged in under your work or school account: 

• Click on your meeting link, you will be taken to:
  • Teams desktop or
  • a browser prompt to open Microsoft Teams.
• Proceed as normal to join the meeting.

• After clicking the meeting link your browser will open.
• Cancel any prompt to open or download Microsoft Teams.
• Click Continue on this browser.

• Allow access to your microphone and camera.
• Enter your full name in the Enter name box (unless you are automatically signed in).
• Turn on your webcam.
• Mute your microphone.

• Click Join now.
• Wait in the lobby, your trainer will let you into the meeting!