Courses

Microsoft Office 365 Integration and Teamwork

  • Learn Microsoft Office 365 Integration and Teamwork in 8 hours.

  • $225

    Call 865-282-1895 or email Jeremy at jnathan@jncomputertraining.com to schedule

  • Online or On-site, classroom training

    Everyone receives a workbook with live training

    Office 365:

    Sign-in, overview of apps, and what the apps accomplish

    Outlook:

    Filters and find, adding signature, out of office auto-reply, create folders, connect to OneDrive, calendars, groups, meetings, and contacts in People app

    OneDrive for Business:

    Unshared documents, saving documents, sharing documents, syncing on the computer, uploading and downloading files, organizing folders

    SharePoint:

    Sharing documents, calendars, discussion boards, adding apps, shared settings, and working concurrently with coworkers

    Teams:

    Create new team, add members to team, channels, audio and video chat, share files, share screen, install Apps, At Mention

    OneNote:

    Create and delete notebooks, pages, tables, formatting, adding pictures, audio and video, background graphics, tagging notes, export to PDF

Fundamentals Microsoft Office

  • Learn the Fundamentals of Microsoft Office in 8 hours.

  • $225

    Call 865-282-1895 or email Jeremy at jnathan@jncomputertraining.com to schedule

  • We provide laptops to use with on-site training

    Everyone receives a paperback workbook

    Windows:

    • Navigating in Windows, making new folders and sub-folders

    • Using the File Explorer for shared and computer drives

    Excel:

    • Create a basic spreadsheet

    • Make a chart to put in PowerPoint

    • Select, copy, paste

    • Save as a new file and as a PDF

    PowerPoint:

    • Templates, putting charts into presentation

    • How to create a simple slide show

    • How to take, edit and save screenshots on your computer

    • How to share your presentation

    • How to present a PowerPoint show

    • Recognize file extensions

    • Insert text, pictures, tables, videos of production processes

    • Format backgrounds and styles

    • Change font size and titles

    • Transitions, Animations and Running a Slide Show

    Word:

    • Search for documents on computer

    • Make a word document

    • Print

    • Format

    • Insert text, pictures, tables

    Outlook:

    • New email message to multiple recipients

    • Open and add attachment

    • Setting and accepting meeting requests

    • Sort and categorize emails by sender and by date

    • Signature line

Adobe Acrobat Pro DC PDF

  • Learn Adobe Acrobat Pro DC PDF in 8 days.

  • $225

    Call 865-282-1895 or email Jeremy at jnathan@jncomputertraining.com to schedule

  • Online or Laptops provided with on-site, classroom training

    Everyone receives a workbook with live training

    • Why and how to use PDF

    • Recent documents

    • Find and Advanced Search

    • Copy data from a pdf without losing formatting

    • Convert Word, PowerPoint, Excel files into PDFs

    • Create PDF from Microsoft Office documents

    • Export to Word, Excel and PowerPoint

    • Print to PDF

    • Create multiple PDFs

    • Combine files and PDFs

    • Editing text in scanned documents

    • Hyperlinks to other pages in PDF and to websites

    • Bookmarks to places in PDF

    • Making sticky notes

    • Highlight text

    • Inserting and editing pictures

    • Header and footer

    • Watermark

    • Compare two versions of a PDF to find differences

    • Create, fill, sign and send forms

    • Share PDFs to view, review, sign and track changes

Level 1 – Microsoft Excel Foundation

  • Learn the Foundations of Microsoft Excel in 8 hours.

  • $225

    Call 865-282-1895 or email Jeremy at jnathan@jncomputertraining.com to schedule

  • We provide computers to use with on-site and public training and everyone receives a paperback workbook

    • Developing a Workbook

    • Menus

    • Save in PDF format

    • Password Protection

    • Insert rows and sheets

    • Rename and delete sheets

    • Moving and sheet colors

    • Borders

    • AutoFit columns

    • Navigate

    • Name box

    • Shortcuts

    • Zoom

    • Custom Header/Footer

    • Charts and Sparklines

    • Watermark for printing

    • Formulas

    • Autofill

    • Remove Duplicates

    • Quick Access Toolbar

    • Customize Ribbon Tabs

    • Customize status bar

    • Paste Special & Transpose

    • Number Formatting

    • Hide columns and rows

    • Print & Formatting

    • Page Layout and Margins

    • Comments

    • Hyperlinks

    • Shading

    • Freeze data

    • Split Frames

Level 2 – Microsoft Excel PivotTables, PivotCharts and Macros

  • Learn Level 2 of Microsoft Excel in 8 hours.

  • $225

    Call 865-282-1895 or email Jeremy at jnathan@jncomputertraining.com to schedule

  • Laptops are provided to use with on-site, classroom training

    Everyone receives a paperback workbook, 8 hours

    1) Charts:

    • Filter/Sort, make tables out of data

    • Column, Bar, Line, Waterfall, Gantt, Pareto, Scatter, Control Charts

    • Excel templates, chart templates, snapshot in time charts

    • Sparklines

    • 3D Maps

    • Labels

    • Data callouts

    • KPI (Key Performance Indicators)

    • Forecast sheet

    • Goal seek

    • Scenario Manager

    • Password Protection

    2) PivotTables and PivotCharts:

    • Tables: why to use, naming, formatting

    • PivotTables: KPIs, filling in headings, clearing filters, copying

    • Cube functions: pointing to other Pivot Tables

    • Sum, count, average, min, max of data in PivotTables

    • Pivot Charts

    • Slicers

    • Date Slider

    3) Macros:

    • Developing a macro, macro enabled workbooks

    • Absolute vs Use Relative References in Macros

    • Macros to copy, paste, filter, sort, make charts

    • Macro shortcuts

    • Writing simple VBA code

    • Debugging VBA

    • Using macros in different Excel files

Level 3 – Excel Advanced Formulas

  • Learn Level 3 of Microsoft Excel in 8 hours.

  • $225

    Call 865-282-1895 or email Jeremy at jnathan@jncomputertraining.com to schedule

  • Online or laptops are provided to use on-site, 8 hours, $225

    Everyone receives a workbook with live training

    • Advanced shortcuts

    • Show formulas

    • Trace precedents and dependents

    • Evaluate formulas

    • Profit Margin formula

    • Custom number formats including hours, minutes and seconds

    • Autofill series

    • Data validation using formulas and error messages

    • Naming data and using in formulas

    • If and, not, iferror, averageifs, countifs, sumifs

    • Dsum, dcount, dcounta, dmin, dmax and daverage

    • Sumproduct

    • Formula errors

    • Nested formulas including if formulas with multiple outcomes

    • Date formulas including now, today, year, month, day

    • Calculating workdays between dates

    • Absolute, relative and mixed cell references

    • Advanced 3D referencing other files and sheets

    • Vlookup, Hlookup

    • Match, Index

    • Advanced Match to find every instance of a part number from a category or location Aggregate

    • Row

    • Goal Seek and Scenario Manager

    • Project Day Formulas

    • Watch Window

    • Round up or down

    • Conditional formatting based on other columns and criteria

    • Trim, Lower, Upper, Proper, Left, Search, Find, Right, Mid formulas

    • Spreadsheet compare

Level 5 – Excel Data Analysis and Visualization

  • Learn Level 5 of Excel in 2 days (16 hours).

  • $500

    Call 865-282-1895 or email Jeremy at jnathan@jncomputertraining.com to schedule

  • We provide computers to use with on-site training

    Everyone receives a paperback workbook, 2-days (16-hours)

    Part 1 – Importing data

    • Data analysis using Excel Pivot Tables with dashboards and slicers

    • Query SQL Server databases

    • Power Query to import individual Excel files from different folders

    • Importing CSV files and refreshing queries to automatically import data

    Part 2 – Cleanse Data

    • Formatting, cleaning and transforming data to make it ready to analyze

    • Importing reports and combining columns

    • Using Excel tables and creating automatic and manual relationships

    • Making a calendar and other data tables and importing lists of business data

    Part 3 – Model Data

    • Performance KPI Indicators for business activities

    • Create DAX (Data Analysis Expressions) calculated columns and measures

    • Analyzing 7-day, 10-day, 15-day, 30-day rolling averages in sales, inventory, labor hours, etc.

    • Analyzing year-to-year and month-to-month change in sales, expenses, labor hours, by products, departments, vendors, customers, etc.

    • Analyzing month-to-date, quarter-to-date, and year-to-date sales, expenses, labor hours

    • Analyzing percentage change of market share of your company year-to-year

    • Analyzing expansion of sales to new customers by units and dollar amounts

    • Analyzing repeat customer sales and periods where those customers had no sales

    • Financial report authoring

    • Advanced business ratios and dynamic ranking

    Part 4 – Visualize Data

    • Format Pivot Tables and Pivot Charts for reports

    • Slice and filter, group and summarize data using cube functions

    • Timelines in Pivot Tables

    • Create measures from Pivot Tables

    • Tableau Prep and Desktop – Data Visualization with Dashboards

Level 4 – Statistical Analysis in Excel

  • Learn Level 4 of Microsoft Excel in 8 hours.

  • $225

    Call 865-282-1895 or email Jeremy at jnathan@jncomputertraining.com to schedule

  • We provide computers to use

    Everyone receives a paperback workbook, 8 hours

    • Anova (Analysis of Variance)

    • F value

    • Sum of Squares Between groups

    • Sum of Squares Within groups

    • Degrees of Freedom

    • Null hypothesis

    • Mean squares due to treatments

    • Mean squares of errors

    • Variance formula

    • Covariance

    • Correlation

    • Descriptive Statistics

    • Exponential Smoothing

    • F-Test Two-Sample for Variances

    • Fourier Analysis

    • Histogram

    • Moving Average

    • Rank and Percentile

    • Regression

    • Sampling

    • t-Test Paired Two Sample for Means

    • t-Test: Two-Sample Assuming Equal Variances

    • t-Test: Two-Sample Assuming Unequal Variances

    • z-Test: Two Sample for Means

    • Line charts, chart shortcuts, formatting

    • Pie Charts

    • Pareto chart

    • KPI (Key Performance Indicators)

    • Gantt chart

    • Control chart

    • Scatter chart

PL-300 Power BI 3-day Training.

  • Learn Microsoft Power Bi in 3 days (24 hours) in-person or online.

  • $1,050

    Call 865-282-1895 or email Jeremy at jnathan@jncomputertraining.com to schedule

  • Each trainee receives a PDF of every Microsoft DAX formula, definition, syntax with examples

    We provide computers to use with on-site training at your workplace and at our site. Everyone receives a paperback workbook

    Part 1 – Importing data

    • Import multiple Excel and CSV files from multiple years, locations and tables

    • Connect to and import ERP data

    • Connect to data in SQL Server Analysis Services (SSAS)

    • Import reports and pivot and unpivot data

    • Import data from PDFs

    Part 2 – Transform, Cleanse, and Format Data

    • Manually create tables

    • Create custom columns

    • Duplicate queries

    • Append queries

    • Merge queries

    • Refresh queries

    • Manage relationships in tables

    Part 3 – Model Data

    • Administer business rules

    • Create calculated columns and measures using variable to make formulas understandable

    • DAX functions including sumx, averagex, sameperiodlastyear, datesytd, datesmtd, datesqtd, calculate,

    • blank, path, lookupvalue, switch, filter, countrows, rankx, allselected, all…

    • Time, part and corporate hierarchies

    Part 4 – Visualize Data

    • Make interactive dashboards containing charts, gauges and visuals

    • Set interactions between visuals

    • Insert text, images, titles, URLs

    • Drill down and up in visuals

    • Visualize data on maps

    • Power BI services: create workspaces, upload reports, upload dashboards, settings

    • Schedule auto refreshes of datasets

    • Export Power BI data into Excel

Power BI 1-day Training

  • Learn Microsoft Power Bi dashboard in 1 day in-person or online.

  • $225
    Call 865-282-1895 or email Jeremy at jnathan@jncomputertraining.com to schedule

  • Power BI Report in a Day Training

    1. Power Query

    Import CSV, Excel, files from a folder, PDF, and websites

    Use Power Query to transform data

    Work with Power Query steps

    Fill Empty Values

    Split Columns

    Rename Columns

    Change Data Types of Columns

    Add Columns from Examples

    Remove Rows and Columns

    Use First Rows as Headers

    Append Queries

    Make Conditional Columns

    View Query Dependencies

    2. Data Model and Visualization

    Create Clustered Column Charts

    Create Relationships in Data

    Create Calculated Columns

    Visual Filters

    Format Visuals

    Group Fields

    Make Tree map Visuals

    Drill-down in Visuals

    Visual Interactions

    Date Calendar

    Hide Fields in Report View

    Make Measures

    Conditional Formatting Visuals

    Use a Logo for Slicers

    Make Gauge Visuals

    Change Report Theme

    Change Colors of Visuals

    Add Text and Pictures to a Report

    Use Bookmarks

    3. Power BI Services

    Publish a Report

    Make a Dashboard

    Use Q&A in a Dashboard

    Generate Insights in a Dashboard

    Add Alerts to Reports and Dashboards

    Share Reports and Manage a Workspace

Tableau Prep and Desktop

  • Learn how to use Tableau in 2 days (16 hours).

  • $800

    Call 865-282-1895 or email Jeremy at jnathan@jncomputertraining.com to schedule

  • We provide laptops to use with on-site training

    Everyone receives a paperback workbook, 2 days (16 hours)

    Part 1 – Tableau Prep

    • Workspace

    • Connecting to data

    • Workflow

    • Cleaning, Shaping and Combining data

    • Grouping data

    • Output to Tableau Desktop

    Tableau Desktop:

    • Tableau Settings

    • Connecting to Excel, CSV, PDF and ERP data

    • Organizing data

    • Filtering data

    • Views

    • Measures

    • Cross tabs

    • Table calculations

    • Defining sets of subsets of data

    • Data and table calculations

    • Parameters

    • Data extracts

    • Comparing measures

    • Group data into categories and subcategories

    • Joins and union of data

    • Geocoding

    • Data distributions

    • Statistics

    • Forecasting

    • Column, bar, pie, scatter charts

    • Showing sales, expenses, inventory, on a world map

    • Heat maps

    • Tree maps

    • Dual-axis charts

    • Refreshing to import new data

    • Dashboards and stories to share visualizations

T-SQL Querying SQL Server Management Studio

  • Learn T-SQL Querying SQL Server Management Studio in 3 days (24 hours).

  • $1,500

    Call 865-282-1895 or email Jeremy at jnathan@jncomputertraining.com to schedule

  • Laptops are provided to use with on-site, classroom training, 2 days (16 hours)

    Day 1- Setup

    • Downloading and installing SQL Server Management Studio 2019, restoring a .bak file

    • Making new tables, query and joining multiple tables

    • Queries for finding parts of data such as characters

    • Create Transact-SQL SELECT FROM queries

    • INNER JOIN, LEFT, RIGHT, Self, FULL OUTER JOIN, CROSS JOIN, UNION, UNION ALL

    • DML (Data Manipulation Language) using OUTPUT, DDL (Data Definition Language)

    Day 2- Production

    • EXCEPT INTERSECT, NULL, ISNULL, NULLIF, IS NULL THEN, COALESCE

    • CASE WHEN THEN, ELSE, END

    • WHERE clause, ORDER BY, HAVING, Sort and filter data, EXISTS

    • CRUD (Create Read Update Delete) INSERT, UPDATE, DELETE

    • Table and column aliases

    • Use subqueries and APPLY, CROSS APPLY, OUTER APPLY

    • GROUP BY, GROUP BY ROLLUP, GROUPING SETS, GROUP BY CUBE, PIVOT, UNPIVOT

    • Temporary tables and non-relational data

    • Query and output JSON data and XML data

    • Create databases using SQL

    Day 3- Programming

    • Deterministic and non-deterministic functions, Windows, aggregate, date and time functions

    • SUM, AVG, PARTITION BY, ORDER BY, SELECT DISTINCT, ROW_NUMBER(), RANK()

    • ROWS BETWEEN __ PRECEDING AND __ FOLLOWING, DATEDIFF, LAG, LEAD, FIRST_VALUE,

    • LAST_VALUE CUME_DIST(), PERCENT_RANK(), DENSE_RANK, NTILE, OFFSET, FETCH, TOP, OVER

    • TRY CATCH, THROW, TRY_CAST, RAISERROR

    • Explanation and implementation of data types, VARCHAR, NVARCHAR, INT, FLOAT,REAL, CURSOR

    • Data type conversions CONVERT

    • Table-valued Functions, declare variables, control program flow, synonyms, BEGIN, COMMIT,

    • ROLLBACK Predicates: IN, EXISTS, BETWEEN, LIKE, ALL, ANY logicals: AND, OR, NOT

    • Transactions, looping, conditions, derived tables

    • Programming: create store procedures, user-defined functions, triggers and views, parameters

Machine Learning and Real-Time Streaming Analytics

  • Learn Machine Learning and Real-Time Streaming Analytics in 2 days (16 hours).

  • $800

    Call 865-282-1895 or email Jeremy at jnathan@jncomputertraining.com to schedule

  • Online or laptops are provided to use with on-site, classroom training - everyone receives a workbook with live training

    Advanced DAX in Excel and Power BI

    • Relationships in tables

    • Combining, appending, joining, unioning data-

    • Advanced filtering of tables

    T-SQL Data Analytics in SQL Server

    • Management Studio

    • Data analysis functions in SQL Server

    • Enable Python and R in SQL ServerPython pyodbc to connect to SQL Server and running Python programs in SQL Server

    M Power Query in Excel and Power BI

    • MDX and Edit M language

    • Import data from multiple websites at once and refresh

    Python in SQL Server, Visual Studio, Power BI and Tableau

    • How to download Anaconda, Python, Notepad++

    • PyCharm, Jupyter Notebook and PyTorch

    • PowerShell to install Pandas, Matplotlib, Numpy, TensorFlow, Keras, pywin32 Python script to fill in Nulls with column Averages

    • Custom Python Visuals: violin charts, swarmplots, pairplots, scatterplots

    • Python predictive analysis

    • Make user interface buttons in Power BI reports. TabPy in Tableau

    • Machine learning using Python predictive analysis in Jupyter Notebooks to predict defects training the computer to analyze pictures and then test inputting attributes like temperature, weight, dimensions, to predict defects

    R in SQL Server, Visual Studio, Visual Studio Code, R Studio, Power BI and Tableau R statistical analysis of data

    • How to download R, find and present business statistics using R

    • RStudio, import and analyze data using R script, ggplot2

    • Custom R Visuals: dual y-axis chart, boxplot, jitter, histograms, world maps, 3D scatter, corrplot Logistic Regression

    • Azure Real-time Streaming Analytics of production data in charts using ASQL and Power BI

See Our Full Course List Here