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