Microsoft Excel
Learn Excel essentials fast. Ideal for mastering spreadsheets, data analysis, and reporting efficiently.
Training Details
Training Details
Learn how to become a Microsoft Excel Expert Now
Our VA training starts when we have 20 students.
If not, we'll reschedule the start date.
with
2 Months Support
2 Months Support
Question and Answer
Why Choose
Why Choose
Choose our courses for a unique blend of expert insights, hands-on experience, and a supportive learning environment. Elevate your VA potential with us.
Worried about the quality of the lessons before enrolling?
We got you covered, here is a sample of video lesson about Basic Excel
Sample Lesson
Basic Parts of Excel
Meet Coach Chris, An Engineer by Profession, now a Virtual Assistant
7
days
days
Training Process
Training Process
Modules
23
100+ Pre Recorded Video Lessons
1
1.1 Basic Parts of Microsoft Excel Window
1.2 Saving a Document
1.3 Common Excel Shortcut
Course Topics Outline
Course Topics Outline
2
2.1 How to Input Text and Numeric Data in Excel
2.2 Using the AutoFill Command and Typing Dates
2.3 Understanding the Order of Operation
2.4 Constructing Basic Formulas in Excel
2.5 Distinguishing Between Relative and Absolute Cell References in Formulas
2.6 Adjusting and Editing Worksheet Contents
3
3.1 SUM Function
3.2 AutoSum Command
3.3 AVERAGE Function
3.4 MIN, MAX and COUNT Functions
4
4.1 Formatting Numbers, Text, Cells, Rows and Columns
4.2 Establishing Styles for Data Formatting
4.3 Using Conditional Formatting
5
5.1 Add, Name, Reorder, Delete, Hiding and Unhiding an Excel Worksheet
5.2 Copying and Moving Data
5.3 Hiding and Unhiding Excel Rows and Columns, Headings, Formula Bar, Gridlines, Ribbons, Quick Access Toolbar
6
6.1 Creating and Formatting Basic Charts
6.2 Adding and Modifying Data
6.3 Creating Pie Charts
6.4 Moving and Copying Chart to Another Worksheet
7
7.1 Inserting Images
7.2 Inserting Shapes
7.3 Inserting SmartArt
8
8.1 Printing and Publishing
8.2 Adding Header and Footer
8.3 Printing Multiple Sheets
9
9.1 Creating Mixed Cell Referencing
9.2 Working with Excel Online
9.3 Flash Fill
INTERMEDIATE LEVELTOPICS
10
10.1 Tools Used in Managing Large Sets of Data
10.1.1 Zoom Options
10.1.2 Freeze Panes
10.1.3 Split
10.2 Navigation Shortcuts
10.3 Grouping Data
10.4 Named Cells, Ranges, Constants, and Formulas
10.5 Working with Multiple Worksheet
10.5.1 Editing the Same Cell in Multiple Sheets
10.5.2 Opening Multiple Window
10.6 Find and Replace
11
11.1 Understanding Excel Data Lists
11.2 Single Level Sort in Sorting a List
11.3 Multi-Level Sort in Sorting a List
11.4 Using Custom Sort
11.5 Filter Data
11.6 Creating Custom Filter
12
12.1 Creating Subtotals in a List
12.2 Using Conditional Formatting to Find Duplicates
12.3 Removing Duplicates
12.4 Using Data Forms to Add and Edit Records
13
13.1 DSUM Function
13.2 DAVERAGE Function
13.3 DCOUNT Function
13.4 SUBTOTAL Function
14
14.1 TODAY Function
14.2 NOW Function
14.3 DATE Function
14.4 Using Counting Function
15
15.1 Understanding Data Validation
15.2 Creating a Dropdown List
15.3 Creating a Number Range Data Validation
15.4 Creating an Input and Error Message
15.5 Using Formulas as Validation Criteria
16
16.1 Creating Table
16.2 Renaming a Table
16.3 Format a Data List as Table
16.4 Converting a Table to a Range
16.5 Removing Duplicates
17
17.1 AGGREGATE
17.2 INDEX & MATCH
17.3 LOOKUP FUNCTIONS (Vlookup, Hlookup, Xlookup)
17.4 FILTER
17.5 IF, IFS
17.6 IF AND() and IF OR()
17.7 SUMIFS
17.8 COUNTIF, COUNTIFS
17.9 IFERROR
18
18.1 Importing Data from Text Files
18.2 Exporting Data to a Text File
19
19.1 Understanding PivotTables
19.2 Creating a PivotTable
19.3 Switching PivotTable Fields
19.4 Grouping PivotTable Data
19.5 Formatting a PivotTable
19.6 Modifying PivotTable Calculations
19.7 Filtering PivotTable Data
19.8 Creating Pivot Charts
19.9 Creating Slicers
19.10 Filtering Using the Slicer Tool
19.11 Inserting a Timeline Filter
20
20.1 Excel PowerPivot
20.2 Creating Data Models with PowerPivot
20.3 Creating PivotTables based on Data Model
20.4 Excel PowerPivot KPIs
21
21.1 Linking Worksheets
21.2 Linking Workbooks
21.3 Using Hyperlink
22
22.1 Inserting Page Breaks
22.2 Removing Page Breaks
22.3 Print Options
22.4 Setting Rows as Repeated Titles
22.5 Clearing Print Titles
23
23.1 MACRO Recording
23.2 Using Wildcards
23.3 Go To Special
23.4 Creating a Summary Worksheet
One Time Training Fee
One Time Training Fee
10,000
from
NOW FOR ONLY
NOW FOR ONLY
Learn Excel essentials fast. Ideal for mastering spreadsheets, data analysis, and reporting efficiently.
ABOUT US
The Mission behind
Sandbox VA
Platform
The Mission behind
Sandbox VA
Platform
Make VA Course Trainings Accessible
Elevate your VA skills with our user-friendly, inclusive training modules. Accessible learning for all in the digital workspace.
Grow a students community
Fuel your journey by joining our thriving student community. Collaborate, learn, and evolve together in the world of VA.
Student Course Feedback
Student Course Feedback
Explore genuine reflections from our students, highlighting how our courses have enriched their abilities, provided unmatched guidance, and set them on a path to a successful VA career.
Courses taught by industry leaders around the world
Courses taught by industry leaders around the world
Immerse yourself in a comprehensive learning experience, meticulously designed by top industry leaders from around the world. Each module offers a blend of expertise, real-world insights, and actionable strategies, ensuring you're not just learning, but preparing to excel in the
ever-evolving VA landscape.
Grow your career with Sandbox VA top-notch online courses
Grow your career with Sandbox VA top-notch online courses
With Sandbox VA, you're not just enrolling in any course—you're investing in a future of possibilities. Our top-notch online courses are curated to empower you with the skills, knowledge, and confidence to excel in the Virtual Assistant realm, opening doors to new opportunities and career heights
5K+
Happy Students
Happy Students
Our Company
Our Company
The Story Behind Sandbox VA In the heart of 2018, a vision took root: Sandbox VA. Initially emerging as a guiding star for those navigating the realm of product research, we realized the vast potential that lay ahead. This was more than just a platform; it was an opportunity to reshape the virtual landscape of the Philippines.
As the digital space evolved, so did our offerings. After successfully launching the product research course, we recognized the growing demand for diversified skills. With an unwavering commitment to excellence, we ventured into Amazon SEO and PPC, tailoring courses that melded theory with practical insights. But we didn't stop there. Understanding the global demand for diverse virtual assistance skills, we expanded our horizons. From Real Estate VA training to the intricacies of bookkeeping and the finesse of Excel, we ventured into the creative realms of graphics design, web design, and video editing.Each course was meticulously crafted, reflecting not just industry demands but also the aspirations of countless Filipinos eager to make their mark in the virtual world. With each new offering, we aimed to empower, educate, and elevate.Now, as we look back, our journey from that single product research course to an expansive portfolio is a testament to our dedication, innovation, and the trust of our ever-growing community. And as we continue to chart new territories, one thing remains constant: our commitment to making Sandbox VA the beacon for every aspiring VA in the Philippines.And the story continues, with many more chapters yet to be written...
About Us
Our Process
Our Services
Meet the Team
Contact Us
Follow us on
