Excel for Beginners Course
Regardless of your previous experience with Excel, our Excel Beginner course is the perfect starting point. Start by diving into the fundamentals and then progress to the most advanced features, covering everything you need to know about Excel. Learn to create spreadsheets and master the basics, even if you've never seen a spreadsheet before!
Check the course content
- Introduction
- Launching Excel
- Start-Up Screen
- The Excel Interface
- The Quick Access Toolbar
- The Ribbon
- Creating New Excel Workbooks
- Saving Excel Files
- Opening Excel Files
- Beginner Shortcut Keys
- Entering Text
- Working with Numbers
- An Introduction to Dates
- Find and Replace
- Sorting Data
- Working with Cell References
- Relative Versus Absolute Cell Reference in Formulas
- Understanding the Order of Operation
- The structure of an Excel Function
- Working with the Sum Function
- Working with Min and Max
- Working with Averages
- Working with Count and CountA
- Moving and Copying Data
- Inserting and Deleting Rows and Columns
- Changing the Width and Height of Cells
- Hiding and Unhiding Rows, Columns and Sheets
- Renaming Worksheets
- Deleting Worksheets
- Moving and Copying Worksheets
- Adding Borders to Cells
- Formatting Percentages
- Merging and Centering Cells
- A Quick Look at Styles
- Basic Conditional Formatting
- Inserting Images and Shapes
- Working with SmartArt
- Print Preview
- Margins, Scaling and Orientation
- Printing
- Intro to Excel Templates
- Opening an Existing Template
- Creating a Custom Template
- Conclusion
Advanced Excel Course
Tailored for those with limited experience in Excel, this program will make you proficient in database functions, advanced calculations with SumIFs, and leveraging PivotTables for insightful data analysis. Dive into the world of automation, streamlined tasks, and revolutionized workflows with Excel's advanced features. By the time you reach the course's conclusion, you'll not only have a firm grasp of the Excel basics but also be able to enhance productivity using its advanced capabilities.
Check the course content
- Excel Intermediate Introduction
- Intermediate Shortcut Keys
- What are Lists
- Sorting a List
- Sorting - Multiple Criteria
- Custom Sort
- What are Filters
- Format a List as a Table
- Introduction to DataBase Functions
- DSum Function
- DSum Function - Single Criteria
- DSum Function - Multiple Criteria
- DAverage
- DCount Function
- Subtotal
- Data Validation - List
- Data Validation - Decimal
- Input and Error Messages
- Importing Data from Text Files
- Importing Data from MS Access
- Exporting Data to a Text File
- Creating Basic Charts
- The Chart Ribbon
- Adding and Modifying Data on a Chart
- Formatting Charts
- Understanding Pivot Tables
- Creating Pivot Tables
- Pivot Table Calculations
- Grouping Pivot Table Data
- Formatting Pivot Table Data
- Drilling Down into Pivot Table Data
- Creating Pivot Charts
- Filtering Pivot Table Data
- Filtering Using the Slicer
- Grouping Data
- Consolidating Data
- VLookUp
- HLookUp
- Index and Match
- FV Function
- PMT Function
- Hyperlinks
- Text to Columns
- Conclusion
Expert Excel Course
Explore advanced VLookUps, Index, Match, and their advanced counterparts to step up your Excel proficiency. Dive into tracking workbooks between teams, teaching you to automate and streamline workflows, and gain expertise in techniques that revolutionize your approach to Excel. With this course, you will ensure you're well-versed in advanced spreadsheet functionalities.
Check the course content
- Excel Advanced Introduction
- Advanced Shortcut Keys
- Tracing Precedents
- Tracing Dependants
- Watch Window
- Show Formulas
- Protecting Cells in a Worksheet
- Protecting the Workbook Structure
- Encryption with Passwords
- Name Ranges
- Simple IF Function
- IF, AND
- IF, OR
- Nested Formulas
- CountIF and CountIFs
- SumIF and SumIFs
- Advanced VLookUp
- IF and IS Error - Part 1
- IF and IS Error - Part 2
- Advanced Index Match
- Dates - Part 1
- Dates - Part 2
- Replace and Substitute - Part 1
- Replace and Substitute - Part 2
- Left, Right and Mid Function
- Search Function
- Concatenate and Search
- Indirect - Static
- Indirect - Dynamic
- Goal Seek
- Data Tables
- Scenarios
- Solver
- Conclusion
- Building a Mini Dashboard
Excel VBA Programming Course
Immerse yourself in the world of Excel VBA programming, gaining advanced capabilities for efficient and effective spreadsheet management. This course goes well beyond the basics, offering insights into automation, customization, and creating powerful macros. Enhance your Excel skills and unlock the potential for more dynamic and tailored spreadsheet solutions.
Check the course content
- What is VBA
- Object Orientated Programming
- Macros Initial Setup
- Recording a Macro
- Saving a Macro
- Launching VBA
- VB Editor
- Custom Menu
- Naming Projects
- Modules
- Code Window
- Comments
- Introduction Variables and Procedures
- Variables
- Variables Exercise
- What are Procedures
- What are Procedures - Part Two
- What are Procedures - Part Three
- Message Boxes
- Input Box
- Input Box - Part Two
- Basic Navigation
- Sheets
- Cell Navigation
- Advanced Sheets
- Offset
- Introduction Loops and IF Statements
- Operators
- Using Variables
- What is Automation
- For Loop
- Do Loop
- IF Statements
- IF Statements - Part Two
- Select Case
- Debugging
- UDFs
- Introduction Assignments
- Exercise 1 - Record a Macro
- Exercise 2 - Duplicating Data
- Exercise 3 - Generate a Report
- Generate a Report - Part Two
- Exercise 4 - Inner and Outer Loops
- Inner and Outer Loops - Part Two
- Inner and Outer Loops - Part Three
- Inner and Outer Loops - Part Four
- Inner and Outer Loops - Part Five
- Form Controls
- Building the Form
- Initialize the Form
- Command Buttons
- Command Buttons - Part Two