Microsoft Excel Training by Experts

;

Our Training Process

Microsoft Excel - Syllabus, Fees & Duration

Microsoft Excel Course Syllabus


Module 1: Introduction to Excel

  • Overview of Excel interface and ribbon
  • Workbook and worksheet basics
  • Understanding cells, rows, and columns
  • Data entry and editing (numbers, text, and formulas)
  • Saving, opening, and sharing Excel files

Module 2: Basic Excel Functions and Features

  • Using basic formulas and functions (SUM, AVERAGE, MIN, MAX)
  • Understanding absolute, relative, and mixed cell references
  • Formatting cells (font, alignment, number formats)
  • Conditional formatting basics
  • Working with dates and time

Module 3: Managing Data

  • Sorting and filtering data
  • Creating and managing tables
  • Data validation techniques
  • Removing duplicates
  • Working with text (Text to Columns, CONCATENATE, LEFT, RIGHT, MID, TRIM)

Module 4: Data Visualization with Charts

  • Creating basic charts (bar, line, pie, column)
  • Customizing chart elements (titles, legends, axes)
  • Introduction to sparklines
  • Combo charts and secondary axes

Module 5: Intermediate Excel Features

  • Using advanced functions (IF, VLOOKUP, HLOOKUP, INDEX, MATCH)
  • Logical and text functions (LEN, SUBSTITUTE, SEARCH)
  • Working with named ranges
  • PivotTables and PivotCharts
  • Grouping and summarizing data in PivotTables

Module 6: Advanced Excel Techniques

  • Nested functions (e.g., IF with AND/OR, INDEX-MATCH combinations)
  • Advanced conditional formatting rules
  • Data analysis using What-If Analysis (Goal Seek, Scenario Manager)
  • Introduction to Macros (recording and running basic macros)
  • Using Excel with external data sources

Module 7: Data Analysis and Reporting

  • Advanced filtering techniques
  • Creating dashboards with Excel
  • Using Power Query for data transformation
  • Introduction to Power Pivot for data modeling
  • Advanced chart techniques (waterfall, Gantt chart)

Module 8: Collaboration and Productivity

  • Sharing and protecting workbooks
  • Tracking changes and using comments
  • Collaborative editing in Excel (online versions)
  • Workbook and worksheet protection techniques

Module 9: Excel Shortcuts and Best Practices

  • Essential keyboard shortcuts
  • Efficiency tips for faster data entry
  • Avoiding common errors in formulas and data
  • Best practices for creating professional spreadsheets

Module 10: Excel for Specialized Use Cases (Optional)

  • Excel for finance: financial formulas and templates
  • Excel for project management: Gantt charts and trackers
  • Excel for inventory management and logistics
  • Excel for HR: employee trackers and payroll templates

Assessment and Certification

  • Hands-on projects: Build dashboards, analyze datasets, and create reports
  • Quizzes at the end of each module
  • Final practical test
  • Certification upon successful course completion

Download Syllabus - Microsoft Excel
This syllabus is not final and can be customized as per needs/updates
 
10000+
20+
50+
25+

Microsoft Excel Jobs in Perth

Enjoy the demand

Find jobs related to Microsoft Excel in search engines (Google, Bing, Yahoo) and recruitment websites (monsterindia, placementindia, naukri, jobsNEAR.in, indeed.co.in, shine.com etc.) based in Perth, chennai and europe countries. You can find many jobs for freshers related to the job positions in Perth.

  • Data Analyst
  • Financial Analyst
  • Business Analyst
  • Project Manager
  • Accountant
  • Human Resources (HR) Specialist
  • Supply Chain Specialist
  • Marketing Analyst
  • Administrative Assistant
  • Operations Manager

Microsoft Excel Internship/Course Details

Microsoft Excel internship jobs in Perth
Microsoft Excel , . Whether you're managing personal finances, generating professional reports, or working with complex datasets, this course equips you with the tools to excel. Master the art of Microsoft Excel, the world's leading spreadsheet application, with this comprehensive course. Designed for beginners and advanced users alike, this course covers essential skills, advanced functionalities, and real-world applications to help you efficiently analyze data, create reports, and streamline workflows.

Meet a Few of our Industry Experts 🚀 Your Pathway to IT Career

Anurag

Mobile: +91 9446600368
Location: Uttar Pradesh, Online (Perth)
Qualification: Full Stack Python, BCA

Experience: Skills:- Python Django React JS HTML CSS REST APIs SQL Experience Interships:- Django developer at Express Rupya Python Backend developer  more..

Thansi

Mobile: +91 9895490866
Location: Kerala, Online (Perth)
Qualification: Degree

Experience: I have 1+ years of experience currently iam working as a business development manager So I am looking work from  more..

Sanidhaya

Mobile: +91 8301010866
Location: Delhi, Online (Perth)
Qualification: B.tech in Computer Science

Experience: FastApi Django SQL Cassandra Swagger MongoDb Redash Corologix Redis System Design TECHNICAL EXPERIENCE Telkes Technologies November 2023—Present Backend Engineer •  more..

Rupali

Mobile: +91 98474 90866
Location: Thane, Online (Perth)
Qualification: B.E IT

Experience: I have experience in Asp net MVC 1 year 10 month and asp net 10 months total I have 2  more..

Yash

Mobile: +91 91884 77559
Location: Greater Noida, Online (Perth)
Qualification: Pursuing B.Tech

Experience: Research & analysis Editing & proofreading UI UX design experience Attention to detail I have included a link to my  more..

Sonu

Mobile: +91 9895490866
Location: Kolkata, Online (Perth)
Qualification: Bca

Experience: Flutter developer 2 year experience  more..

Yanamala

Mobile: +91 9446600368
Location: nellore , Online (Perth)
Qualification: Graduation

Experience: Html css java script python & experience: fresher  more..

Rahul

Mobile: +91 91884 77559
Location: Kerala, Online (Perth)
Qualification: Diploma

Experience: Gritstone technologies flutter developer Dhanwis techninfo solution flutter developer  more..

Gollapelli

Mobile: +91 98474 90866
Location: Telangana, Online (Perth)
Qualification: Bsc(Computer Science)

Experience: I have practical knowledge on Manual testing and Automation testing |   more..

Ravi

Mobile: +91 8301010866
Location: Ahmedabad , Online (Perth)
Qualification: B.E. computer engineering

Experience: 2 years of experience in frontend development and 1 year as full stack (MERN) developer   more..

Aastha

Mobile: +91 98474 90866
Location: Haryana, Online (Perth)
Qualification: Masters in psychology

Experience: 1) Subject knowledge 2) Excellent communication skills 3) Strong organisational and time management skills 4) Commitment to continuous professional development  more..

Suchismita

Mobile: +91 89210 61945
Location: Uttarakhand, Online (Perth)
Qualification: Master's

Experience: I have worked as junior design engineer In automation field There autocad is required to draft the electrical designs I  more..

Vrushali

Mobile: +91 91884 77559
Location: Gujarat, Online (Perth)
Qualification: I can do the job

Experience: HTML CSS Python developer Django  more..

Athira

Mobile: +91 91884 77559
Location: Kerala, Online (Perth)
Qualification: M.com, Higher diploma in Graphics and 3D Animation

Experience: Design Skills: Digital Art Illustrations Logo design and branding UI UX Design 2D animation 3D modeling and animation Software skills:  more..

Simran

Mobile: +91 8301010866
Location: Haryana, Online (Perth)
Qualification: 12

Experience: As a diligent 12th passout with an impressive 87% in CBSE non-medical coupled with a commendable IELTS score of 7  more..

Vinodha

Mobile: +91 89210 61945
Location: chidambaram, Online (Perth)
Qualification: M.C.A

Experience: java Seleniunm manual testing and Automation testing  more..

Vidhya

Mobile: +91 91884 77559
Location: Kerala, Online (Perth)
Qualification: MCA

Experience: Full stack web development in python Django completed I did 4 projects in my intership program Am a fresher I  more..

HASIM

Mobile: +91 9446600368
Location: West Bengal, Online (Perth)
Qualification: b tech civil

Experience: all details in my resume Please check and last 10 year i draw any type of design   more..

Anoop

Mobile: +91 91884 77559
Location: Kochin, Online (Perth)
Qualification: Bsc computer science

Experience: Skills:python Django HTML JAVASCRIPT CSS MySQL PHPJQUERY EXPERIENCE : I am currently studied in intenship for python fullstack angular development  more..

Gourav

Mobile: +91 8301010866
Location: Haryana, Online (Perth)
Qualification: BCA

Experience: Dart flutter firebase postman git google api  more..

Mangilal

Mobile: +91 91884 77559
Location: Rajasthan, Online (Perth)
Qualification: B. Tech

Experience: Hello This is mangilal I have 1 year hands on experience as laravel developer Am familiar with c c++ php  more..

Harshita

Mobile: +91 89210 61945
Location: Rajasthan, Online (Perth)
Qualification: B. Tech

Experience: Python django html css sql php  more..

Mrunali

Mobile: +91 9895490866
Location: Maharashtra, Online (Perth)
Qualification: BE IT

Experience: Manual testing Automation Testing Selenium with Java SQL C++  more..

Samriti

Mobile: +91 8301010866
Location: Haryana, Online (Perth)
Qualification: Mca

Experience: Python Java C C++ Basics knowledge of html css javascript php  more..

SAI

Mobile: +91 9895490866
Location: Maharashtra, Online (Perth)
Qualification: 3rd year diploma in mechanical

Experience: I'm a graphic designer with over 5 years of experience in the industry I'm a graphic designer who specializes in  more..

Priti

Mobile: +91 89210 61945
Location: Maharashtra, Online (Perth)
Qualification: Bachelor in science in information technology

Experience: I have completed software testing course in manual and automation testing I have knowledge about writing test cases and test  more..

Akshay

Mobile: +91 89210 61945
Location: Kannur, Online (Perth)
Qualification: B tech

Experience: Jr python developerApplication for Python Django  more..

Jomoljohnson

Mobile: +91 91884 77559
Location: Alangad, Online (Perth)
Qualification: Mca

Experience: Currently pursuing python django courseApplication for Python Django  more..

Shankar

Mobile: +91 91884 77559
Location: Madhya Pradesh, Online (Perth)
Qualification: B.TECH

Experience: I have a good knowledge in c c++ programming language and having a good understanding of oops my sql  more..

Rutuja

Mobile: +91 8301010866
Location: Maharashtra, Online (Perth)
Qualification: B. E.

Experience: Currently I am working in Capgemini I got trained and have hands on experience in Java Automation testing (Selenium) SQL  more..

Pooja

Mobile: +91 8301010866
Location: Nasik, Maharashtra, Online (Perth)
Qualification: Bachlore's in Electronics and Telecommunications

Experience: Manual testing Automation Testing Java SQLApplication for Software Testing  more..

Maheshwari

Mobile: +91 8301010866
Location: Karnataka, Online (Perth)
Qualification: BE

Experience: Manual testing SDLC STLC test cases test plan  more..

Sudharani

Mobile: +91 91884 77559
Location: Karnataka, Online (Perth)
Qualification: B,E

Experience: In be full stack Java developer  more..

Neha

Mobile: +91 98474 90866
Location: Gujarat, Online (Perth)
Qualification: Bachelor of engineering

Experience: Hello I'm Neha Lala a Flutter Developer with two years of experience Over the past two years I've been deeply  more..

Ganga

Mobile: +91 91884 77559
Location: Kerala, Online (Perth)
Qualification: Diploma in Architecture

Experience: highly skilled CAD draughtsman with 2 year of experience in creating precise and detailed drawing of high rise residential buildings  more..

Navya

Mobile: +91 91884 77559
Location: Kerala, Online (Perth)
Qualification: MCA

Experience: Dear Hiring Manager I am submitting my resume for the position of Software Tester at your company With my strong  more..

vikas

Mobile: +91 89210 61945
Location: Delhi, Online (Perth)
Qualification: pg-diploma

Experience: I have hands-on experience in linux cloud computing Devops aws bash shell python and i created project that is based  more..

Nidhin

Mobile: +91 9446600368
Location: Tamil Nadu, Online (Perth)
Qualification: B.e

Experience: Html css python and javascript  more..

Ankit

Mobile: +91 89210 61945
Location: Maharashtra, Online (Perth)
Qualification: MSc Statistics

Experience: KPI's testing Azure Salesforce Jira Confluence Netsuite Lead Manager Test case Time Management Team work Team handling Testing Local UAT  more..

Kanchan

Mobile: +91 91884 77559
Location: Maharashtra, Online (Perth)
Qualification: B.E

Experience: This is Kanchan Yadao I have completed my post graduation in this stream of BE-Electronic Engineering I have trained in  more..

Saakshi

Mobile: +91 91884 77559
Location: Maharashtra, Online (Perth)
Qualification: BE mechanical

Experience: AutoCAD Solidworks ansys Arduino python PCB  more..

Hemanth

Mobile: +91 91884 77559
Location: Telangana, Online (Perth)
Qualification: Bachelor's of technology

Experience: I have good skill to work on python and django based applications   more..

Afzal

Mobile: +91 98474 90866
Location: Mumbai, Online (Perth)
Qualification: Bsc IT

Experience: Developed and styled web pages using HTML and CSS ensuring a visually appealing and responsive user interface Working with CSS  more..

Prachi

Mobile: +91 89210 61945
Location: Maharashtra, Online (Perth)
Qualification: Bsc Cs

Experience: Knowledge of Selenium Automation testing Knowledge of STLC SDLC Knowledge of testng Knowledge of maven Fresher |   more..

Nallabelli

Mobile: +91 91884 77559
Location: Telangana, Online (Perth)
Qualification: B.Tech

Experience: Efficient in Python and Java programming Languages Done a project on Fetching Insights from Stock Market data Possess great knowledge  more..

Natheemkhan

Mobile: +91 91884 77559
Location: Tamil Nadu, Online (Perth)
Qualification: M.Com

Experience: Photoshop Coreldraw is essential for executing digital and print designs Additionally knowledge of design principles such as color theory typography  more..

Farhat

Mobile: +91 91884 77559
Location: Maharashtra, Online (Perth)
Qualification: B.Sc (computer science)

Experience: As a computer science graduate and former experience IT instructor at Azam Campus(Pune) I posses strong technical and teaching skills  more..

ISHA

Mobile: +91 9446600368
Location: Uttar Pradesh, Online (Perth)
Qualification: B.Tech (CS)

Experience: Dear Hiring Manager I am writing to express my interest in the Intership at your company As a recent graduate  more..

Pavithra

Mobile: +91 91884 77559
Location: Krishnagiri, Online (Perth)
Qualification: Masters Degree

Experience: Software testing and full stack python development Artificial intelligence Optical Character Recognition Deep learning Machine Learning Data science NLP Augmented  more..

Monish

Mobile: +91 91884 77559
Location: Tamil Nadu, Online (Perth)
Qualification: B.E(Electrical and Electronics Engineering)

Experience: SKILLS HTML CSS Javascript Python programming  more..

Samarth

Mobile: +91 9895490866
Location: Maharashtra, Online (Perth)
Qualification: Bcs media graphics and animation

Experience: Hello team I'm looking for good opportunity for my future I have a 3 years of experience in graphic design  more..

Pranev

Mobile: +91 91884 77559
Location: Nand nagri, Online (Perth)
Qualification: Diploma

Experience: I have 5 year experience in seo field I have knowledge of on page offpage technical seo blackhat seo  more..

Shain

Mobile: +91 9446600368
Location: Thrissur, Kerala, Online (Perth)
Qualification: Btech in Electronics and Communication engineering

Experience: Manual testing automation testing selenium webdriver testNG junit java SQL sdlc stlc test case preparation defect reporting | Resume for  more..

DEVESH

Mobile: +91 9446600368
Location: Rajasthan, Online (Perth)
Qualification: B.COM

Experience: After Completion Of My Secondary School In 2017 I Started My Carrier As An Accountant At Electronics Showroom "Neeta Enterprises"  more..

sarath

Mobile: +91 8301010866
Location: kerala, Online (Perth)
Qualification: diploma engineering

Experience: python django html css bootstrap mysql javascript git github python developer in inmakes infotech kochiApplication for Python Django  more..

Syed

Mobile: +91 9895490866
Location: Andhra Pradesh, Online (Perth)
Qualification: 8.7

Experience: odoo python sql excel - 3months internship (odoo developer)  more..

Athira

Mobile: +91 91884 77559
Location: Ernakulam, Online (Perth)
Qualification: BTech Computer science & engineering

Experience: Technical skills: html css JavaScript core php advanced php(codeigniter laravel) Experience : 1 I have one and half years experience  more..

Suganya

Mobile: +91 91884 77559
Location: Tamil Nadu, Online (Perth)
Qualification: MCA

Experience: i am an Immediate joiner 3 4 years experience in Automation testing and 10 months in Manual Testing Experience in  more..

Himanshu

Mobile: +91 91884 77559
Location: Agra, Online (Perth)
Qualification: B tech

Experience: Html CSS JavaScript Bootstrap manual testing FIGMA | Application for UI UX Designer  more..

Hemavathi

Mobile: +91 91884 77559
Location: Tamil Nadu, Online (Perth)
Qualification: B. Tech

Experience: Software testing I have experience  more..

Success Stories

The enviable salary packages and track record of our previous students are the proof of our excellence. Please go through our students' reviews about our training methods and faculty and compare it to the recorded video classes that most of the other institutes offer. See for yourself how TechnoMaster is truly unique.

Photos of Training / Internships

Internship/projects in perth
Internship/projects in perth
Internship/projects in perth
Internship/projects in perth
Internship/projects in perth
Internship/projects in perth
Internship/projects in perth
Internship/projects in perth
Internship/projects in perth
Internship/projects in perth
Internship/projects in perth
Internship/projects in perth

Trained more than 10000+ students who trust Nestsoft TechnoMaster

Get Your Personal Trainer