Excel Courses
Learning Excel can be engaging, fun, and very profitable for your career. It’s expected that any professional in Marketing, Administration, Management, Human Resources, and, of course, Finance MUST have a fundamental expertise in using Excel.
Start NowOur Excel training program, designed by a Stanford University Graduate, Public Company Board Member,
and active Industry Executive, provides you with the exact skills you need today.
You will learn, step-by-step, exactly how to approach Excel use.
By eliminating the mystery of Excel and taking you inside the program, our instructors will provide you with
a complete and thorough understanding of the application
Basics of Excel
If you work with any numbers, you need to be comfortable using Microsoft Excel. You aren't expected to be a technical or accounting “whiz” to take complete control of the program to provide you with the results you require.
Our lesson format provides you a thorough and complete understanding of every element of Excel- and teaches you tips and short-cuts to make the complex simple. You'll be able to set up fully formatted Excel worksheets and workbooks complete with multi-cell formula creation and integration.
We’ll show you the secrets of the Function Wizard that will make your output look incredible (and be completely accurate.) You’ll learn how to construct powerful formulae easily and simply- allowing your Worksheets to look completely professionally done. Calculating statistics, amortizing, projecting future cash-flows, building entire business models- confidently and efficiently.
This is the course to learn Excel in the most rapid, thorough, and robust manner possible.
Intermediate Excel Skills
In addition to all of the above, the Intermediate Excel Course, will teach you sophisticated sorting, data analysis, custom chart design, graph development, linking and building multi-formula tools, 3-D charting, macro development, and the automation of frequently repeated functions with buttons.
Unless you intend to become a serious finance professional (a Senior Accountant or Chief Financial Officer) the skills you will gain in our Beginning and Intermediate Courses will provide you with everything you need to integrate Excel into your career.
Excel 2016 Beginner to Intermediate
Introductory Course for Excel 2016
Go from complete beginner to intermediate Excel user.
Excel 2016 Beginner to Intermediate
Introductory Course for Excel 2016
Understand the Backstage
- Understand the Backstage
- Encypt a document with a Password
- Open a new document
- Protect a current sheet
- Open an existing document
- Protect the structure of an entire workbook
- Use an Excel template
- Restrict access to a document
- Open recently opened spreadsheets
- Add a digital signature to a document
- Save a document
- Inspect a Document
- Print a document
- Check Accessibility of a document
- Share a document
- Check the compatibility of a document
- Export a document
- Recover an unsaved workbook
- Publish a document
- Choose options for Browser Viewing
- Use the Info Backstage
- Use Excel Options
- Mark a document as final
- Close a document
Excel 2016 Beginner to Intermediate
Introductory Course for Excel 2016
Understand the Home Tab
- Understand the Home Tab
- Insert a worksheet
- Use the Quick Access Toolbar
- Delete a cell
- Set the Display of the Ribbon
- Delete a row
- Use the Formula Bar
- Delete a column
- Enter Data into Cells
- Delete a worksheet
- Cut data from a cell
- Change the Row Height
- Copy data from a cell
- Set Row Height to AutoFit
- Paste data into a cell
- Change the Column Width
- Change the font style of a cell
- Set Column Width to AutoFit
- Change the font size of a cell
- Set a Default Cell Width
- Increase/Decrease Font Size
- Hide/Unhide Rows,Columns, and Sheets
- Apply a Bold font
- Rename a worksheet
- Apply an Italic font
- Move or Copy a worksheet
- Apply an Underline style
- Change the color of a worksheet's tab
- Apply a border to a cell
- Protect the worksheet
- Draw a custom border
- Use the AutoSum feature
- Change a cell border color
- Use the Fill feature
- Change a cell border line style
- Clear any formatting
- Apply a color fill to a cell
- Sort from A to Z
- Apply a text color to a cell
- Sort from Z to A
- Apply alignment options
- Apply a Custom Sort
- Change text orientation
- Apply a filter
- Decrease/Increase Indent
- Use the Find and Replace feature
- Wrap Text a Cell
- Use the Go To feature
- Merge Cells
- Use the Format Painter
- Apply a Number Format to Cells
- Paste all contents
- Apply Highlight Conditional Formatting
- Paste Only Formulas
- Apply Top/Bottom Conditional Formatting
- Paste Only Values
- Apply Data Bars Conditional Formatting
- Paste Only Formats
- Apply Color Scales Conditional Formatting
- Paste Only Comments
- Apply Icon Sets Conditional Formatting
- Paste Only Validation
- Apply a New Conditional Formatting Rule
- Paste All Contents with Formatting
- Clear Conditional Formatting Rules
- Paste All Contents Except Borders
- Use the Conditional Formatting Manager
- Paste Width of a Column
- Change the Format Style of a Table
- Paste Formulas and Number Formats
- Create a new table style
- Paste Only Values and Number Formats
- Create a new pivot table style
- Add Pasted Data
- Change the cell style
- Substract Pasted Data
- Create a new cell style
- Mutiply Pasted Data
- Merge a cell style
- Divide Pasted Data
- Insert a cell
- Skip Pasted Blank Data
- Insert a row
- Transpose Data
- Insert a column
- Paste Link Data
Excel 2016 Beginner to Intermediate
Introductory Course for Excel 2016
Understand the Insert Tab
- Understand the Insert Tab
- Insert a Hyperlink
- Insert a Table
- Insert a Text Box
- Insert a Picture
- Apply a Header & Footer
- Insert an online Picture
- Insert a WordArt
- Insert shapes
- Add a Signature Line
- Use a SmartArt
- Embed an Object
- Take a screenshot
- Use an Area of Circle equation
- Use an Office App
- Insert a Symbol
- Use a Recommended Chart
- Change Number Decimals
- Insert a Column Chart
- Set table style options
- Insert a Bar Chart
- Name a table
- Insert a line chart
- Change the table source data
- Insert an Area chart
- Remove double data from a table
- Insert a Combo Chart
- Convert a table into a range
- Insert a Pie Chart
- Refresh a table
- Insert a Line Sparkline
- Change the table style
- Insert a Column Sparkline
- Insert a Table Slider
- Insert a Win/Loss Sparkline
Excel 2016 Beginner to Intermediate
Introductory Course for Excel 2016
Understand the Page Layout Tab
- Understand the Page Layout Tab
- Apply a Background to a Document
- Change the theme of your document
- Print rows to repeat
- Search for a new theme
- Print columns to repeat
- Save a current theme
- Change the width of a document
- Change the color theme
- Change the height of a document
- Change the font theme
- Change the scale of the document
- Change the effect theme
- Show gridlines in a document
- Change the page margin
- Print gridlines in a spreadsheet
- Set a custom margin
- Show headlines in a spreadsheet
- Change the orientation
- Print headlines
- Change the page size
- Show an object to the front
- Set the Print area
- Show an object to the back
- Insert a Page Break
- Align objects
- Remove a Page Break
- Group objects
- Reset all Page Breaks
- Rotate an object
Excel 2016 Beginner to Intermediate
Introductory Course for Excel 2016
Understand the Formulas Tab
- Understand the Formulas Tab
- Filter Named References
- Use the Insert Function
- Edit a Named Reference
- Insert a formula
- Delete a Watch Window
- Use the AutoSum feature
- Change Number Decimals
- Use the SUM function
- Set a time and date cell format
- Use the AVERAGE function
- Use formula operations
- Use the IF function
- Understand the #DIV/0! Error message
- Apply a name reference to your data
- Understand the #NAME? Error message
- Create a name reference from selection
- Understand the #NULL! Error message
- Use the Name Manager
- Understand the #NUM! Error message
- Use Trace Precedents
- Understand the #REF! Error message
- Use Trace Dependents
- Understand the #VALUE! Message
- Remove Trace Arrows
- Use an Absolute cell reference
- Show Formula Equations
- Use the Text Function
- Use the Error Checking tool
- Use the Concatenate Function
- Evaluate a Formula
- Use the Trim Function
- Use the Watch Window
- Use the Proper Function
- Set Calculation options
- Use the Upper Function
- Use the Calculation Now feature
- Use the Lower Function
- Use the Calculate Sheet feature
- Use the VLOOKUP function
- Set up the Order of a Formula correctly using BOEMAS
- Use the HLOOKUP Function
Excel 2016 Beginner to Intermediate
Introductory Course for Excel 2016
Understand the Data Tab
- Understand the Data Tab
- Set Properties of an existing connection
- Import data from Access
- Use the Sort feature
- Import data from the Web
- Use the Filter feature
- Import data from Text
- Clear a filter
- Import data from XML
- Convert data into text type
- Add a workbook conecction
- Use the Flash Fill feature
- Remove workbook connection
- Remove data duplicates
- Refresh the workbook connection
- Create a data validation
Excel 2016 Beginner to Intermediate
Introductory Course for Excel 2016
Understand the Review Tab
- Understand the Review Tab
- Track changes in a spreadsheet
- Check the spelling in a document
- Protect Your Worksheet
- Research a word
- Unprotect Your Worksheet
- Use a synonym of a word
- Protect Your Workbook
- Translate text
- Unprotect Your Workbook
- Add a comment
- Share Your Workbook
- Delete a comment
- Protect Your Shared Workbook
- Show/Hide a comment
- Use the Ink Tool
- Show All Comments
Excel 2016 Beginner to Intermediate
Introductory Course for Excel 2016
Understand the View Tab
- Understand the View Tab
- Reset Excel views back to default
- Set the Workbook View
- Delete a Custom View
- Create a Custom View
- Show a Custom View
- Display the Ruler
- Remove the Ruler Display
- Display the Formula Bar
- Remove the Formula Bar Display
- Display Gridlines
- Remove the Gridlines display
- Display Headings
- Remove the Headings display
- Use the Zoom feature
- Revert Document to 100% Magnification
- View a new window in the current workbook
- Zoom into a Selection
- Arrange workbooks to view equally
- Freeze the Top Row
- Apply freeze panes
- Freeze the First Column
- Split the document
- Remove the Freeze Panes
- Hide/Unhide the current workbook
- Remove a Split from the Document
- View documents side by side
Excel 2016 Beginner to Intermediate
Introductory Course for Excel 2016
Excel 2016 Beginner to Intermediate
Introductory Course for Excel 2016
Understand Excel Options
- Understand Excel Options
- Flag repeated words
- Display the Mini Toolbar on selection
- Change the default Excel file format
- Show Quick Analysis options on selection
- Set the Save autorecover to a certain time limit
- Display a Live Preview on selection
- Change the default local file location
- Set a ScreenTip style option
- Change the language preferences
- Set the font style default
- Display chart elements on charts hover
- Set the Font size default
- Display data point values on charts hover
- Set the sheet view default
- Set the number of workbooks to show in Recent Workbooks list
- Set value for amount of worksheets in a workbook
- Set the Quick access to recent workbooks
- Change the theme of MS Office
- Display an amount of unpinned recent folders
- Set the Workbook Calculation
- Show the formula bar in the workbook
- Enable iterative calculation
- Show screentips for formulas
- Set formula options
- Show horizontal/vertical scroll bars
- Enable background error checking
- Show sheet tabs
- Apply error checking rules
- Display row/column headers
- Set AutoCorrect options
- Use the Zoom slider
- Set AutoFormat As You Type options
- Pin Excel to the taskbar
- Ignore words in Uppercase
- Unpin Excel from the taskbar
- Ignore words that contain numbers
- Use the Tell Us What you want to do feature
- Ignore Internet and file addresses
- Add Excel shortcut to desktop
Earn Your Certificate* of Proficiency from the London Business Institute
Upon completion of each Module of the Microsoft Business Productivity Suite, you will be presented with a Certificate of Proficiency, suitable for framing, memorializing your accomplishment- and your new Professional standing.
*Credit for this course is not transferable to some university programs, however, it is recognized world-wide as a statement of your commitment to bettering yourself, increasing your professional skills, and taking yourself to the highest level of achievement.
This Certificate of Proficiency is recognized by many international corporations including IBM, Coca-Cola, DHL, Procter & Gamble, LG, Hyundai, Deutsche Bank, Peugeot, Dell, KLM / Air France, Philips , BMW, Nestle, Sanofi Aventis and many others.