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

Ajay

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

Experience: I have one year experience in computer hardware and networking in defence sector   more..

Himanshu

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

Experience: net c# sqlserver asp net mvc html css js  more..

Ramesh

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

Experience: 2 experience in auto cad 2d design |   more..

ARYA

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

Experience: • Managing and Maintaining Backup of Cisco Routers and Switches • Configuring and troubleshooting RIP EIGRP OSPF BGP • Switching  more..

Harshal

Mobile: +91 89210 61945
Location: Maharashtra, Online (Perth)
Qualification: Batchelor of engineering

Experience: QA Engineer (Full-Time) April 2023-Oct 2023 Bitsmith Technology Pvt Ltd Pune ï‚· Performed severaltypes of Testing like Functional Testing Integration  more..

Navjot

Mobile: +91 98474 90866
Location: Maharashtra, Online (Perth)
Qualification: M.tech

Experience: I am very good in html css and wordpress I made website for my client I also have knowledge of  more..

Pranali

Mobile: +91 98474 90866
Location: Maharashtra, Online (Perth)
Qualification: BE Computer

Experience: Html sql dbms c++ manual testing java  more..

Bablu

Mobile: +91 91884 77559
Location: Madhya Pradesh, Online (Perth)
Qualification: BCA

Experience: IT hardware and networking DHCP Sop Lan Wan Switching Routing |   more..

Pooja

Mobile: +91 89210 61945
Location: Gujarat, Online (Perth)
Qualification: MCA, B.Ed, BCA

Experience: I have an experience of 3 5 yearsp in teaching I know different programming languages like python c++ etc I  more..

shachi

Mobile: +91 9446600368
Location: Chandigarh, Online (Perth)
Qualification: post graduate

Experience: Being a topper in BFA and MFA I have always been passionate about art and art history currently i am  more..

RAJKUMAR

Mobile: +91 89210 61945
Location: Karnataka, Online (Perth)
Qualification: Diploma

Experience: A strong foundation as a graphic designer skills is essential for creating visually appealing and effective designs This includes my  more..

Anindita

Mobile: +91 9446600368
Location: West Bengal, Online (Perth)
Qualification: Diploma in Architecture

Experience: I have 3 years experience in architectural design planning of residential projects worked on Australia based residential projects Have 5  more..

ragul

Mobile: +91 8301010866
Location: Tamil Nadu, Online (Perth)
Qualification: BE/EEE

Experience: I have 1 9 years of experience in Software tester Manual testing and Automation testing |   more..

rana

Mobile: +91 98474 90866
Location: Pakistan Islamabad , Online (Perth)
Qualification: Bachelor

Experience: web developer   more..

Arati

Mobile: +91 98474 90866
Location: Maharashtra, Online (Perth)
Qualification: BE computer

Experience: Good understanding of STLC SDLC black box testing test case execution   more..

manisha

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

Experience: Manual Testing Functional Testing SDLC STLC Java oops selenium Retesting regression testing Maven POM Test case Agile |   more..

Omkar

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

Experience: Dear hiring manager My technical skills a manual testing & automation testing please consider my name I found 100+ bugs  more..

Nagalatha

Mobile: +91 91884 77559
Location: Karnataka, Online (Perth)
Qualification: M.Sc

Experience: I have skills in curriculum development lesson planning and student assessment I am expertise in creating a nurturing and stimulating  more..

Tibin

Mobile: +91 98474 90866
Location: kollam, Online (Perth)
Qualification: M.sc Computer Science

Experience: HTML CSS Bootstrap python-django php javascriptApplication for Python Django  more..

Krupali

Mobile: +91 9895490866
Location: Gujarat, Online (Perth)
Qualification: B.C.A.

Experience: Manual testing and basic knowledge of automation using selenium 1 year experience as a Software Qa tester and 8 year  more..

Manoj

Mobile: +91 91884 77559
Location: Andhra Pradesh, Online (Perth)
Qualification: Btech

Experience: android developer firebase retrofit java kotlin flutter dart  more..

Aiswarya

Mobile: +91 91884 77559
Location: Kerala, Online (Perth)
Qualification: Btech Electronics and communication

Experience: Manual testing Scrum methodologies SDLC Life cycle STLC life cycle test case preparation Bug report preparation testing levels testing types  more..

Vinit

Mobile: +91 9446600368
Location: Gujarat, Online (Perth)
Qualification: B.Tech in Computer Engineering

Experience: My skills include problem identification information gathering evaluation development and result calculation essential for effective decision-making and problem-solving   more..

Lakshmipriya

Mobile: +91 91884 77559
Location: ernakulam, Online (Perth)
Qualification: b.tech

Experience: software testing trainee at camerinfolks Pvt Ltd Ernakulam  more..

nagu

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

Experience: hardware and networking mcse ccna  more..

Vartika

Mobile: +91 89210 61945
Location: Hyderabad , Online (Perth)
Qualification: M.Tech CSE

Experience: I am a skilled MLE working in S&P 500 company Factset from last 3+ year I am quite acquainted with  more..

Rajat

Mobile: +91 98474 90866
Location: Haryana, Online (Perth)
Qualification: Bachelor of technology

Experience: Manual testing automation testing agile model sql java |   more..

Abarna

Mobile: +91 98474 90866
Location: Puducherry, Online (Perth)
Qualification: B tech(IT)

Experience: Manual testing SQL Exp: 3 years |   more..

Ramathota

Mobile: +91 89210 61945
Location: Andhra Pradesh, Online (Perth)
Qualification: Btech

Experience: Experience I have over 1 5 years of focused experience in UI UX design starting with internships that transitioned into  more..

Suryazi

Mobile: +91 89210 61945
Location: Andhra Pradesh, Online (Perth)
Qualification: Bachelor of Computer Applications

Experience: Systems analyst with over 14+ years of experience in information technology and networking Highly familiar with a wide variety of  more..

Lakshmi

Mobile: +91 8301010866
Location: Delhi, Online (Perth)
Qualification: Masters in Psychology (current)

Experience: At iKroya Tech launched by the founders of NDTV Dr Prannoy Roy & Mrs Radhika Roy I’ve handled various responsibilities  more..

Alok

Mobile: +91 8301010866
Location: Maharashtra, Online (Perth)
Qualification: Bachelor of computer applications

Experience: AWS CCNA python - I am certified of all these courses also am having 1 + year experience working on  more..

Rimita

Mobile: +91 9446600368
Location: West Bengal, Online (Perth)
Qualification: Graduate

Experience: Pro in logo design and graphic design with 10 years experience in the graphic design field |   more..

Subham

Mobile: +91 8301010866
Location: West Bengal, Online (Perth)
Qualification: B.Tech In Information Technology

Experience: Some of My technical skills include Programming Languages-C C++ python Javascript I also have skills in Frontend Technologies   more..

Anju

Mobile: +91 9446600368
Location: Ernakulam , Online (Perth)
Qualification: Btech (EC)

Experience: Have basic knowledge of programming languages like c c++ java Have basic knowledge of html css Have basic knowledge of  more..

Lavanya

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

Experience: Experienced in Software Manual Testing with different test environment like Mainframe testing COBOL coding JCL SQL Application testing in different  more..

Mohit

Mobile: +91 98474 90866
Location: Uttar Pradesh, Online (Perth)
Qualification: Masters in computer applications

Experience: I'm a DevOps Engineer with over one year and eleven months of experience I specialise in crafting and maintaining resilient  more..

Waqar

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

Experience: Expert in social media post design print work and logo making  more..

Athira

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

Experience: Java python html css  more..

Pooja

Mobile: +91 91884 77559
Location: Jaipur Rajasthan mansarovar, Online (Perth)
Qualification: Post graduation M com

Experience: Motions graphic designer video Editor content editor developer  more..

Vaishali

Mobile: +91 9446600368
Location: Uttarakhand, Online (Perth)
Qualification: Diploma in graphic design

Experience: Hello there! I'm vaishali a passionate graphic designer with a love for transfarming ideas into visual stories I've had the  more..

PRASANTH

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

Experience: Hii Mam Sir With seven years of expertise I have developed comprehensive skills in photography videography acrylic painting fashion design  more..

Yogesh

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

Experience: • Proficient in React JavaScript HTML CSS • Familiar with Redux Tailwind SASS • Experience with Node js Express  more..

dhanshree

Mobile: +91 91884 77559
Location: Madhya Pradesh, Online (Perth)
Qualification: B.E. in computer science

Experience: manual testing test case writing automation testing worked as a software tester in cybage pune for 3 year attended testing  more..

Sumera

Mobile: +91 9446600368
Location: Telangana, Online (Perth)
Qualification: MSc BEd, MA English

Experience: I am excited to apply for the English tutor position currently open at your organization With over seven years of  more..

Arunkumar

Mobile: +91 89210 61945
Location: Tirunelveli, Online (Perth)
Qualification: BTECH IT

Experience: i am a frontend developer who i has 2 yeaApplication for Meanstack Developer Mean Stack  more..

Ramya

Mobile: +91 8301010866
Location: Kerala, Online (Perth)
Qualification: MSc, BEd

Experience: I have 11 years of experience in three different curriculum (State board ICSE ISC CBSE Cambridge) IELTS – 6 band  more..

Priya

Mobile: +91 91884 77559
Location: Chennai, Online (Perth)
Qualification: BSC

Experience: Manual testing JIRA Selenium webdriver Postman | Resume for   more..

Muhammed

Mobile: +91 9895490866
Location: Kerala, Online (Perth)
Qualification: b.tech

Experience: As a mechanical engineer I possess extensive experience with AutoCAD SolidWorks and Fusion 360 for detailed design and modeling My  more..

PARTHIBAN

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

Experience: I have extensive experience in developing and implementing security policies protocols and procedures My skills in conducting vulnerability assessments penetration  more..

Mohamed

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

Experience: Vulnerability assessment and penetration tester (vapt) trainee at Ehackify kochi Intern at ehackify Kochi Black and white box testing penetration  more..

Raunaq

Mobile: +91 9895490866
Location: Delhi, Online (Perth)
Qualification: Btech

Experience: I am a highly motivated and skilled IT professional with a strong background in network security penetration testing and malware  more..

Pooja

Mobile: +91 98474 90866
Location: Maharashtra, Online (Perth)
Qualification: BCA

Experience: Proficient in OSINT for gathering and analyzing data Skilled in Linux admin for robust security Well-versed in ethical hacking for  more..

Manish

Mobile: +91 9895490866
Location: Lucknow, Online (Perth)
Qualification: Bsc

Experience: Node js 4 years react js 2 4 years mongodb MySQL express css html  more..

Bikram

Mobile: +91 9895490866
Location: Odisha, Online (Perth)
Qualification: MCA

Experience: I know the the programming language like HTML CSS Java script python Java php SQL  more..

Deepesh

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

Experience: Deepesh has an overall 2 10 YOE as a Developer Automation tester in Deloitte’s Financial Services He has experience in  more..

Sabin

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

Experience: python Django Framework front end-HTML CSS JAVASCRIPT BOOTSTRAP TKINTER BACKEND-MYSQL  more..

Sahitya

Mobile: +91 89210 61945
Location: Karnataka, Online (Perth)
Qualification: MCA

Experience: i am fresher skills are python mysql html css  more..

Aleesha

Mobile: +91 98474 90866
Location: Kayamkulam, Online (Perth)
Qualification: Btech

Experience: Manual testing:smoke sanity exploratory testing Core java SQL javascript Test plan cases and process preparation of bug report  more..

Kalyani

Mobile: +91 8301010866
Location: Uttar Pradesh, Online (Perth)
Qualification: Bechelor of Technology

Experience: C programming plc pcb Microsoft office | Resume for IT Counselor (Work from Home) Hindi Tamil Malayalam  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